Postgres basics - Revision history

WikiAdmiN at 07:54, 13 June 2021

2021-06-13T07:54:41Z

WikiAdmiN at 07:54, 13 June 2021

2021-06-13T07:54:02Z

WikiAdmiN at 07:53, 13 June 2021

2021-06-13T07:53:02Z

imported>Kishor: Created page with "Get postgres prompt su postgres
psql
postgres=#
su postgres
psql
[edit] List databases
postgres=# \l
[edit] List users
postgres=..."

2017-06-16T09:20:23Z

Created page with "Get postgres prompt su postgres psql postgres=# su postgres psql <dbname> [edit] List databases postgres=# \l [edit] List users postgres=..."

New page

Get postgres prompt

su postgres 
psql 
postgres=# 

su postgres 
psql <dbname> 

[edit] List databases 

postgres=# \l 

[edit] List users 

postgres=# \du 

[edit] Dump a database 

su postgres 
pg_dump <dbname> > db.out 

[edit] Import a database 

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

[edit] Create role 

createuser -S -D -R <role_name> 

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

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

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

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

[[category:it-support]]

@@ Line 57: / Line 57: @@
   psql
   CREATE DATABASE mykalamasserydb
-  CREATE USER mykalauser WITH ENCRYPTED PASSWORD 'MyKalaPass';
+  CREATE USER mykalauser WITH ENCRYPTED PASSWORD 'pass';
   GRANT ALL PRIVILEGES ON DATABASE mykalamasserydb TO mykalauser;
   \q

← Older revision		Revision as of 07:54, 13 June 2021
Line 51:		Line 51:


		+	== Restoration Command Summary==

	sudo -i		sudo -i

← Older revision		Revision as of 07:53, 13 June 2021
Line 51:		Line 51:


		+
		+	sudo -i
		+	su postgres
		+	psql
		+	CREATE DATABASE mykalamasserydb
		+	CREATE USER mykalauser WITH ENCRYPTED PASSWORD 'MyKalaPass';
		+	GRANT ALL PRIVILEGES ON DATABASE mykalamasserydb TO mykalauser;
		+	\q
		+	gzip -d mykalamassery_06_13_2021.sql.gz
		+	psql -U mykalauser -d mykalamasserydb -f mykalamassery_06_13_2021.sql

	[[category:it-support]]		[[category:it-support]]

Postgres basics - Revision history

WikiAdmiN at 07:54, 13 June 2021

WikiAdmiN at 07:54, 13 June 2021

WikiAdmiN at 07:53, 13 June 2021

imported>Kishor: Created page with "Get postgres prompt su postgres psql postgres=# su postgres psql [edit] List databases postgres=# \l [edit] List users postgres=..."

imported>Kishor: Created page with "Get postgres prompt su postgres
psql
postgres=#
su postgres
psql
[edit] List databases
postgres=# \l
[edit] List users
postgres=..."