Setting up PostgreSQL

Skyport can talk to several databases through Laravel, but PostgreSQL is the recommended production choice.

1. Install PostgreSQL

On Debian or Ubuntu:

sudo apt update
sudo apt install -y postgresql postgresql-contrib

2. Create a database and user

Switch to the PostgreSQL superuser:

sudo -u postgres psql

Then run:

CREATE DATABASE skyport;
CREATE USER skyport WITH ENCRYPTED PASSWORD 'change-me';
GRANT ALL PRIVILEGES ON DATABASE skyport TO skyport;

Then exit with:

\q

3. Configure the panel .env

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=skyport
DB_USERNAME=skyport
DB_PASSWORD=change-me

4. Run migrations

php artisan migrate --force

5. Test the connection

php artisan tinker

DB::connection()->getPdo();

If that succeeds without an exception, the panel can reach PostgreSQL correctly.

Recommendation

For production, keep PostgreSQL on a private interface or private network, not exposed to the public internet.