https://wiki.alpinelinux.org/w/api.php?action=feedcontributions&feedformat=atom&user=ThiagowfxAlpine Linux - User contributions [en]2026-05-10T04:47:35ZUser contributionsMediaWiki 1.40.0https://wiki.alpinelinux.org/w/index.php?title=Postgresql&diff=29960Postgresql2025-05-24T14:41:23Z<p>Thiagowfx: add newer guide</p>
<hr />
<div>PostgreSQL is a well known opensource database that scales well and is easy to use.<br />
<br />
== PostgreSQL 16 ==<br />
<br />
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.<br />
<br />
== PostgreSQL 15 ==<br />
<br />
To install PostgreSQL 15,<br />
{{Cmd|apk add postgresql15 postgresql15-contrib postgresql15-openrc}}<br />
{{Cmd|rc-update add postgresql}}<br />
{{Cmd|rc-service postgresql start}}<br />
<br />
This will start the postgresql 15 server and perform some initial configuration. It will also create a system user called postgres.<br />
<br />
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.<br />
<br />
== PostgreSQL 14 ==<br />
<br />
To install PostgreSQL 14,<br />
{{Cmd|apk add postgresql14 postgresql14-contrib postgresql14-openrc}}<br />
{{Cmd|rc-update add postgresql}}<br />
{{Cmd|rc-service postgresql start}}<br />
<br />
This will start the postgresql 14 server and perform some initial configuration. It will also create a system user called postgres.<br />
<br />
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.<br />
<br />
== Switching between PostgreSQL versions ==<br />
<br />
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.<br />
<br />
== Upgrading PostgreSQL ==<br />
<br />
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.<br />
<br />
There's also [https://beune.dev/posts/upgrade-alpine-postgresql/ this older guide].<br />
<br />
[[Category:Database]]</div>Thiagowfx