PostgreSQL database backup-restore
Postgresql database backups and restore
In this article how to dul postgresql database backup and restore. Something easier to do than to say.
First you need to play the role of user with privileges in the db. Typically ' root ' is not enabled.
# su postgres
$ pg_dump dump db_to_be_dumped > dumpfile.
Now you have the dump database "db_to_be_dumped" in the user's home directory postgres.
To restore must be performed, always as an administrator user of db:
$ psql db_to_be_restored <. dump dumpfile
Postgresql.org wiki from great tips for system engineering aspects: invitation to look with this link: http://wiki.postgresql.org/wiki/Automated_Backup_on_Linux