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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110