Postgresql - Revision history

Tony at 14:36, 2 April 2025

2025-04-02T14:36:34Z

← Older revision		Revision as of 14:36, 2 April 2025
Line 6:		Line 6:
	=Documentation=		=Documentation=
	*[https://www.postgresqltutorial.com/postgresql-administration/ Postgresql Administration]		*[https://www.postgresqltutorial.com/postgresql-administration/ Postgresql Administration]

			=Cheatsheet=
			==Describe table==
			\d table

	=Installation=		=Installation=

2023-10-22T12:57:06Z

Links

← Older revision		Revision as of 12:57, 22 October 2023
Line 3:		Line 3:
	*[http://www.freebsddiary.org/postgresql.php Postgresql on freebsd]		*[http://www.freebsddiary.org/postgresql.php Postgresql on freebsd]
	*[http://www.pgbarman.org/ Backups for postgresql]		*[http://www.pgbarman.org/ Backups for postgresql]

			=Documentation=
			*[https://www.postgresqltutorial.com/postgresql-administration/ Postgresql Administration]

	=Installation=		=Installation=

2023-10-01T20:06:09Z

Back up postgresql databases

← Older revision		Revision as of 20:06, 1 October 2023
Line 21:		Line 21:
	==Back up postgresql databases==		==Back up postgresql databases==
	*[https://www.postgresql.org/docs/current/backup.html Backup and Restore]		*[https://www.postgresql.org/docs/current/backup.html Backup and Restore]

			pg_restore --disable-triggers --clean -d davical /tmp/davical

	=FAQ=		=FAQ=
	==Create user==		==Create user==

2023-08-27T16:02:19Z

← Older revision		Revision as of 16:02, 27 August 2023
Line 18:		Line 18:
	Ater which it should be possible to run ( as root again)		Ater which it should be possible to run ( as root again)
	/usr/local/etc/rc.d/postgresql start		/usr/local/etc/rc.d/postgresql start
			=HOWTO=
			==Back up postgresql databases==
			*[https://www.postgresql.org/docs/current/backup.html Backup and Restore]
	=FAQ=		=FAQ=
	==Create user==		==Create user==

2019-05-10T11:08:35Z

FAQ

← Older revision		Revision as of 11:08, 10 May 2019
Line 37:		Line 37:

	==List users==		==List users==
	su to postgres, psql and then \du		su to postgres, psql and then
			\du


			==Delete user==
			drop user

2019-05-10T10:59:22Z

Create user

← Older revision		Revision as of 10:59, 10 May 2019
Line 23:		Line 23:
	su - postgres		su - postgres
	createuser		createuser


			or in psql:
			CREATE DATABASE yourdbname
			CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass'
			GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser

	==ERROR: character 'xxx' of encoding "UTF8" has no equivalent in "LATIN9" locale==		==ERROR: character 'xxx' of encoding "UTF8" has no equivalent in "LATIN9" locale==

2017-11-03T10:25:38Z

FAQ

← Older revision		Revision as of 10:25, 3 November 2017
Line 29:		Line 29:
	show client_encoding		show client_encoding
	\encoding		\encoding

			==List users==
			su to postgres, psql and then \du

2016-05-20T10:23:44Z

← Older revision		Revision as of 10:23, 20 May 2016
Line 2:		Line 2:
	*[http://www.postgresql.org/ Homepage]		*[http://www.postgresql.org/ Homepage]
	*[http://www.freebsddiary.org/postgresql.php Postgresql on freebsd]		*[http://www.freebsddiary.org/postgresql.php Postgresql on freebsd]
			*[http://www.pgbarman.org/ Backups for postgresql]

	=Installation=		=Installation=

2013-12-04T14:38:03Z

← Older revision		Revision as of 14:38, 4 December 2013
Line 22:		Line 22:
	su - postgres		su - postgres
	createuser		createuser

			==ERROR: character 'xxx' of encoding "UTF8" has no equivalent in "LATIN9" locale==
			Check
			show server_encoding
			show client_encoding
			\encoding

2009-03-03T08:31:24Z

Postgresql on freebsd

← Older revision		Revision as of 08:31, 3 March 2009
Line 8:		Line 8:
	*http://www.freebsddiary.org/postgresql.php (doesn't seem entirely right)		*http://www.freebsddiary.org/postgresql.php (doesn't seem entirely right)


			(pg_ctl: could not read file "/usr/local/pgsql/data/postmaster.opts") :
	After installing and creating db:		After installing and creating db:
	As user pgsql		As user pgsql
Line 15:		Line 17:
	Ater which it should be possible to run ( as root again)		Ater which it should be possible to run ( as root again)
	/usr/local/etc/rc.d/postgresql start		/usr/local/etc/rc.d/postgresql start



	=FAQ=		=FAQ=