How do I backup a pgsql/PostgreSQL database?

~ 0 min

To get a list of all databases on PostgreSQL su to the postgres user:


su - postgres


Once you have switched to the postgres user simply issue the following command to backup the database.


pg_dump <database> > <databasebackup.sql>

You should now have a complete backup of the database content.

Average rating 0 (0 Votes)

You cannot comment on this entry