PostgreSQL VPS
Run PostgreSQL on a secure and high-performance VPS environment
PostgreSQL is the most capable open-source relational database around, handling native JSON, geospatial queries through PostGIS, vector similarity search through pgvector and time-series data through TimescaleDB. Managed services charge two to four times the compute price, yet restrict the very extensions that make PostgreSQL powerful. A VPS gives you the full database, complete control over configuration and full extension support, all at a fraction of the managed service cost.
Explore OVHcloud VPS solutions for PostgreSQL
PostgreSQL performance comes down to two resources above all else: RAM and IOPS. RAM determines how much working data stays in shared_buffers (the PostgreSQL buffer cache). IOPS determines how fast WAL writes, checkpoint operations and random table reads get done. For development and small production workloads, our entry-tier plan (4 GB ) with shared_buffers = 2 GB handles the majority of applications. For production databases serving multiple applications, a mid-tier plan (8 GB ) or a higher-tier plan (12 GB ) provides the buffer cache size needed for effective query performance
4 vCores
8 GB RAM
75 GB SSD NVMe
Daily backup of the previous 24 hours
Unlimited traffic
1 Gbps public bandwidth
6 vCores
12 GB RAM
100 GB SSD NVMe
Daily backup of the previous 24 hours
Unlimited traffic
2 Gbps public bandwidth
8 vCores
24 GB RAM
200 GB SSD NVMe
Daily backup of the previous 24 hours
Unlimited traffic
3 Gbps public bandwidth
Our NVMe SSD infrastructure delivers sub-0.1 ms write latency, up to 10 times faster than traditional SATA SSDs. This makes a real difference for database workloads that need fast commit throughput.
Deploying PostgreSQL on a Debian VPS gives you a stable, long-term supported environment. Install PostgreSQL 16 from the official PGDG repository and tune postgresql.conf freely: shared_buffers, effective_cache_size, work_mem, max_connections – all fully configurable, with nothing off-limits. For projects using the Supabase stack on top of PostgreSQL, our Supabase VPS page covers the preconfigured installation.
Key benefits of hosting PostgreSQL on a VPS
NVMe IOPS for write-heavy and analytical workloads
Every committed transaction has to wait for its WAL record to be flushed to disk. On SATA SSD, this takes 0.5 to 1 ms. On NVMe SSD, it takes under 0.1 ms. Add this up over time and the gap grows. At 500 transactions a second, NVMe brings commit latency down 5 to 10 times, giving OLTP applications a real lift in write throughput.
- Checkpoint operations finish faster, reducing WAL accumulation
- Index scans on large tables finish significantly faster on NVMe
- VACUUM and ANALYSE jobs finish in less time, shortening maintenance windows
Complete configuration and extension freedom
With root access on your Debian VPS, you can edit postgresql.conf freely. Set shared_buffers to 25% of RAM, effective_cache_size to 75% of RAM, work_mem based on query complexity and connection count. Install pgvector for AI embedding storage, PostGIS for geographic queries, TimescaleDB for time-series data – extensions that managed services often block or restrict.
Multi-level backup strategy with PITR
pg_dump creates logical backups of individual databases. pg_basebackup creates physical cluster backups. WAL-G archives WAL segments to external storage, enabling point-in-time recovery (PITR): restore your database to any specific moment in time. Enable VPS automated backups as an additional server-level protection layer for comprehensive coverage.
Why choose OVHcloud for your PostgreSQL VPS?
Optimised performance and reliability
NVMe SSD and dedicated vCPUs give PostgreSQL the I/O and processing power it needs, with no other tenants competing for resources. Large L3 caches on Intel Xeon and AMD EPYC processors keep hot query execution paths in fast CPU memory.
Flexible scalability and global presence
Start with our entry-tier plan for development and staging. Upgrade to a mid-tier plan for production as write volume grows. The upgrade keeps your PostgreSQL data directory and configuration intact, with no migration needed. European datacentres meet EU data residency requirements.
Exceptional value with included security
AWS RDS can cost up to five times more for comparable specs. An OVHcloud VPS Model 3 gives you 6 vCores , 12 GB and 100 GB SSD NVMe for From £10.60 ex. VAT/month or £12.72 incl. VAT/month – with better IOPS from NVMe. Anti-DDoS protection and automatic backups are included at no extra cost.
Ready to deploy your PostgreSQL database?
Choose a Debian VPS, add the official PostgreSQL APT repository and install PostgreSQL 16. Your database server is ready to accept connections within two minutes of being provisioned.
How to update PostgreSQL versions on a VPS
Minor version updates (16.1 to 16.3) are handled by apt upgrade postgresql-16 with no data migration. Major version upgrades use pg_upgrade: install the new version, run pg_upgrade with the old and new binary and data directory paths, then start the new cluster. Always create a VPS snapshot and pg_dumpall backup before a major upgrade.
PostgreSQL VPS Hosting: your questions answered
How do I configure PostgreSQL for optimal performance on a VPS?
Key parameters: shared_buffers = 25% of RAM, effective_cache_size = 75% of RAM, work_mem = (RAM - shared_buffers) / (max_connections * 2). Use PGTune at pgtune.leopard.in.ua to generate a complete configuration file based on your VPS spec and workload type. Restart PostgreSQL after applying changes.
How do I set up automatic backups for PostgreSQL on a VPS?
Configure a cron job running pg_dump -Fc dbname > /backup/dbname_$(date +%Y%m%d_%H%M).dump daily with seven-day retention. For PITR capability, install WAL-G and configure it to ship WAL segments to OVHcloud Object Storage. Enable VPS automated backups as an additional server-level protection layer.
How do I connect my application to PostgreSQL on the same VPS?
Configure your application’s database URL as postgresql://user:password@localhost:5432/dbname. In pg_hba.conf, check that local connections from the application user are allowed. Never expose PostgreSQL port 5432 on the public interface. Use a VPN or SSH tunnel for connections from other servers.
How does self-hosted PostgreSQL on VPS compare to a managed service?
Self-hosted PostgreSQL gives you full extension support including pgvector and TimescaleDB, complete configuration control, significantly lower cost per GB of RAM, and no extension whitelist restrictions. The trade-off is that you handle backups, updates and monitoring yourself, which requires basic Linux admin skills.