Jump to navigation Jump to search
To backup a database:
su - postgres -c 'pg_dump <database name> ' > <output_file.sql>
- Presumably "postgres" is the postgres "superuser"? Or it may be the user that "owns" the database, in which case change it to whatever is appropriate.