PostgreSQL - Revision history

Woozle at 23:01, 7 November 2022

2022-11-07T23:01:49Z

← Older revision		Revision as of 23:01, 7 November 2022
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}}

2018-04-14T00:37:43Z

← Older revision		Revision as of 00:37, 14 April 2018
Line 14:		Line 14:
	* [http://www.postgresql.org/ official]		* [http://www.postgresql.org/ official]
	** [https://www.postgresql.org/docs/current/static/backup-dump.html Chapter 25. Backup and Restore]		** [https://www.postgresql.org/docs/current/static/backup-dump.html Chapter 25. Backup and Restore]
			* [https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546 PostgreSQL command line cheatsheet]
	==Notes==		==Notes==
	To backup a database:		To backup a database:
	* <code>su - postgres -c 'pg_dump {{arg\|database name}} ' > {{arg\|output_file.sql}}</code>		* <code>su - postgres -c 'pg_dump {{arg\|database name}} ' > {{arg\|output_file.sql}}</code>
	** 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.		** 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.

2018-01-14T19:05:53Z

Commands: more of them

2018-01-14T14:33:17Z

createdb

2018-01-14T13:47:37Z

a link, some notes, replaced old-style header with smw

← Older revision		Revision as of 13:47, 14 January 2018
Line 1:		Line 1:
	[[~~Computing~~]]: [[~~Software]]~~: ~~[[Database Engines]]~~: ~~[[PostgreSQL~~]]{{seed}}		<hide>
			[[page type::article]]
			[[thing type::database server]]
			</hide>
			==About==
			{{seed}}
	==Links==		==Links==
	* [http://www.postgresql.org/ ~~PostgreSQL~~] ~~home page~~		* {{l/wp/ref}}
			* [http://www.postgresql.org/ official]
			** [https://www.postgresql.org/docs/current/static/backup-dump.html Chapter 25. Backup and Restore]
	==Notes==		==Notes==
	To backup a database:		To backup a database:
	* <code>su - postgres -c 'pg_dump {{arg\|database name}} ' > {{arg\|output_file.sql}}		* <code>su - postgres -c 'pg_dump {{arg\|database name}} ' > {{arg\|output_file.sql}}</code>
	** Presumably "postgres" is the postgres "superuser"?		** 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.

2018-01-14T12:48:05Z

← Older revision		Revision as of 12:48, 14 January 2018
Line 2:		Line 2:
	==Links==		==Links==
	* [http://www.postgresql.org/ PostgreSQL] home page		* [http://www.postgresql.org/ PostgreSQL] home page
			==Notes==
			To backup a database:
			* <code>su - postgres -c 'pg_dump {{arg\|database name}} ' > {{arg\|output_file.sql}}
			** Presumably "postgres" is the postgres "superuser"?

2005-11-08T23:11:24Z

New page

[[Computing]]: [[Software]]: [[Database Engines]]: [[PostgreSQL]]{{seed}}
==Links==
* [http://www.postgresql.org/ PostgreSQL] home page