Member Junction
    Preparing search index...

    Interface PGConnectionConfig

    Configuration for establishing a PostgreSQL connection pool.

    interface PGConnectionConfig {
        ConnectionTimeoutMillis?: number;
        Database: string;
        Host: string;
        IdleInTransactionSessionTimeoutMs?: number;
        IdleTimeoutMillis?: number;
        MaxConnections?: number;
        MinConnections?: number;
        MJCoreSchemaName?: string;
        Options?: string;
        Password: string;
        Port?: number;
        SSL?: boolean | ConnectionOptions;
        StatementTimeoutMs?: number;
        User: string;
    }
    Index

    Properties

    ConnectionTimeoutMillis? Database Host IdleInTransactionSessionTimeoutMs? IdleTimeoutMillis? MaxConnections? MinConnections? MJCoreSchemaName? Options? Password Port? SSL? StatementTimeoutMs? User

    Properties

    ConnectionTimeoutMillis?: number

    Connection timeout in milliseconds (default: 30000)

    Database: string

    Database name

    Host: string

    PostgreSQL host

    IdleInTransactionSessionTimeoutMs?: number

    Server-side limit on how long a session may sit idle inside an open transaction, in milliseconds, sent as idle_in_transaction_session_timeout. PostgreSQL ends a session that exceeds it, which releases the transaction's locks. Omitted or 0 means no limit.

    IdleTimeoutMillis?: number

    Idle timeout in milliseconds (default: 30000)

    MaxConnections?: number

    Maximum number of connections in the pool (default: 20)

    MinConnections?: number

    Minimum number of connections in the pool (default: 2)

    MJCoreSchemaName?: string

    MemberJunction schema name (default: __mj)

    Options?: string

    libpq-style connection options applied at startup, passed verbatim as pg.PoolConfig.options. Common use: server-side GUCs that should take effect from the first query, e.g. -c statement_timeout=30000. Unlike a runtime SET on the pool's connect event, this is included in the PostgreSQL startup packet and is honored by every backend including the one created during the Initialize() verify-SELECT-1 step.

    Password: string

    Password

    Port?: number

    PostgreSQL port (default: 5432)

    SSL?: boolean | ConnectionOptions

    SSL configuration

    StatementTimeoutMs?: number

    Server-side limit on how long one statement may run, in milliseconds. Sent in the startup packet as statement_timeout, so it applies to every backend from its first statement, and PostgreSQL cancels the statement itself when it is exceeded. Omitted or 0 means no limit.

    User: string

    Username

    Settings

    Member Visibility

    On This Page

    Properties