It seems that every Postgres tutorial on the internet involves SSHing into instances and arduously setting up the database by hand. The setups are fragile, and if the server went down you would have to set everything up by hand again and then deal with data loss.
How does one automate the creation and management of a Postgres deployment? Does anyone use Ansible or Docker?
Services like RDS and databaselabs.io offer Postgres with automatic backups, replication, etc via a console - how do they manage it?
How does one automate the creation and management of a Postgres deployment? Does anyone use Ansible or Docker?
Services like RDS and databaselabs.io offer Postgres with automatic backups, replication, etc via a console - how do they manage it?
How do you manage yours?