Install PostgreSQL on your VPS
Infraa installs PostgreSQL on your VPS from the official PGDG apt repository, so you can run a current major version (15 or 16) regardless of what your distro ships. You pick the version and set a superuser password; Infraa proposes the plan, you approve it, and the agent does the rest.
- Versions
- PostgreSQL 15 or 16, from the official PGDG apt repository
- Works on
- Ubuntu 22.04, Ubuntu 24.04, and Debian 12
- Package source
- Official PGDG repository
What does the PostgreSQL install do?
- Adds the PGDG repository with its signing key and installs postgresql-<version> plus the matching client tools.
- Writes a managed postgresql.conf with your chosen port, listen address, and shared_buffers, plus conservative defaults.
- Sets the postgres superuser password you provide — stored encrypted, never shown in logs or run history.
- Enables and starts the postgresql@<version>-main systemd unit.
How do I install PostgreSQL with Infraa?
Connect your server
Run the Infraa install one-liner (curl install.infraa.sh | sh) on your VPS. The agent registers over an outbound connection in about 30 seconds — no inbound ports, no SSH keys to share.
Pick the service
Choose it from the one-click catalog in the dashboard, or just ask in chat. Infraa turns your request into a concrete, reviewable plan.
Review and approve
Read exactly what will run, then approve. The agent executes only the approved, cryptographically signed steps and streams progress live.
What happens after the install?
Infraa keeps checking PostgreSQL every 60 seconds — service status, connectivity, and disk pressure — and flags trouble in your dashboard before it becomes an outage. Its recommendations engine watches real usage and proposes config tuning over time; nothing is applied without your approval.
PostgreSQL on Infraa — common questions
01Which PostgreSQL versions can Infraa install?
PostgreSQL 15 or 16. Infraa installs from the official PGDG apt repository rather than the distro package, so you get a current, supported major version on Ubuntu 22.04, Ubuntu 24.04, or Debian 12.
02Where is the PostgreSQL password stored?
The postgres superuser password you set during install is stored encrypted and never appears in logs or run history. It is applied on the server through a constrained capability, not a shell command.
03Does Infraa keep managing PostgreSQL after the install?
Yes. Health checks run every 60 seconds, problems are flagged in your dashboard before they become outages, and the recommendations engine proposes tuning based on real usage — every change still requires your approval.
Connect a server in 30 seconds, then install PostgreSQL from the catalog or just ask in chat.
