Re: Cygwin postmaster.pid solution?

Date sent:          Tue, 04 Feb 2003 09:23:40 -0800
From:               Jon V <jon@cecorp.com>
To:                 paul@entropia.co.uk
Copies to:          pgsql-novice@postgresql.org
Subject:            Re: [NOVICE] Cygwin postmaster.pid solution?

I'm afraid I don't know about windows start up scripts,
a .bat or .vbs file in the startup folder maybe but I've no idea if
services are run before the starup folder is accessed, sorry I
misunderstood you
maybe these can help

http://www.winscriptingsolutions.com
www.windowsshellscripting.com

> paul butler wrote:
>
> >Just delete the .pid file in windows or rm it in cygwin,
> >bob's your uncle
> >HTH
> >
> >
> Well, yes, but... how do I do that automatically at boot?
>
> The servers don't really have on-site administrators, and it would be a
> real nightmare if any time one rebooted for whatever reason we had to
> dial in to it just to delete one PIDling little file. :)
>
>
>
> >Paul Butler
> >
> >
> >
> >>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
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 5: Have you checked our extensive FAQ?
> >>
> >>http://www.postgresql.org/users-lounge/docs/faq.html
> >>
> >>
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 5: Have you checked our extensive FAQ?
> >
> >http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
> >
> >
>
>