Re: Logfile removal

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