Beginning PostgreSQL on the Cloud

Simplifying Database as a Service on Cloud Platforms

  • Baji Shaik
  • Avinash Vallarapu

Table of contents

  1. Front Matter
    Pages i-xx
  2. Baji Shaik, Avinash Vallarapu
    Pages 1-31
  3. Baji Shaik, Avinash Vallarapu
    Pages 33-61
  4. Baji Shaik, Avinash Vallarapu
    Pages 63-105
  5. Baji Shaik, Avinash Vallarapu
    Pages 107-132
  6. Baji Shaik, Avinash Vallarapu
    Pages 133-167
  7. Baji Shaik, Avinash Vallarapu
    Pages 169-197
  8. Baji Shaik, Avinash Vallarapu
    Pages 199-234
  9. Baji Shaik, Avinash Vallarapu
    Pages 235-269
  10. Baji Shaik, Avinash Vallarapu
    Pages 271-291
  11. Baji Shaik, Avinash Vallarapu
    Pages 293-308
  12. Baji Shaik, Avinash Vallarapu
    Pages 309-334
  13. Baji Shaik, Avinash Vallarapu
    Pages 335-372
  14. Back Matter
    Pages 373-381

About this book

Introduction

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.

You will:
  • 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

Keywords

postgresql cloud migration deployment database maintenance azure googlecloud rackspace amazoncloud dbaas iaas

Authors and affiliations

  • Baji Shaik
    • 1
  • Avinash Vallarapu
    • 2
  1. 1.HyderabadIndia
  2. 2.HyderabadIndia

Bibliographic information

  • DOI https://doi.org/10.1007/978-1-4842-3447-1
  • Copyright Information Baji Shaik, Avinash Vallarapu 2018
  • Publisher Name Apress, Berkeley, CA
  • eBook Packages Professional and Applied Computing
  • Print ISBN 978-1-4842-3446-4
  • Online ISBN 978-1-4842-3447-1
  • About this book
Industry Sectors
Pharma
Chemical Manufacturing
Biotechnology
Electronics
Telecommunications
Consumer Packaged Goods
Energy, Utilities & Environment