ABOUT
PostgreSQL (often referred to as Postgres) is an open-source relational database management system that is known for its extensibility and strict adherence to SQL standards. It is a free and powerful database solution, suitable for a wide range of applications, from small projects to large enterprise systems. PostgreSQL is widely used for its reliability, feature-richness, and robustness.
infoSet a password after installation for postgres user by running `echo "ALTER USER postgres with encrypted password 'your_password';" | sudo -u postgres psql`
infoDebian script offers versions `15, 16, 17, 18`, while Alpine script offers versions `15, 16, 17`.
INSTALL
Approved local installer
DefaultDebian 13
Approved locally1 CPU1024 MB RAM4 GB disk
Run this command in the Proxmox VE shell. It downloads the immutable approved file, verifies SHA-256, and only then executes it.
( url='https://scripts.francoisvw.com/snapshots/c19711ea1b2526bec67e34be948114e255b5a811/ct/postgresql.sh'; sha='5832287afe5a0041c45b583a462de8d46a4808fd161ac4702344bf8a47d7eff7'; tmp="$(mktemp)" || exit; curl -fsSL "$url" -o "$tmp" && printf '%s %s\n' "$sha" "$tmp" | sha256sum -c - && bash "$tmp"; rc=$?; rm -f "$tmp"; exit "$rc" )
View approved source ↗Path ct/postgresql.shSHA-256 5832287afe5a0041c45b583a462de8d46a4808fd161ac4702344bf8a47d7eff7 alpineAlpine 3.24
Approved locally1 CPU256 MB RAM1 GB disk
Run this command in the Proxmox VE shell. It downloads the immutable approved file, verifies SHA-256, and only then executes it.
( url='https://scripts.francoisvw.com/snapshots/c19711ea1b2526bec67e34be948114e255b5a811/ct/alpine-postgresql.sh'; sha='e9d86e6eab2c2e6d408192203fc081896f1a0d8ded8fffa336540d7a83c88152'; tmp="$(mktemp)" || exit; curl -fsSL "$url" -o "$tmp" && printf '%s %s\n' "$sha" "$tmp" | sha256sum -c - && bash "$tmp"; rc=$?; rm -f "$tmp"; exit "$rc" )
View approved source ↗Path ct/alpine-postgresql.shSHA-256 e9d86e6eab2c2e6d408192203fc081896f1a0d8ded8fffa336540d7a83c88152 LOCAL CHANGE REVIEW
Approved vs latest fetched source
Sign in with a passkey to inspect pending source changes. Approved content remains public.