Post

PostgreSQL

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.

Posted
By Proxmox-Scripts
1 min read
PostgreSQL

Installation

Default install:

1

bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/postgresql.sh)"
CPU: 1 cores RAM: 1024 MB Disk: 4 GB OS: Debian 13

Alpine install:

1

bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/alpine-postgresql.sh)"
CPU: 1 cores RAM: 256 MB Disk: 1 GB OS: Alpine 3.23

Notes

Set a password after installation for postgres user by running echo "ALTER USER postgres with encrypted password 'your_password';" | sudo -u postgres psql
Debian script offers versions 15, 16, 17, 18, while Alpine script offers versions 15, 16, 17.

Web Interface

Port: 5432
Databases
postgresql lxc databases auto-update
This post is licensed under CC BY 4.0 by the author.