Re: [GENERAL] Missing WAL files - file-based replication

2013-04-29 Thread Scott Briggs
Tom, thanks for the quick reply. Unfortunately, rebuilding the backup server from the master is not really an option at this point. This is a fairly large database (~1TB), are there any other options that will allow us to get the backup server to ingest WAL files without database corruption? Tha

Re: [GENERAL] Missing WAL files - file-based replication

2013-04-28 Thread Tom Lane
Scott Briggs writes: > 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 que

[GENERAL] Missing WAL files - file-based replication

2013-04-28 Thread Scott Briggs
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 se