To troubleshoot WAL replication issues in PostgreSQL where the primary server generates WAL files but does not push them to the standby server, consider the following steps:
pg_hba.conf
file on the primary for appropriate entries allowing connections from the standby.postgresql.conf
settings on the primary server, especially wal_level
, max_wal_senders
, archive_mode
, and archive_command
. Ensure they are correctly set for replication.SELECT * FROM pg_replication_slots;
. Ensure that the slot for the standby server is active.SELECT * FROM pg_stat_replication;
to check the status of WAL sender processes.recovery.conf
(or standby.signal
and postgresql.conf
in newer versions) has correct settings for primary_conninfo
and restore_command
.If these steps don't resolve the issue, consider more detailed diagnostics, possibly involving network tracing tools or contact support@minervadb.com