Editing Postgres basics

Get postgres prompt

su postgres<br>
psql<br>
postgres=#<br>

su postgres<br>
psql <dbname><br>

[edit] List databases<br>

postgres=# \l<br>

[edit] List users<br>

postgres=# \du<br>

[edit] Dump a database<br>

su postgres<br>
pg_dump <dbname> > db.out<br>

[edit] Import a database<br>

su postgres<br>
psql -d <dbname> -f db.out<br>

[edit] Create role<br>

createuser -S -D -R <role_name><br>

PG RESTORE COMMAND<br>
------------------<br>
pg_restore -h localhost -U origami_dbadmin -d kvvs -W kvvs_20170316_22_00_01.tar<br>


PG DUMP COMMAND<br>
-------------------<br>
pg_dump -Ft -U origami_dbadmin ddugky_misdbnew -x -O -f "/var/www/html/ddugky_mis_2/ddugky_misdb.tar"<br>


PG DUMP WITHOUT VERSION PROBLEMS (plain format dump file)<br>
------------------------------------------------------------<br>
pg_dump -f ddugky_misdbnew.db -F p -U origami_dbadmin ddugky_misdbnew<br>
pg_dump -U username dbname > dump.sql<br>


PG RESTORE WITHOUT VERSION PROBLEMS (plain format dump file)<br>
------------------------------------------------------------<br>
psql -f ddugky_misdbnew.db dd_misdb origami_dbadmin<br>



[[category:it-support]]