Backing up and restoring PostgreSQL database

From Notes_Wiki

Home > CentOS > CentOS 6.x > PostgreSQL configuration > Backing up and restoring PostgreSQL database

Backing up PostgreSQL database

To backup PostgreSQL database use:

pg_dump -U <user-name> -d <database-name> > <file-name>

Restoring PostgreSQL database dump

To restore database dump use:

psql -U <user-name&gtl -d <database-name> < <file-name>

Note that attempts to use 'pg_restore' to restore dump failed hence above method is suggested.

Home > CentOS > CentOS 6.x > PostgreSQL configuration > Backing up and restoring PostgreSQL database

Retrieved from "http://www.sbarjatiya.com/notes_wiki/index.php?title=Backing_up_and_restoring_PostgreSQL_database&oldid=5416"