Complete tutorial on how to self-host PostgreSQL instance for production usage with TLS.

In this tutorial we will create a bash script to automate postgres database backup from a docker container and native postgres installation then upload to S3 based storage system.

In this tutorial we are gonna use docker exec and cp command along with pg_dump to take Postgres database backup from docker container.

Learn how to backup and restore PostgreSQL database dump in Ubuntu (Linux) and Mac.