Re: standby waiting for what?

Поиск
Список
Период
Сортировка
От Ray Stell
Тема Re: standby waiting for what?
Дата
Msg-id 20090304213500.GE25611@cns.vt.edu
обсуждение исходный текст
Ответ на Re: standby waiting for what?  (Yauheni Labko <yyl@chappy.com>)
Ответы Re: standby waiting for what?
Re: standby waiting for what?
Список pgsql-admin
On Wed, Mar 04, 2009 at 03:41:06PM -0500, Yauheni Labko wrote:
> For some reason it is looking for 00000002000000000000001C.00512178.backup
> file which is not the WAL file.
>
> Are you sure that you made initial recovery properly?

I could have fouled this in any number of ways.  Like I said
I'm trying to understand how to analyze the situation and maybe
learn something.

OK, so my recovery.conf is set like this:

restore_command='/usr/local/pgsql/bin/pg_standby  /data/pgsql/wals/alerts_oamp %f %p %r >>
/home/postgresql/log/alerts_oamp/recovery.log'

So, the %f arg sent to the pg_standby command has a value of
00000002000000000000001C.00512178.backup, right?  Is that wrong?
If so, where could that have come from or how could I have trashed
the thing.

I love fishing.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgressql backup/restore question
Следующее
От: Carol Walter
Дата:
Сообщение: Re: Database in use?