ERROR: pg_stop_backup still waiting for all required WAL segments to be archived

Hi,

This error mention that WAL Segments can not be archived, so you need to check archive_command is right to archive WAL. 

NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments to be archived 
WARNING: pg_stop_backup still waiting for all required WAL segments to be archived (60 seconds elapsed) 
HINT: Check that your archive_command is executing properly. pg_stop_backup can be cancelled safely, but the database backup will not be usable without all the WAL segments.
archive_command can be as bellow row in your postgres.conf file;

archive_command = '/bin/cp %p /var/lib/pgsql/archive/%f'

the most important thing is if there is a directory for /var/lib/pgsql/archive/%f side. Check it out and reload your config file or restart your Postgresql server.

Loves,

Comments

Popular posts from this blog

PostgreSQL High Availability - Patroni 2

PostgreSQL Foreign Data Wrappers

PostgreSQL High Availability - Patroni 1