From: | DM <dm(dot)aeqa(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgres 9.01 and WAL files issue |
Date: | 2010-11-24 17:52:41 |
Message-ID: | AANLkTiknJk3uF5rKAaSZeKxM=ow2Qt9ckzQ9z8x9jpb=@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | DM | 2010-11-24 18:23:15 | Re: diagram tools? |
Previous Message | Tom Lane | 2010-11-24 17:51:47 | Re: alter table add column - specify where the column will go? |