PostgreSQL hosting in Saudi Arabia — a real database in one click, on the hosting you already understand

Why developers in the Kingdom kept asking for this

For years the rule on Saudi hosting was simple: if your project needed PostgreSQL, you could not use hosting. You rented a virtual server, installed the database yourself, worked out its authentication file, opened and then hurriedly closed its port, and became the person who gets the call when the disk fills up. For a software house in Riyadh shipping a Laravel booking system, or a freelance developer in Jeddah building an inventory tool for a trading company in Dammam, that was a lot of server administration attached to what should have been a small hosting bill.

The applications themselves had already moved on. Laravel, Symfony, Django and most Node.js frameworks treat PostgreSQL as a first-class choice, and many teams prefer it for strict data types, proper transactions and JSON columns that can be indexed. The gap was on the hosting side. It is now closed: PostgreSQL is part of Skyline web hosting, managed from the same panel as your files, domains and SSL.

Connection examples you can paste

The examples below use a database called acme_shop. Yours will start with your panel username; the user name is the same as the database name.

Plain PHP with PDO

The pgsql and pdo_pgsql drivers are installed on PHP 8.0, 8.1, 8.2 and 8.3, so set your website to one of those versions.

<?php
$pdo = new PDO(
    'pgsql:host=127.0.0.1;port=5432;dbname=acme_shop',
    'acme_shop',
    'the-password-shown-once'
);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $pdo->prepare('SELECT id, name_ar, name_en FROM products WHERE city = ?');
$stmt->execute(['Riyadh']);

Laravel

Laravel ships with a PostgreSQL driver. Change four lines in .env, then run your migrations as usual.

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=acme_shop
DB_USERNAME=acme_shop
DB_PASSWORD=the-password-shown-once

Node.js with the pg package

If the app runs as a Node.js app on your hosting, put the connection string in the app's .env file and read it from the environment.

# .env in the app folder
DATABASE_URL=postgres://acme_shop:the-password-shown-once@127.0.0.1:5432/acme_shop

// app.js  (npm install pg)
const { Pool } = require('pg');
const pool = new Pool({ connectionString: process.env.DATABASE_URL });
pool.query('SELECT now()').then(r => console.log(r.rows[0]));

Keep the password out of your Git repository: .env files belong in .gitignore.

MySQL or PostgreSQL? A short decision guide

You do not have to pick one for the whole account: both are available on every plan, and a single website can use either.

• Stay on MySQL/MariaDB for WordPress, WooCommerce and most off-the-shelf PHP scripts. They are written for it and gain nothing from a switch.
• Choose PostgreSQL when your framework or vendor recommends it, when you rely on JSONB columns or strict constraints, or when your team already knows it from previous projects.
• Use both when a company site on WordPress sits next to a customer portal or internal tool built in Laravel or Node.js. The site keeps MySQL; the application gets PostgreSQL; one hosting bill covers both.

A worked example

A logistics company in Jeddah runs its marketing site on WordPress and wants a shipment-tracking page for customers. Its developer builds the tracker in Laravel on PostgreSQL, deploys it to a second website on the same Dedicated plan, and the WordPress site links to it. Both sites are in Riyadh, both get free SSL, and the tracker's database is never reachable from outside the server. The monthly bill is still 119 SAR plus VAT.