Difference between revisions of "PostgreSQL"
Jump to navigation
Jump to search
(createdb) |
(→Commands: more of them) |
||
| Line 7: | Line 7: | ||
==Commands== | ==Commands== | ||
* {{l/sub|createdb}} | * {{l/sub|createdb}} | ||
| + | * {{l/sub|createuser}} | ||
| + | * {{l/sub|dropuser}} | ||
| + | |||
==Links== | ==Links== | ||
* {{l/wp/ref}} | * {{l/wp/ref}} | ||
Revision as of 19:05, 14 January 2018
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!
|
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.