intermittent issue with windows 7 service manager not able to correctly determine or control postgresql 9.4

From: Tom Hodder <tom(at)limepepper(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: intermittent issue with windows 7 service manager not able to correctly determine or control postgresql 9.4
Date: 2016-05-01 02:35:44
Message-ID: CAB+zPJAPNVYxymanFT=FEKejFudQT4WDpbKDsNTu6xKguFN3Uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I've got several machines running windows 7 which have postgresql 9.4
installed as a service, and configured to start automatically on boot. I am
monitoring these services with zabbix and several times a week I get a
notification that the postgresql-x64-9.4 service has stopped.

When I login to the machine, the service does appear to be stopped;

However when I check the database, I can query it ok;

*C:\Program Files\PostgreSQL\9.4>bin\psql.exe -U postgres -c "SELECT
count(*) from media;" associationPassword for user postgres:
count--------- 1167846(1 row)*

If I try to start the service from the service manager, I see the following
error in the logs;

*2016-04-30 05:03:13 BST FATAL: lock file "postmaster.pid" already
exists2016-04-30 05:03:13 BST HINT: Is another postmaster (PID 2556)
running in data directory "C:/Program Files/PostgreSQL/9.4/data"?*

The pg_ctl tool seems to correctly query the state of the service and
return the correct PID;

*C:\Program Files\PostgreSQL\9.4>bin\pg_ctl.exe -D "C:\Program
Files\PostgreSQL\9.4\data" status
pg_ctl: server is running (PID: 2556**)*

The other thing that seems to happen is the pgadmin3 tool seems to
have lost the ability to control the service as all the options for
start/stop are greyed out;
[image: Inline images 2]

The only option to get the control back is to kill the processes in
the task manager or reboot the machine.

Any suggestions on what might be causing this?

Thanks,

Tom

Responses

Browse pgsql-general by date

  From Date Subject
Next Message david 2016-05-01 02:57:02 Re: intermittent issue with windows 7 service manager not able to correctly determine or control postgresql 9.4
Previous Message Stephen Cook 2016-05-01 02:04:19 Re: Skip trigger?