Difference between revisions of "PostgreSQL"
Jump to navigation
Jump to search
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
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
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.