Skip to main content
SpringerLink
Log in
Apress
Book cover

Beginning PostgreSQL on the Cloud

Simplifying Database as a Service on Cloud Platforms

  • Book
  • © 2018

Overview

Authors:
  1. Baji Shaik

    1. Hyderabad, India

    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Avinash Vallarapu

    1. Hyderabad, India

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • The first book purely focused on PostgreSQL implementations on the cloud

  • Covers migration from on-premise PostgreSQL to PostgreSQL on the cloud

  • Includes tips on securing and encrypting your cloud data

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 79.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xx
    Download chapter PDF

  2. Introduction to Databases in the Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 1-31

  3. PostgreSQL Architecture

    • Baji Shaik, Avinash Vallarapu
    Pages 33-61

  4. Amazon Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 63-105

  5. Rackspace Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 107-132

  6. Google Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 133-167

  7. Azure Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 169-197

  8. Security on the Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 199-234

  9. Backups on the Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 235-269

  10. Replication and High Availability on the Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 271-291

  11. Encryption on the Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 293-308

  12. Connection Pooling on the Cloud

    • Baji Shaik, Avinash Vallarapu
    Pages 309-334

  13. Monitoring Cloud Databases

    • Baji Shaik, Avinash Vallarapu
    Pages 335-372

  14. Back Matter

    Pages 373-381
    Download chapter PDF
Back to top

Keywords

About this book

Get started with PostgreSQL on the cloud and discover the advantages, disadvantages, and limitations of the cloud services from Amazon, Rackspace, Google, and Azure. Once you have chosen your cloud service, you will focus on securing it and developing a back-up strategy for your PostgreSQL instance as part of your long-term plan. Beginning PostgreSQL on the Cloud covers other essential topics such as setting up replication and high availability; encrypting your saved cloud data; creating a connection pooler for your database; and monitoring PostgreSQL on the cloud. The book concludes by showing you how to install and configure some of the tools that will help you get started with PostgreSQL on the cloud. 


This book shows you how database as a service enables you to spread your data across multiple data centers, ensuring that it is always accessible. You’ll discover that this model does not expect you to install and maintain databases yourself because the database service provider does it for you. You no longer have to worry about the scalability and high availability of your database.


What You Will Learn
  • Migrate PostgreSQL to the cloud
  • Choose the best configuration and specifications of cloud instances
  • Set up a backup strategy that enables point-in-time recovery 
  • Use connection pooling and load balancing on cloud environments
  • Monitor database environments on the cloud



Who This Book Is For


Those who are looking to migrate to PostgreSQL on the Cloud. It will also help database administrators in setting up a cloud environment in an optimized way and help them with their day-to-day tasks.


Authors and Affiliations

  • Hyderabad, India

    Baji Shaik, Avinash Vallarapu

About the authors

Baji Shaik is a database administrator and developer. He was introduced to databases in 2011 and over the years, has worked with Oracle, PostgreSQL, and Greenplum. He has a wide range of expertise and experience in SQL/NoSQL databases and has developed many successful database solutions addressing challenging business requirements. He has been working with a database service, where he continuously supports databases in automation and helps in developing features, fixing and testing defects of the service. Baji has organized a number of PostgreSQL meet-ups and maintains his own technical blog at bajis-postgres.blogspot.in, where he likes to share his knowledge with the community. He co-authored PostgreSQL Development Essentials, released in September 2016.




Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation