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

Поиск
Список
Период
Сортировка
От Harshad Adalkonda
Тема Re: server doesn't listen postgresql 9.1 after service change
Дата
Msg-id CANnQH_iEtzTcDnNKw8WdBeOy9WivM5sLsgYxT1yDjzhHDyaUpA@mail.gmail.com
обсуждение исходный текст
Ответ на server doesn't listen postgresql 9.1 after service change  (danny <dinesh4202001@gmail.com>)
Ответы Re: server doesn't listen postgresql 9.1 after service change  (danny <dinesh4202001@gmail.com>)
Список pgsql-admin
Дерево обсуждения

On Thu, Apr 23, 2015 at 4:27 AM, danny <dinesh4202001@gmail.com> wrote:

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hi Danny,

There might be other postgresql server or service is using 5432 port, check it by following command

netstat -abno | findstr :5432

Turn on the postgresql logs from postgresql.conf and check postgresql logs for errors.

If still you cant find post the logs here.

Try to start postgresql from command prompt, if it is working then default service is got corrupted.

You can also create new service for same server as follows

Syntax:

pg_ctl register -N [SERVICENAME] -U [USERNAME] -P [PASSWORD] -D [DATADIR] -S [START-TYPE] -w

Example:

pg_ctl register -N postgresql-9.1 -U postgres -P postgres -D D:\PostgreSQL\9.1\Data -S auto -w

I hope above solution will solve the problem.

--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com

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

Предыдущее
От:
Дата:
Сообщение: Re: server doesn't listen postgresql 9.1 after service change
Следующее
От: danny
Дата:
Сообщение: Re: server doesn't listen postgresql 9.1 after service change