Re: Logfile removal

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Logfile removal
Дата
Msg-id 20030521110855.GC15901@libertyrms.info
обсуждение исходный текст
Ответ на Logfile removal  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
Список pgsql-admin
On Wed, May 21, 2003 at 11:04:39AM +0530, A.Bhuvaneswaran wrote:

> I have run postmaster with -l option. When postmaster is running, i have
> removed the logfile accidentally.

Define "logfile".  Do you mean the pg_xlog?  If no, then your
start-up script will presumably create the log file for you when you
re-start.  If yes, however, then. . .

> I am unable to restart postmaster now
> due to various other reasons.

. . .it's not only other reasons.  You'll need to run pg_resetxlog.
Keep in mind that you are likely to have a mess on your hands
afterwards.  In particular, there may be inconsistencies in your
data.  Read the relevant docs.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: "Dhananjay Mishra"
Дата:
Сообщение: TCP/IP connection
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Logfile removal