Troubleshooting Azure Postgres issues
Incremental backup job fails with the error: Cannot create the replication slot as the maximum limit is reached
Explanation:
The number of replication slots created on the server has exceeded the configured max_replication_slot server parameter.
Workaround:
Do any of the following:
Delete the unused replication slots.
Increase the value of
max_replication_slotsin the server parameters.
Backup fails with an error: Could not write to data file for XID 1676198: No space left on the device
Explanation:
WAL is full and it reached the configured value in WAL_SIZE server parameter.
Workaround:
Increase the value of WAL_SIZE in server parameters.