How do I back up and restore the PostgreSQL database?

PostgreSQL Database Backup

  1. Start->all programs->postgreSQL->PGAdmin III
  2. Double-click on PostgreSQL Database Server 8.2 (or 9.2)
  3. Login with amber as the password (unless you've changed it)
  4. Once logged in, expand the directory until you can highlight the amber database and do a back-up (use the settings below)

Restoring PostgreSQL Database 

  1. Start->All Programs->Postgress->PGAdmin III
  2. Double-click on PostgreSQL Database Server 8.2 (or 9.2)
  3. Login w/amber as the password (unless you've changed it)
  4. Once logged in, expand til you can highlight the amber database
  5. Right Click amber and restore database