Laravel

Environment

DB_CONNECTION=pgsql
DB_HOST=host
DB_PORT=6432
DB_DATABASE=db
DB_USERNAME=user
DB_PASSWORD=password
DB_SSLMODE=require

# direct port for artisan migrate
DB_DIRECT_PORT=5432

Config

The stock config/database.php works; just make sure sslmode is wired:

'pgsql' => [
    'driver' => 'pgsql',
    'host' => env('DB_HOST'),
    'port' => env('DB_PORT', '6432'),
    'database' => env('DB_DATABASE'),
    'username' => env('DB_USERNAME'),
    'password' => env('DB_PASSWORD'),
    'sslmode' => env('DB_SSLMODE', 'require'),
],

Migrations

Run migrations against the direct port:

DB_PORT="$DB_DIRECT_PORT" php artisan migrate

Or define a second connection (pgsql_direct) with port 5432 and run php artisan migrate --database=pgsql_direct.

Pitfalls

• Octane / long-running workers hold persistent connections — count them against the plan budget and prefer the pooled port for request handling.
• Queue workers that use pg advisory locks or LISTEN need the direct port.
• PDO::ATTR_PERSISTENT plus the pooled port is redundant; leave persistence off and let the server-side pooler do its job.