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