Interface PostgresAdapterOptions

Configuration options for PostgreSQL adapter. Supports both connection strings and granular configuration.

interface PostgresAdapterOptions {
    connectionString?: string;
    host?: string;
    port?: number;
    database?: string;
    user?: string;
    password?: string;
    ssl?: boolean | {
        rejectUnauthorized?: boolean;
        ca?: string;
        cert?: string;
        key?: string;
    };
    max?: number;
    min?: number;
    idleTimeoutMillis?: number;
    connectionTimeoutMillis?: number;
    application_name?: string;
    statement_timeout?: number;
    query_timeout?: number;
}

Properties

connectionString?: string

PostgreSQL connection string (e.g., 'postgresql://user:pass@host:5432/dbname')

host?: string

Host name or IP address (default: localhost)

port?: number

Port number (default: 5432)

database?: string

Database name

user?: string

Username for authentication

password?: string

Password for authentication

ssl?: boolean | {
    rejectUnauthorized?: boolean;
    ca?: string;
    cert?: string;
    key?: string;
}

Enable SSL/TLS connection (recommended for remote)

max?: number

Connection pool size (default: 10)

min?: number

Minimum pool size (default: 0)

idleTimeoutMillis?: number

Idle timeout in ms (default: 10000)

connectionTimeoutMillis?: number

Connection timeout in ms (default: 0 = no timeout)

application_name?: string

Application name for connection tracking

statement_timeout?: number

Statement timeout in ms (0 = no timeout)

query_timeout?: number

Query timeout in ms (0 = no timeout)