PostgreSQL
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
About
This page is a seed article. You can help HTYP water it: make a request to expand a given page and/or donate to help give us more writing-hours!
|
Pages
How To
- admin: administration stuff
Commands
Links
Notes
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.