Backing up and restoring PostgreSQL database
From Notes_Wiki
<yambe:breadcrumb>Postgresql_configuration|Postgresql configuration</yambe:breadcrumb>
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>l -d <database-name> < <file-name>
Note that attempts to use 'pg_restore' to restore dump failed hence above method is suggested.
