Difference between revisions of "PostgreSQL"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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.