Archive for backup

Postgresql backup and restore

December 23, 2008 at 13:10 · Filed under tech and tagged: , ,

To backup all databases on the server:

  1. su – postgres
  2. pg_dumpall > db.backup

To restore from previously created backup:

  1. su – postgres
  2. psql -f db.backup

Comments