Sample Header Ad - 728x90

Postgres archiving not running

0 votes
0 answers
944 views
I am using logical replication. Currently I am using stored procedure to pump 3K data per hour to see if the WAL files increase. It does increase by 1 file every 12k records. But the WAL archiving is not running even though I have set it ON. Here is my setting : wal_level : Logical wal_log_hints : ON wal_keep_segments : 0 Hot_standby : ON archive_command : cp %p /Archive%f archive_mode : ON max_wal_size : 1 GB min_wal_size : 2 GB checkpoint_timeout : 300 s checkpoint_flush_after : 32 8kB unit wal_sync_method : fdatasync fsync : ON Then I run : SELECT * FROM pg_stat_archiver;. The result is below : Name |Value | ------------------+-----------------------------+ archived_count |0 | last_archived_wal | | last_archived_time| | failed_count |33552 | last_failed_wal |00000001000000960000002C | last_failed_time |2022-08-03 15:07:54.849 +0700| stats_reset |2022-06-30 13:46:05.298 +0700| I don't see anything from the /Archive directory either, its simply empty. What should I do to make the archiving running ? How can I make sure that the archiving is running, what parameters do I have to monitor ? I am using Postgres 12, Ubuntu 12.11 Thanks
Asked by padjee (337 rep)
Aug 3, 2022, 08:25 AM