PostgresConnector

Determine if the given exception was caused by a lost connection.

Create a new PDO connection.

Create a new PDO connection instance.

Handle an exception that occurred during connect execution.

Get the PDO options based on the configuration.

Get the default PDO connection options.

Set the default PDO connection options.

Parse the Postgres "search_path" configuration value into an array.

Establish a database connection.

Startup parameters (search_path, timezone, isolation level, synchronous commit) are baked into the DSN via libpq's "options" parameter rather than issued as post-connect SET statements. This keeps them intact on pooled connections (PgBouncer transaction pooling, pgdog, etc.) where a SET applied to one backend is lost when the pooler hands the next query to a different backend.

Create a DSN string from a configuration.

Build the libpq "options" parameter value from startup settings.

Returns null when no startup settings are configured. Each setting is expressed as a "-c key=value" flag, space-separated. Values containing spaces (e.g. "read committed") are backslash-escaped so libpq preserves them as a single token when it splits the options string on whitespace.

Escape a startup option value for use inside libpq's options parameter.

libpq splits the options string on unescaped whitespace, so spaces that belong to a single value (like the space in "read committed") must be backslash-escaped to stay part of that value rather than being treated as a token separator.

The replacement emits two backslashes before each space. PDO's DSN parser consumes one level of backslash-escaping when it extracts the single-quoted options value, so a single backslash in the DSN source is stripped before libpq sees it — leaving libpq to split on the unescaped space. Doubling the backslash survives PDO's unescape and arrives at libpq as a single \ (escaped space).

Add the SSL options to the DSN.

Format the search path as a quoted identifier list.