Postgresql - Revision history

StrangePerson: update PostgreSQL versions

2026-01-14T06:41:15Z

update PostgreSQL versions

← Older revision		Revision as of 06:41, 14 January 2026
Line 3:		Line 3:
	== Installation ==		== Installation ==

	PostgreSQL 17 is the latest version since [[Release_Notes_for_Alpine_3.21.0#~~PostgreSQL_17~~\|v3.21]].		PostgreSQL 18 is the latest version since [[https://wiki.alpinelinux.org/wiki/Release_Notes_for_Alpine_3.23.0#PostgreSQL_18\|v3.23]].

	To install PostgreSQL 17,		To install PostgreSQL 18,
	{{Cmd\|# apk add ~~postgresql17 postgresql17~~-contrib ~~postgresql17-openrc~~}}		{{Cmd\|# apk add postgresql18 postgresql18-contrib}}
	{{Cmd\|# rc-update add postgresql}}		{{Cmd\|# rc-update add postgresql}}
	{{Cmd\|# rc-service postgresql start}}		{{Cmd\|# rc-service postgresql start}}
Line 12:		Line 12:
	This will start the postgresql server and perform some initial configuration. It will also create a system user called '''postgres'''.		This will start the postgresql server and perform some initial configuration. It will also create a system user called '''postgres'''.

	Older versions of PostgreSQL 16 and PostgreSQL 15 are still available as of [[Release Notes for Alpine 3.22.0\|v3.22]] and can be installed using the same commands as above except for replacing the version number in the appropriate package names. For example, {{pkg\|postgresql17}} is to be replaced by {{pkg\|postgresql16}} and {{pkg\|postgresql15}} for PostgreSQL 16 and PostgreSQL 15 14 respectively.		Older versions of PostgreSQL 16 and PostgreSQL 15 are still available as of [[Release Notes for Alpine 3.22.0\|v3.22]] and can be installed using the same commands as above except for replacing the version number in the appropriate package names. For example, {{pkg\|postgresql17}} is to be replaced by {{pkg\|postgresql16}} and {{pkg\|postgresql15}} for PostgreSQL 16 and PostgreSQL 15 respectively.

	== Configuration ==		== Configuration ==

Jahway603: /* Installation */ removed postgresql 14, as not available in v3.22

2025-11-03T16:00:29Z

Installation: removed postgresql 14, as not available in v3.22

← Older revision		Revision as of 16:00, 3 November 2025
Line 12:		Line 12:
	This will start the postgresql server and perform some initial configuration. It will also create a system user called '''postgres'''.		This will start the postgresql server and perform some initial configuration. It will also create a system user called '''postgres'''.

	Older versions of PostgreSQL 16, PostgreSQL 15 ~~and PostgreSQL 14~~ are still available as of [[Release Notes for Alpine 3.20.0\|v3.22]] and can be installed using the same commands as above except for replacing the version number in the appropriate package names. For example, {{pkg\|postgresql17}} is to be replaced by {{pkg\|postgresql16}}, {{pkg\|postgresql15~~}} and {{pkg\|postgresql14~~}} for PostgreSQL 16, PostgreSQL 15 ~~and PostgreSQL~~ 14 respectively.		Older versions of PostgreSQL 16 and PostgreSQL 15 are still available as of [[Release Notes for Alpine 3.22.0\|v3.22]] and can be installed using the same commands as above except for replacing the version number in the appropriate package names. For example, {{pkg\|postgresql17}} is to be replaced by {{pkg\|postgresql16}} and {{pkg\|postgresql15}} for PostgreSQL 16 and PostgreSQL 15 14 respectively.

	== Configuration ==		== Configuration ==

Prabuanand: simplified repetetive information

2025-10-31T16:55:19Z

simplified repetetive information

← Older revision		Revision as of 16:55, 31 October 2025
Line 1:		Line 1:
	PostgreSQL is a well known opensource database that scales well and is easy to use.		PostgreSQL is a well known opensource database that scales well and is easy to use.

	== ~~PostgreSQL 17~~ Installation ==		== Installation ==

			PostgreSQL 17 is the latest version since [[Release_Notes_for_Alpine_3.21.0#PostgreSQL_17\|v3.21]].

	To install PostgreSQL 17,		To install PostgreSQL 17,
	{{Cmd\|apk add postgresql17 postgresql17-contrib postgresql17-openrc}}		{{Cmd\|# apk add postgresql17 postgresql17-contrib postgresql17-openrc}}
	{{Cmd\|rc-update add postgresql}}		{{Cmd\|# rc-update add postgresql}}
	{{Cmd\|rc-service postgresql start}}		{{Cmd\|# rc-service postgresql start}}

	~~This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.~~

	~~== PostgreSQL 16 Installation ==~~

	~~To install PostgreSQL 16,~~
	~~{{Cmd\|apk add postgresql16 postgresql16-contrib postgresql16-openrc}}~~
	~~{{Cmd\|rc-update add postgresql}}~~
	~~{{Cmd\|rc-service postgresql start}}~~

	~~This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.~~

	~~== PostgreSQL 15 Installation ==~~

	~~To install PostgreSQL 15,~~		This will start the postgresql server and perform some initial configuration. It will also create a system user called '''postgres'''.
	~~{{Cmd\|apk add postgresql15 postgresql15-contrib postgresql15-openrc}}~~
	~~{{Cmd\|rc-update add~~ postgresql}}
	~~{{Cmd\|rc-service postgresql start}}~~

	~~This will start the postgresql server~~ and ~~perform some initial configuration~~. ~~It will also create a system user called postgres~~.		Older versions of PostgreSQL 16, PostgreSQL 15 and PostgreSQL 14 are still available as of [[Release Notes for Alpine 3.20.0\|v3.22]] and can be installed using the same commands as above except for replacing the version number in the appropriate package names. For example, {{pkg\|postgresql17}} is to be replaced by {{pkg\|postgresql16}}, {{pkg\|postgresql15}} and {{pkg\|postgresql14}} for PostgreSQL 16, PostgreSQL 15 and PostgreSQL 14 respectively.

	~~== PostgreSQL 14 Installation ==~~

	~~To install PostgreSQL 14~~,
	{{~~Cmd~~\|~~apk add postgresql14 postgresql14-contrib postgresql14-openrc~~}}
	{{~~Cmd~~\|~~rc-update add postgresql~~}}
	{{~~Cmd~~\|~~rc-service postgresql start~~}}

	~~This will start the postgresql server~~ and ~~perform some initial configuration. It will also create a system user called postgres~~.

	== Configuration ==		== Configuration ==
Line 76:		Line 53:
	Please follow along with [https://perrotta.dev/2025/05/postgresql-major-version-upgrade-on-alpine-linux/ this guide] and adjust the version you are moving from and the version you are upgrading to.		Please follow along with [https://perrotta.dev/2025/05/postgresql-major-version-upgrade-on-alpine-linux/ this guide] and adjust the version you are moving from and the version you are upgrading to.

	There's also [https://beune.dev/posts/upgrade-alpine-postgresql/ this ~~older guide~~].		There's also [https://beune.dev/posts/upgrade-alpine-postgresql/ this].

	== See also ==		== See also ==
	* https://blog.devart.com/configure-postgresql-to-allow-remote-connection.html		* [https://blog.devart.com/configure-postgresql-to-allow-remote-connection.html Guide for Upgrading PostgreSQL]
			* [https://beune.dev/posts/upgrade-alpine-postgresql/ older postgresql upgrade guide]
	[~~[Category~~:~~Database]~~]

			[[Category:Database]]
	[[Category:Server]]		[[Category:Server]]

Jahway603: Added Configuration section

2025-10-31T13:20:08Z

Added Configuration section

@@ Line 1: / Line 1: @@
 PostgreSQL is a well known opensource database that scales well and is easy to use.
-== PostgreSQL 17 ==
+== PostgreSQL 17 Installation ==
 To install PostgreSQL 17,
@@ Line 10: / Line 10: @@
 This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.
-To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.
+== PostgreSQL 16 Installation ==
 To install PostgreSQL 16,
@@ Line 21: / Line 19: @@
 This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.
-To configure and use PostgreSQL 16, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page].
+== PostgreSQL 15 Installation ==
 To install PostgreSQL 15,
@@ Line 32: / Line 28: @@
 This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.
-To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.
+== PostgreSQL 14 Installation ==
 To install PostgreSQL 14,
@@ Line 43: / Line 37: @@
 This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.
-To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.
+== Configuration ==
 == Switching between PostgreSQL versions ==
@@ Line 54: / Line 77: @@
 There's also [https://beune.dev/posts/upgrade-alpine-postgresql/ this older guide].
 [[Category:Database]]

Jahway603: More generalization

2025-10-31T13:03:08Z

More generalization

← Older revision		Revision as of 13:03, 31 October 2025
Line 10:		Line 10:
	This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.		This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.

	To ~~install,~~ configure, and use PostgreSQL ~~17, which is the latest release as of Alpine v3.21~~, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page]~~. It will also create a system user called postgres~~.		To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.

	== PostgreSQL 16 ==		== PostgreSQL 16 ==
Line 21:		Line 21:
	This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.		This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.

	To ~~install,~~ configure, and use PostgreSQL 16, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page]~~. It will also create a system user called postgres~~.		To configure and use PostgreSQL 16, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page].

	== PostgreSQL 15 ==		== PostgreSQL 15 ==

Jahway603: Better generalize certain sections

2025-10-31T13:00:39Z

Better generalize certain sections

Jahway603: Added PostgreSQL 17 section

2025-10-31T12:59:35Z

Added PostgreSQL 17 section

@@ Line 1: / Line 1: @@
 PostgreSQL is a well known opensource database that scales well and is easy to use.
 == PostgreSQL 16 ==
-To install, configure, and use PostgreSQL 16, which is the latest release, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page]. It will also create a system user called postgres.
+To install PostgreSQL 16,
 == PostgreSQL 15 ==

Thiagowfx: add newer guide

2025-05-24T14:41:23Z

add newer guide

← Older revision		Revision as of 14:41, 24 May 2025
Line 33:		Line 33:
	== Upgrading PostgreSQL ==		== Upgrading PostgreSQL ==

	Please follow along with [https://~~beune~~.dev/~~posts~~/upgrade-alpine-~~postgresql~~/ this guide] and ~~substitute~~ the version you are moving from and the version you are upgrading to.		Please follow along with [https://perrotta.dev/2025/05/postgresql-major-version-upgrade-on-alpine-linux/ this guide] and adjust the version you are moving from and the version you are upgrading to.

			There's also [https://beune.dev/posts/upgrade-alpine-postgresql/ this older guide].

	[[Category:Database]]		[[Category:Database]]

Prabuanand: added category

2025-01-16T08:39:51Z

added category

← Older revision		Revision as of 08:39, 16 January 2025
Line 1:		Line 1:
	~~= General =~~

	PostgreSQL is a well known opensource database that scales well and is easy to use.		PostgreSQL is a well known opensource database that scales well and is easy to use.

Line 36:		Line 34:

	Please follow along with [https://beune.dev/posts/upgrade-alpine-postgresql/ this guide] and substitute the version you are moving from and the version you are upgrading to.		Please follow along with [https://beune.dev/posts/upgrade-alpine-postgresql/ this guide] and substitute the version you are moving from and the version you are upgrading to.

			[[Category:Database]]

Jahway603: added guide for Upgrading PostgreSQL

2024-07-23T02:38:49Z

added guide for Upgrading PostgreSQL

← Older revision		Revision as of 02:38, 23 July 2024
Line 32:		Line 32:

	On Alpine Linux, you can use the command `pg_versions` to switch between PostgreSQL versions. This is very helpful when upgrading the version you are using.		On Alpine Linux, you can use the command `pg_versions` to switch between PostgreSQL versions. This is very helpful when upgrading the version you are using.

			== Upgrading PostgreSQL ==

			Please follow along with [https://beune.dev/posts/upgrade-alpine-postgresql/ this guide] and substitute the version you are moving from and the version you are upgrading to.

← Older revision		Revision as of 13:00, 31 October 2025
Line 8:		Line 8:
	{{Cmd\|rc-service postgresql start}}		{{Cmd\|rc-service postgresql start}}

	This will start the postgresql 15 server and perform some initial configuration. It will also create a system user called postgres.		This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.

	To install, configure, and use PostgreSQL 17, which is the latest release as of Alpine v3.21, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page]. It will also create a system user called postgres.		To install, configure, and use PostgreSQL 17, which is the latest release as of Alpine v3.21, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page]. It will also create a system user called postgres.
Line 18:		Line 18:
	{{Cmd\|rc-update add postgresql}}		{{Cmd\|rc-update add postgresql}}
	{{Cmd\|rc-service postgresql start}}		{{Cmd\|rc-service postgresql start}}

			This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.

	To install, configure, and use PostgreSQL 16, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page]. It will also create a system user called postgres.		To install, configure, and use PostgreSQL 16, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page]. It will also create a system user called postgres.
Line 28:		Line 30:
	{{Cmd\|rc-service postgresql start}}		{{Cmd\|rc-service postgresql start}}

	This will start the postgresql 15 server and perform some initial configuration. It will also create a system user called postgres.		This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.

	To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.		To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.
Line 39:		Line 41:
	{{Cmd\|rc-service postgresql start}}		{{Cmd\|rc-service postgresql start}}

	This will start the postgresql 14 server and perform some initial configuration. It will also create a system user called postgres.		This will start the postgresql server and perform some initial configuration. It will also create a system user called postgres.

	To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.		To configure and use PostgreSQL, please refer to the [https://wiki.alpinelinux.org/wiki/Postgresql_16 PostgreSQL 16 Alpine Wiki page] as the usage is the same.