PostgreSQL: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
a link, some notes, replaced old-style header with smw
createdb
Line 5: Line 5:
==About==
==About==
{{seed}}
{{seed}}
==Commands==
* {{l/sub|createdb}}
==Links==
==Links==
* {{l/wp/ref}}
* {{l/wp/ref}}

Revision as of 14:33, 14 January 2018

<hide> page type::article thing type::database server </hide>

About

<hide>

 page status::seed

</hide>

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!

Commands

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.