Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
how do you get pg_dump to offload dumps to s3? – dan May 23 '12 at 17:07
Have pg_dump dump the backup sql. Use scripts like ( ) or s3cmd ( ) to push the dump to S3 bucket. – Shyam Sundar C S May 23 '12 at 17:10

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.