Can PostgreSQL be connected from another VPS?

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.

Is PostgreSQL compatible with Laravel?

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

How do I back up PostgreSQL automatically?

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.

Spin up a data platform quickly.

PostgreSQL Stack

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

2 GB RAM 1 vCPU Port 5432 Available

Source code

Tech stack

PostgreSQL 15pgAdmin 4

Minimum RAM2 GB

Minimum CPU1 vCPU

Default port5432

Compatible OSubuntu-24.04

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.

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?

1

Application database

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

2

Data warehouse

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

3

Shared multi-project database

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

Deploy PostgreSQL Stack on your VPS

Guide optimized for ServOrbit Cloud VPS.

01

Create the VPS

Select "PostgreSQL Stack". Minimum 2 GB RAM for PostgreSQL in production with pgAdmin.

02

Access pgAdmin

Point a subdomain at your VPS and open pgAdmin in your browser. Log in with the credentials created by the template.

03

Create your database

In pgAdmin, create a new database and a dedicated user with the minimum necessary permissions.

04

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

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.

Complementary solutions

Databases

MariaDB Stack

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