Re: What is postgresql status?

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: What is postgresql status?
Дата
Msg-id 4E554D65.2030600@iol.ie
обсуждение исходный текст
Ответ на What is postgresql status?  ("Mcleod, John" <johnm@spicergroup.com>)
Список pgsql-general
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@iol.ie

В списке pgsql-general по дате отправления:

Предыдущее
От: Alex Hunsaker
Дата:
Сообщение: Re: plperlu function caused a segmentation fault
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: What is postgresql status?