Hi All,
pg_stop_backup is not stopping...
Postgresql version 9.01
OS: Centos
Postgresql.conf ==> default configuration did not change anything
Steps
1. Initiated psql -c "SELECT pg_start_backup('label', true)"
2. Started RSYNC job to sync slave box
rsync -a /var/lib/pgsql/data/ dbpg9-test-02:/var/lib/pgsql/data
Left over night to rsync - it was only around 10 GB of data to be rsynced,
but i left overnight...
3. psql -c "SELECT pg_stop_backup()"
*Gettign Error Message as below*
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.
WARNING: pg_stop_backup still waiting for all required WAL segments to be
archived (120 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.
WARNING: pg_stop_backup still waiting for all required WAL segments to be
archived (240 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.
I waited quite long and it was not stopping, I had to issue Ctrl+c to cancel
it.
========
I tried to start backup and stop backup again, same problem.
Here is my Archive Command:
archive_command = 'cp -i %p /mnt/nfs/primary/%f < /dev/null'
Directory /mnt/nfs/primary ==> is an NFS mount.
Any solution how to fix it.
Thanks
Deepak Murthy
