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_g_8pTWvRGnjb--m9=_pvyTVN8Upjso493PwYgK5p_poQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: server doesn't listen postgresql 9.1 after service change  (danny <dinesh4202001@gmail.com>)
Список pgsql-admin
Дерево обсуждения

On Fri, Apr 24, 2015 at 9:42 PM, danny <dinesh4202001@gmail.com> wrote:

Hi Danny,

 1)

Harshad,

Thanks for the reply I did check logs and now its working I did change
services butnow I want to know how can I establish connection between client machine to server

Run the following command from cmd by cd C:\Program Files\PostgreSQL\9.1\bin directory of postgresql

psql -h ip address dbserver -U username -d dbname -p port
 
Ex: 

 psql -h 192.168.0.110 -U postgres -d postgres -p 5432           (From other system ip entry should be present in pg_hba.conf of postgresql)

 psql -h 127.0.0.1 -U postgres -d postgres -p 5432                  (From localhost/ same system)

2)

and how I know if PostgreSQL is running under same service I mentioned still it is asking for default password which I have
given during installation

Is it asking password for service or while connecting to psql terminal ?

For psql terminal it will ask password because it is md5 is default security in postgresql server.

Following PostgreSQL Document link will help you to solve your problems

http://www.postgresql.org/docs/9.1/static/index.html

Hope above solution will solve your problem.

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

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

Предыдущее
От: Andre_Mikulec
Дата:
Сообщение: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?