Re: Unable to start postgres in recovery mode.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dhaval Shah" <dhaval(dot)shah(dot)m(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to start postgres in recovery mode.
Date: 2007-03-20 15:07:03
Message-ID: 13759.1174403223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dhaval Shah" <dhaval(dot)shah(dot)m(at)gmail(dot)com> writes:
> What am I doing wrong?

Lying to the server. If you don't have the requested file, return
failure, don't invent something. There are a number of cases where
the recovery process asks for files that are quite likely not to exist.

> If I indicate that I do not have the concerned file by returning error
> code 1, I get the following error in the log:

This may indicate that you have an incomplete backup :-(. It's hard to
tell from this much info though. What is in pg_control (use
pg_controldata to dump) and what is in the backup_label file (that's
plain text)? What WAL segment files do you actually have?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2007-03-20 15:08:04 LISTEN/NOTIFY and python
Previous Message filippo 2007-03-20 14:58:05 shell script to SQL statement: `pg_dump | psql -U`