PostgreSQL

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

About

This is a seed article. You can help HTYP grow by watering it.

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.