PostgreSQL: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
No edit summary |
a link, some notes, replaced old-style header with smw |
||
| Line 1: | Line 1: | ||
[[ | <hide> | ||
[[page type::article]] | |||
[[thing type::database server]] | |||
</hide> | |||
==About== | |||
{{seed}} | |||
==Links== | ==Links== | ||
* [http://www.postgresql.org/ | * {{l/wp/ref}} | ||
* [http://www.postgresql.org/ official] | |||
** [https://www.postgresql.org/docs/current/static/backup-dump.html Chapter 25. Backup and Restore] | |||
==Notes== | ==Notes== | ||
To backup a database: | To backup a database: | ||
* <code>su - postgres -c 'pg_dump {{arg|database name}} ' > {{arg|output_file.sql}} | * <code>su - postgres -c 'pg_dump {{arg|database name}} ' > {{arg|output_file.sql}}</code> | ||
** Presumably "postgres" is the postgres "superuser"? | ** 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. | ||
Revision as of 13:47, 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!
|
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.
