Cygwin postmaster.pid solution?

From: Jon V <jon(at)cecorp(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Cygwin postmaster.pid solution?
Date: 2003-02-04 16:55:05
Message-ID: 3E3FF069.90509@cecorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

OK, I know this has been asked before. I've been reading archives from
various lists going back to 2001 dealing with this problem.
Unfortunately, I'm having trouble finding anything I know how to
actually apply as a solution.

PostgreSQL 7.3 running under cygwin on either an NT4.0 or Win2K machine.
If the system shuts down abnormally, the file postmaster.pid is left in
the $PGDATA directory. When the system boots back up, PostgreSQL fails
to start because of that file.

What do I do? Reading through archives, it seems as though various
solutions have been proposed. I can think of a couple easy solutions for
a unix box, and if I was running unix I wouldn't be writing this... but
unfortunately we aren't to that stage yet.

I don't know how to set up a boot script that runs before the services
start loading... except possibly to set up another service that is a
script run under a servany type program, set up so that the postmaster
service is dependent upon it. When postmaster loads the first time, this
other service would load first and clear out the pid and go into a long
sleep. I don't like that solution, but I'm about to try it...

Any suggestions greatly appreciated!

Thanks,
Jon

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message paul butler 2003-02-04 17:04:57 Re: Cygwin postmaster.pid solution?
Previous Message Steve Crawford 2003-02-04 16:49:19 Re: Finding Postgres Version????