Re: server doesn't listen postgresql 9.1 after service change

Hello Danny,

So what does the server log say? If you don't know where it is, it is most likely in the pg_log subdirectory of your data directory.

As you said you changed the PostgreSQL service account then it stopped working, it is probably a permission thing. On Linux the data directory must have permissions for the postgres user and the postgres user ONLY, so assuming something similar applies to Windows, maybe you didn't take away the permissions for your old service account?

Best regards
Holger Friedrich

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of danny
Sent: Thursday, April 23, 2015 12:57 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] server doesn't listen postgresql 9.1 after service change

Don't know what the error is please help me guys I am pretty new to PostgreSQL

I did Install PostgreSQL 9.1 on my 2012 R2 windows server It did installed successfully now I changed PostgreSQL service account

Facing error when trying to restart PostgreSQL service !

The PostgreSQL 9.1 service on local computer started and then stopped. Some services stooped automatically if they are not in use by other services or programs.
<http://postgresql.nabble.com/file/n5846460/Capture03.png>

When I am trying to login to PostgreSQL database facing the below errors <http://postgresql.nabble.com/file/n5846460/Capture.png>
<http://postgresql.nabble.com/file/n5846460/Capture01.png>
Server Doesn't listen
I checked config file

listen_addresses = '*'
port = 5432

--
View this message in context: http://postgresql.nabble.com/server-doesn-t-listen-postgresql-9-1-after-service-change-tp5846460.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin