On 3-Oct-07, at 12:38 PM, Tom Lane wrote:
What this sounds like to me is a problem in your recovery procedures.
What exactly did you do to "bring the database out of recovery mode"?
The script looked for a trigger file and once found, aborts.
Unfortunately, it would abort without doing the re
Brian Wipf <[EMAIL PROTECTED]> writes:
> Last night, I brought the database out of its perpetual recovery
> mode. Here are the lines from the log when this was done:
> [2007-10-01 23:43:03 MDT] LOG: restored log file
> "000104660060" from archive
> [2007-10-01 23:45:50 MDT] LOG: c
We have two PostgreSQL 8.2.4 servers. On one database, WALs are
archived with a simple script that gzips and transfers them to an NFS
file server. The other database is in perpetual recovery mode,
ungizipping and processing the WALs as they appear and become
complete on the file server. Thi
