Ok, I'm quite new to this server administration stuff. I have set up an ec2 instance running my website. I'm running everything on a single machine - node.js & postgres. What is the best way to backup my postgres db?
Thanks for your h
One of the easiest and recommended ways is to use *pg_dump*. It makes consistent backups even if the database is being used concurrently.
Script *pg_dump* to offload dumps to S3 bucket. Setup the script to be run using crontab on a hourly basis.
You can use pgAdmin to backup your databases:
It's very easy. Login to localhost or hostname if remote. After setting up your connection in pgAdmin, goto Server Groups->Servers->PostgreSQL 9.0 (localhost:5432)->database. Drop-down menu and select backup. Enter filename. Hit OK. Backup done.