Re: Logfile removal - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Logfile removal
Date
Msg-id 20030521110855.GC15901@libertyrms.info
Whole thread Raw
In response to Logfile removal  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List 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 by date:

Previous
From: "Dhananjay Mishra"
Date:
Subject: TCP/IP connection
Next
From: Tom Lane
Date:
Subject: Re: Logfile removal