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
datadirectory.
As you said you changed the PostgreSQL service account then it stopped working, it is probably a permission thing. On
Linuxthe data directory must have permissions for the postgres user and the postgres user ONLY, so assuming something
similarapplies 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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of danny
Sent: Thursday, April 23, 2015 12:57 AM
To: pgsql-admin@postgresql.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
serviceaccount
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
notin 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@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
