Re: What is postgresql status?

On 24/08/2011 19:53, Mcleod, John wrote:
> C:\ms4w\apps\pgsql75win>cd c:\
>
> C:\>cd ms4w/apps/pgsql75win/data/
>
> C:\ms4w\apps\pgsql75win\data>del postmaster.pid
>
> Could Not Find C:\ms4w\apps\pgsql75win\data\postmaster.pid
>
> LOG: database system was shut down at 2011-08-24 17:30:14 Eastern
> Standard Time
> LOG: checkpoint record is at 0/34CD4078
> LOG: redo record is at 0/34CD4078; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 1198832; next OID: 1772830
> LOG: database system is ready
>
>
> I'm not sure if the database is up or not.
> I don't even see postgresql or mapserver as Windows services.

From the above I'd guess that Postgres isn't installed as a service, but
is being run from a batch file. Postgres writes a small text file with
its process ID in the data directory while it's running, and that's what
the first line above is trying to delete - but PG removed it when it was
shut down, so the DEL command isn't finding it.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie