Postgres 9.01 and WAL files issue

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

Responses

Browse pgsql-general by date

  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?