This post will help you with easy, cost-effective and secure way to backup your PostgreSQL database to cloud. Create local scheduled backup of PostgreSQL database Login as postgres user on the console (tmux is recommended). Create .pgpass file to access database without entering credentials manually. $ nano .pgpass Enter the credentials in the following format. Making changes according to the host if necessary. localhost:5432:dbname:dbusername:dbpassword Set permissions to the file. login_use...
