type

PoolConfig

type PoolConfig struct {
	DatabaseURL string
	// AllowInsecureTransport explicitly permits plaintext PostgreSQL connections.
	// Keep this false in production; it exists for local Unix sockets and
	// development databases whose transport is secured outside PostgreSQL.
	AllowInsecureTransport bool
	ApplicationName        string
	MaxConnections         int32
	// MaxUploadLockConnections bounds the separate advisory-lock pool used
	// while object storage and document transactions are coordinated. Keeping
	// this pool separate prevents staged uploads from starving their own
	// document transactions. Zero selects four connections.
	MaxUploadLockConnections        int32
	MinConnections                  int32
	MaxConnectionLifetime           time.Duration
	MaxConnectionLifetimeJitter     time.Duration
	MaxConnectionIdleTime           time.Duration
	HealthCheckPeriod               time.Duration
	ConnectTimeout                  time.Duration
	StatementTimeout                time.Duration
	LockTimeout                     time.Duration
	IdleInTransactionSessionTimeout time.Duration
}

Production connection-pool, upload-lock-pool, lifetime, health, and server timeout controls.

Source adapters/postgres/postgres.go:39

DatabaseURLstring: The DatabaseURL value.
AllowInsecureTransportbool: AllowInsecureTransport explicitly permits plaintext PostgreSQL connections. Keep this false in production; it exists for local Unix sockets and development databases whose transport is secured outside PostgreSQL.
ApplicationNamestring: The ApplicationName value.
MaxConnectionsint32: The MaxConnections value.
MaxUploadLockConnectionsint32: MaxUploadLockConnections bounds the separate advisory-lock pool used while object storage and document transactions are coordinated. Keeping this pool separate prevents staged uploads from starving their own document transactions. Zero selects four connections.
MinConnectionsint32: The MinConnections value.
MaxConnectionLifetimetime.Duration: The MaxConnectionLifetime value.
MaxConnectionLifetimeJittertime.Duration: The MaxConnectionLifetimeJitter value.
MaxConnectionIdleTimetime.Duration: The MaxConnectionIdleTime value.
HealthCheckPeriodtime.Duration: The HealthCheckPeriod value.
ConnectTimeouttime.Duration: The ConnectTimeout value.
StatementTimeouttime.Duration: The StatementTimeout value.
LockTimeouttime.Duration: The LockTimeout value.
IdleInTransactionSessionTimeouttime.Duration: The IdleInTransactionSessionTimeout value.

Zero values select bounded Ridu defaults. Negative duration values explicitly disable the corresponding timeout.

AllowInsecureTransport is for local sockets or externally secured development transport; keep it false in production. The upload lock pool defaults to four connections and stays separate so staged uploads cannot starve their own document transactions.