PostgreSQL can be self hosted on any server or can be hosted by cloud providers as DAAS(Database As Service). Cloud providers like AWS RDS, Heroku, Google cloud etc provides DAAS for PostgreSQL. When we use hosted database it gives us advantages and disadvantages.
In this talk I’ll go through our story of why we migrated from AWS RDS and moved to self hosted PostgreSQL, what were challenges, how we migrated, what after migration and in the end our learning from this setup. This talk will also cover how we implemented high availability, disaster recovery, backups and PITR recovery.