How do I backup a pgsql/PostgreSQL database?
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.