Re: how to use pg_resetxlog

Поиск
Список
Период
Сортировка
От Johnson, Shaunn
Тема Re: how to use pg_resetxlog
Дата
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FEDAD7@snt452.corp.bcbsm.com
обсуждение исходный текст
Ответ на how to use pg_resetxlog  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Ответы Re: how to use pg_resetxlog  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

 
--you're right about the contrib version - it's wrong.
--can i d/l an old version and recompile it?

-X
-----Original Message-----
From: Tom Lane
To: Johnson, Shaunn
Cc: pgsql-general@postgresql.org
Sent: 10/21/03 10:17 AM
Subject: Re: [GENERAL] how to use pg_resetxlog

"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> --I did the pg_resetxlog -f $PGDATA and
> --it generated a new log, but when I try to
> --restart the database, it fails.  I look in the
> --logs and I see:

> [snip]
> Oct 21 01:32:13 localsvr postgres[2598]: [1] FATAL 2: 
> control file context is broken

Are you sure you used the right version of pg_resetxlog?  This seems to
indicate that pg_resetxlog produced a bogus pg_control file.
pg_controldata might help to identify the problem.

                        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how to use pg_resetxlog
Следующее
От: Tom Lane
Дата:
Сообщение: Re: how to use pg_resetxlog