The following table lists the functions that can be used for backup and recovery based on WAL mirroring.
Name | Return type | Description |
|---|---|---|
pgx_pause_wal_multiplexing() | void | Stops WAL multiplexing |
pgx_resume_wal_multiplexing() | void | Resumes WAL multiplexing |
pgx_is_wal_multiplexing_paused() | boolean | Returns true if WAL multiplexing has stopped |
If WAL multiplexing has not been configured, these functions return an error. Setting the backup_destination parameter in postgresql.conf configures WAL multiplexing.
Only superusers can execute these functions.
