EDB Postgres Extended Server has a number of features that relate to operations.
EDB Postgres Extended Server provides WAL pacing delays to avoid flooding transaction logs. The WAL pacing configuration parameters are:
wal_insert_delay_enabled is enabled, a session sleeps based on the value of
wal_insert_delay after WAL data of at least the value of
wal_insert_delay_size is generated. The default is off.
EDB Postgres Extended Server allows you to enable timeouts based on logging trace messages in specific code
paths. Use the
tracelog_timeout configuration parameter to allow logging of trace messages after a timeout of
the specified time occurs.
By default, backups are always taken of the entire database cluster. You can also back up individual databases or database objects by specifying
-L option with the
pg_basebackup utility multiple times for multiple databases.
Template databases are backed up by default. WAL data for excluded databases is still part of the WAL archives.
The backup activity stores the list of database objects specified using this option in the backup label file. The presence of these objects in the backup label file causes selective recovery of these databases. Recovery of template databases and of global metadata related to users, languages, and so on is also carried out as usual. WAL data belonging to excluded databases is ignored during the recovery process. Attempts to connect to excluded databases cause errors after regular operations start following the recovery.
- Reduced locking of
ALTER TABLE ... REPLICA IDENTITY