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 |
No edit summary |
||
| Line 5: | Line 5: | ||
==About== | ==About== | ||
{{seed}} | {{seed}} | ||
==Commands== | ==Pages== | ||
===How To=== | |||
* {{l/sub|admin}}: administration stuff | |||
===Commands=== | |||
* {{l/sub|createdb}} | * {{l/sub|createdb}} | ||
* {{l/sub|createuser}} | * {{l/sub|createuser}} | ||
Latest revision as of 23:01, 7 November 2022
<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!
|
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.
