Missing WAL files - file-based replication

From: Scott Briggs <scott(dot)br(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Missing WAL files - file-based replication
Date: 2013-04-28 13:56:33
Message-ID: CADKfymEy1s-vPg69XMK+3UbhYSVS9FFr-0VWO=4x282TwXExOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So we're using 8.3 with file-based replication using rsync to a warm backup
server. The problem is the backup server crashed and somehow WAL files got
lost so the backup server is continuously looking for WAL files that are no
longer available on the master.

My question is, how can I skip to a set WAL file so that the recovery
process can start ingesting WAL files again? I realize there's going to be
a certain amount of data loss but that's not as important as getting the
backup server processing log files, in other words I don't care about the
data loss.

There are approximately 20 WAL files missing. I've tried to find out where
pg_standby keeps a record of the current file it's trying to restore but I
can't find any information on where that information is kept.

Can I use pg_standby NEXTWALFILE in the restore_command to do what I'm
trying to do? And if I hard set NEXTWALFILE, will pg_standby still
automatically increment WAL files it's ingesting when it finishes the hard
set file?

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-04-28 15:22:46 Re: Missing WAL files - file-based replication
Previous Message Ian Lawrence Barwick 2013-04-28 06:22:27 Re: pgAdmin shows two servers with the identical data