a8s PostgreSQL Extensions
You can set the following supported extensions for PostgreSQL:
| Extension Name | Description |
|---|---|
| maxConnections | Determines the maximum number of concurrent connections to the database server(default value: 100). |
| tempFileLimit | Specifies the maximum amount of disk space that a process can use for temporary files, such as sort and hash temporary files, or the storage file for a held cursor(-1 means 'no limit', which is also the default value). |
| trackIoTiming | Enables timing of database I/O calls(default value: off). |
| archiveTimeout | Enforces the server to switch to a new WAL segment file periodically(default value: 0, which is 1h). |
| statementTimeout | Abort any statement that takes more than the specified number of milliseconds, starting from the time the command arrives at the server from the client(default value: 0). |
| walLevelLogical | Configures wal_level(default value: false). |
| walWriterDelay | Configures how often the WAL writer flushes WAL(default value: 200 milliseconds). |
| maxReplicationSlots | Configures the maximum amount of replication slots(default value: 10). |
| maxWalSenders | Configures the maximum amount of WAL sender fore each node of the service instance(default value: 10). |
| synchronousCommit | Configures synchronous_commit which specifies how much WAL processing must be completed before the database server returns a 'success' indication to the client.(default value: on). |
| sslCiphers | Specifies the list of SSL cipher suites supported by the PostgreSQL server for encrypted client connections. The default value HIGH:MEDIUM:+3DES:!aNULL enables ciphers from the HIGH and MEDIUM security levels, gives priority to 3DES after other HIGH and MEDIUM ciphers, and explicitly disables anonymous cipher suites that do not perform authentication. |
| sslMinProtocolVersion | Defines the minimum version of the SSL/TLS protocol that the PostgreSQL server will support when clients attempt to connect using SSL(default value:TLSv1.2). |
| clientMinMessages | Controls which message levels are sent to the client(default value:NOTICE). |
| logMinMessages | Controls which message levels are written to the server log(default value: WARNING). |
| logMinErrorStatement | Controls which SQL statements that cause an error condition are recorded in the server log(default value: ERROR). |
| logStatement | Controls which SQL statements are logged(default value: none). |
| logErrorVerbosity | Controls the amount of detail written in the server log for each message that is logged(default value: DEFAULT). |