What's installed on your PostgreSQL server?
- PostgreSQL 18 from the official PGDG repository
- A yonetici superuser role and an empty database called uygulama
- Remote connections over TLS only, with SCRAM-SHA-256 password authentication
- A self-signed server certificate
- The psql command-line client
- Settings under /etc/postgresql/18/main, with our additions in conf.d/seturack.conf
- Firewall with port 5432 open for the database and port 22 for SSH
What size do you need for PostgreSQL?
PostgreSQL doesn't give an official RAM figure, since data size and concurrent connections decide what you need. As a rule of thumb, 1 GB is a start for a small project and 2 to 4 GB for an app in production. This install leaves the memory settings alone, so shared_buffers stays at its default. The official docs suggest 25 percent of RAM as a starting value on a server that runs only the database and has 1 GB or more. Raise it yourself after scaling up. Disk can't shrink later.
| Use | Size | Price | Choose |
|---|---|---|---|
| Starter | 1 GB RAM · 1 vCore · 25 GB NVMe | $2.58/mo | |
| Medium | 2 GB RAM · 1 vCore · 40 GB NVMe | $4.01/mo | |
| Powerful | 4 GB RAM · 2 vCore · 60 GB NVMe | $6.89/mo |
Who is it for?
- Developers whose app runs elsewhere and who want the database on its own server
- Teams that want a superuser to manage roles, extensions and settings themselves
- Projects built on extensions such as pgvector or PostGIS
- Apps hosted in Turkey that want their database in Istanbul
What happens after you order?
- Set the size and complete your payment.
- Your server starts and PostgreSQL installs itself. This took about 3 minutes in our real-server tests.
- On your panel's Overview tab, copy the Connection address, Login and Password rows.
- Test it from your computer: psql 'postgresql://yonetici:PASSWORD@IP:5432/uygulama?sslmode=require'
- Create a role and database for your app: CREATE ROLE api LOGIN PASSWORD 'new-password'; CREATE DATABASE api OWNER api;
- Limit access: ufw delete allow 5432/tcp, then ufw allow from YOUR_IP to any port 5432
With every server
- Daily backups included in the price
- Unlimited traffic
- Full root access
- Scale RAM and CPU up or down later, and grow the disk
- Location: Istanbul · IST-1.
Good to know
- Port 5432 is open to the internet. If only your own servers connect, limit it to their IP addresses in the firewall.
- Remote connections without TLS or a password are refused, so sslmode=disable won't work.
- The certificate is self-signed. sslmode=require encrypts the connection but doesn't prove the server's identity; install your own certificate for verify-full.
- The yonetici role shown in your panel is a superuser, so keep it out of your app's connection string.
- Minor patches arrive through apt from the PGDG repository. Running apt upgrade and major upgrades with pg_upgrade are your responsibility.
- The panel keeps showing the install password. If you change it with ALTER ROLE, keep the new one safe yourself.
PostgreSQL questions and answers
How do I connect to my PostgreSQL server?
Take the connection address and password from your panel and use this string: postgresql://yonetici:PASSWORD@IP:5432/uygulama?sslmode=require. psql, DBeaver, pgAdmin and any client that accepts a connection string can connect with it.
Is PostgreSQL open to the internet, and how do I close it?
Yes, port 5432 is open, but only TLS connections with a SCRAM password are accepted. To allow specific addresses only, run ufw delete allow 5432/tcp, then ufw allow from YOUR_IP to any port 5432.
How much RAM does PostgreSQL need?
PostgreSQL has no official RAM figure. As a rule of thumb, 1 GB is a good start for a small project and 2 to 4 GB for an app in production. After scaling up, raise shared_buffers too; the official suggestion is 25 percent of RAM.
Why do I get a certificate error connecting from Node.js?
The node-postgres driver checks the certificate when it sees sslmode=require, and rejects a self-signed one. Use sslmode=no-verify in the connection string. The connection stays encrypted, but the server's identity isn't checked.
Can I install pgvector or PostGIS?
Yes. The PGDG repository is already on the server, so run apt install postgresql-18-pgvector as root and then CREATE EXTENSION vector in your database. PostGIS is in the same repository as postgresql-18-postgis-3.
Do backups cover my databases?
Yes. Your server is backed up every night, the last 7 days are kept, and this is included in the price, with the database files as part of the disk. To keep a separate copy of one database or table, also use pg_dump.