Backing up and restoring PostgreSQL database

From Notes_Wiki
Revision as of 07:19, 6 March 2022 by Saurabh (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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"