Alpine Linux - User contributions [en]

Postgresql

2026-01-14T06:41:15Z

StrangePerson: update PostgreSQL versions

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

== Installation ==

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 18,
{{Cmd|# apk add postgresql18 postgresql18-contrib}}
{{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 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 ==

Login as the postgres user and start psql to create a new user and database:
{{Cmd|su postgres}}
{{Cmd|psql}}
{{Cmd|create user user with encrypted password 'password';}}
{{Cmd|create database database;}}
{{Cmd|grant all privileges on database database to user;}}

=== Network access ===

By default only local access is allowed to PostgreSQL. To allow other networked services to access the database we need to configure PostgreSQL to allow external connections.

In this example, we are using PostgreSQL v16, so substitute below for your specific version.
Edit the {{Path|/etc/postgresql16/postgresql.conf}} file using <code>nano</code> or any other {{ic|<editor> /etc/postgresql16/postgresql.conf}}
Find the line that starts with <pre>#listen_addresses = 'localhost'</pre>
Uncomment it and change it to the following:
<pre>listen_addresses = '*'</pre>
If you want it to listen on a specific ip you can change * to 192.168.1.2/24.
Save the file and change the next config file.

Modify the {{Path|/etc/postgresql16/pg_hba.conf}} file using <code>nano</code> or any other {{ic|<editor> /etc/postgresql16/pg_hba.conf}}
Look for the line: <pre>host all all 127.0.0.1/32 md5</pre>
And change it to: <pre>host all all 0.0.0.0/0 md5</pre>
This line allows connections from any IP address and requires a password for authentication (md5).
Restart the server to allow incoming connections from other hosts. {{Cmd|rc-service postgresql restart}}

Allow the port through the firewall. For [[UFW]] firewall type: {{Cmd|ufw allow 5432}}

This is a basic configuration. You can configure the PostgreSQL server to only allow certain networks or IP's to connect, but that's beyond the scope of this documentation.

== Switching between PostgreSQL versions ==

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://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].

== See also ==
* [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:Server]]

Development using git:Quality assurance

2025-10-29T18:59:55Z

StrangePerson: "sanitycheck" is obsolete, use "validate" instead

Before pushing anything to it is good to make sure that:
# The package actually builds
# Commit message is good
# pkgrel is bumped if needed
# no whitespace damage (last chars of a line is whitespace)

The following git hook will help you catch some common errors early:
<pre>
#!/bin/sh

# Redirect output to stderr.
exec 1>&2

git diff --cached --name-only HEAD | grep 'APKBUILD$' | while read f; do
olddir=$PWD
cd ${f%/APKBUILD}
if ! abuild validate && verify; then
exit 1
fi
cd "$olddir"
done

# If there are whitespace errors, print the offending file names and fail.
exec git diff-index --check --cached HEAD --
</pre>

Install it as .git/hooks/pre-commit and make it executable.

[[Category:Development]]
[[Category:Git]]

APKBUILD examples:Rust

2025-10-29T18:40:35Z

StrangePerson: add info about an issue with cargo-auditable, fix typo

== Considerations ==

Use <code>cargo-auditable</code> to encode dependency information into binaries.

One may encounter an issue when a package refuses to build using <code>cargo-auditable</code>, but successfully builds with <code>cargo</code>. This is because <code>cargo</code> itself exposes faulty data. More info can be found [https://github.com/rust-secure-code/cargo-auditable/issues/124 here].

Most Rust projects use <code>cargo</code> to fetch Rust library dependencies. The current convention is to use <code>options="net"</code> fetch these during the <code>prepare()</code> phase. Use the <code>--locked</code> flag to ensure that the exact same versions of dependencies are fetched on each rebuild. If a package is missing a lockfile, include one with the aport and attempt to recommend upstream to include one.

== Examples ==

=== Basic example ===

<pre>
maintainer="Hugo Osvaldo Barrera <hugo@whynothugo.nl>"
pkgname=harper
pkgver=0.59.0
pkgrel=0
pkgdesc="Grammar checker that respects your privacy"
url="https://github.com/elijah-potter/harper"
arch="all"
license="Apache-2.0"
makedepends="cargo-auditable rust"
source="harper-$pkgver.tar.gz::https://github.com/elijah-potter/harper/archive/v$pkgver/harper-$pkgver.tar.gz"
options="net"

prepare() {
default_prepare

cargo fetch --target="$CHOST" --locked
}

build() {
cargo auditable build --release --frozen
}

check() {
cargo test --frozen
}

package() {
install -Dm755 target/release/harper-cli "$pkgdir"/usr/bin/harper-cli
install -Dm755 target/release/harper-ls "$pkgdir"/usr/bin/harper-ls
}

sha512sums="
e5be781b33ba624e2447464a51ff8c0b565a42d7bf957c2fd6655f4bf312211fcf669bbb152b62a57494f89fd7fbee7eda37bbbaf7a61c5d4c8c9684ffe687bd harper-0.48.0.tar.gz
"
</pre>

== See also ==

* [[APKBUILD examples]]
* [[Creating an Alpine package]]

[[Category:Development]] [[Category:Rust]]