Databases

PostgreSQL Stack

Name: PostgreSQL Stack
Availability: InStock

PostgreSQL 15 + pgAdmin — a powerful, extensible relational database from the very first boot.

root@mon-serveur — ssh

# when the VPS is created
✓ PostgreSQL Stack installedroot@mon-serveur:~#

About PostgreSQL Stack

The PostgreSQL Stack template sets up a production-ready PostgreSQL 15 instance on your VPS with pgAdmin as the web administration interface. PostgreSQL is the most advanced open-source database: native JSON/JSONB support, advanced indexing, geospatial extensions (PostGIS), replication and exceptional performance on complex queries.

Ideal as a dedicated database for your applications (Laravel, Django, Node.js, Rails) or as a service shared across several projects. The template configures the performance parameters recommended by PGTune based on your VPS resources.

What gets installed

Ready when the VPS starts

Compatible OS: Ubuntu 24.04
Application: PostgreSQL Stack
Tech stack: PostgreSQL 15pgAdmin 4
Minimum RAM: 2 GB
Minimum CPU: 1 vCPU
Default port: 5432
Access: root over SSH

Key features

PostgreSQL 15 with automatically optimized parameters
pgAdmin 4 web interface to visualize your data
Dedicated application user (no superuser connection)
Scheduled automatic backup with pg_dump
Common extensions installed: uuid-ossp, pg_stat_statements
Secure SSL connections

When to use this solution?

Application database

A dedicated database for your Laravel, Django, NestJS or Rails application — separate from the application server.

Data warehouse

Store and analyze data with PostgreSQL's advanced analytical features.

Shared multi-project database

A single PostgreSQL VPS serving several applications, each with its own user and schema.

Guide

Deploy PostgreSQL Stack on your VPS

Create the VPS
Select "PostgreSQL Stack". Minimum 2 GB RAM for PostgreSQL in production with pgAdmin.
Access pgAdmin
Point a subdomain at your VPS and open pgAdmin in your browser. Log in with the credentials created by the template.
Create your database
In pgAdmin, create a new database and a dedicated user with the minimum necessary permissions.
Connect your application
Use the credentials in your application's DATABASE_URL. Allow the connection from your application server's IP in pg_hba.conf.

Frequently asked questions

Questions about PostgreSQL Stack

← Back to Databases All applications

PostgreSQL is more powerful for complex data (JSON, geospatial, analytical queries). MySQL/MariaDB is more widespread for classic web applications (WordPress, PrestaShop). Both are excellent.

Yes. Allow the application server's IP in pg_hba.conf and expose port 5432 only to that IP. Never expose PostgreSQL publicly without a firewall.

Yes. Laravel supports PostgreSQL natively — set DB_CONNECTION=pgsql in your .env. All Eloquent migrations and queries work identically.

The template sets up pg_dump as a daily cron job. The dumps are compressed and stored locally. Configure a transfer to remote storage (S3, another VPS) for extra safety.

Embed the deploy button

Maintaining a project that uses PostgreSQL Stack? This button lets your readers deploy it on a VPS in one click, without reading Docker documentation.

Markdown

[![Deploy PostgreSQL Stack on ServOrbit](https://servorbit.com/brand/deploy/button.svg)](https://servorbit.com/vps-cloud?template=postgresql-stack&utm_source=deploy-badge&utm_medium=referral&utm_campaign=postgresql-stack)

HTML

<a href="https://servorbit.com/vps-cloud?template=postgresql-stack&utm_source=deploy-badge&utm_medium=referral&utm_campaign=postgresql-stack"><img src="https://servorbit.com/brand/deploy/button.svg" alt="Deploy PostgreSQL Stack on ServOrbit" height="40"></a>

The button points to a VPS order with the template preselected. The image is served from servorbit.com — nothing to host on your side.

Complementary solutions

Databases

MariaDB Stack

High-performance, compatible MySQL alternative with phpMyAdmin included. Ideal for web applications and classic CMSs.

Need help?

Browse our help center and FAQ, or reach our team — callback, WhatsApp or email.

Message us on WhatsApp

or write to us