PostgreSQL

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

• createdb
• createuser
• dropuser

Links

• Wikipedia
• official
  • Chapter 25. Backup and Restore
• PostgreSQL command line cheatsheet

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.