Обсуждение: Not able to connect clients
Hi, Platform you're running on - Windows XP SP2 Language - English Version you tested - Version 8.3 I am not able to connect clients to the Server. I have done with the settings (Listen_Address) that are required on PostgreSQL.conf. Please suggest me what else i can do. Regards, Vrushali Khavnekar
On 14/10/2008 13:10, Vrushali Khavnekar wrote: > I am not able to connect clients to the Server. > > I have done with the settings (Listen_Address) that are required on PostgreSQL.conf. > > Please suggest me what else i can do. Well, you could start by showing us what happens when you try to connect :-) - any error messages, etc. Also, some things to check: * Can you ping the server? * Is the server actually running? * Have you tried connecting with psql? * Have you edited ph_hba.conf to allow connections from the necessary user and/or host? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
Hi Ray, Thanks for replying. Let me answer your questions: * Can you ping the server? ---> Yes, I ping the server & it's working fine.The network is ok between client & server. * Is the server actually running? ---> Yes server is actually running because we are able to connect it locally. * Have you tried connecting with psql? ---> Please elaborate more .what is psql? * Have you edited ph_hba.conf to allow connections from the necessary user and/or host? ---> No we have not edited "ph_hba.conf" file,because we don't know what changes we have to make in this configuration files. Please find attached "pg_hba.conf" and "postgresql.conf" files for your reference. Thanks & Regards, Vrushali Khavnekar >>> Raymond O'Donnell <rod@iol.ie> 10/14/2008 6:31 PM >>> On 14/10/2008 13:10, Vrushali Khavnekar wrote: > I am not able to connect clients to the Server. > > I have done with the settings (Listen_Address) that are required on PostgreSQL.conf. > > Please suggest me what else i can do. Well, you could start by showing us what happens when you try to connect :-) - any error messages, etc. Also, some things to check: * Can you ping the server? * Is the server actually running? * Have you tried connecting with psql? * Have you edited ph_hba.conf to allow connections from the necessary user and/or host? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
Вложения
On 15/10/2008 05:48, Vrushali Khavnekar wrote: > * Have you edited ph_hba.conf to allow connections from the necessary > user and/or host? ---> No we have not edited "ph_hba.conf" > file,because we don't know what changes we have to make in this > configuration files. Hi Vrushali, This more than likely your problem, so - the default pg_hba.conf allows local connections, but disallows connections from other hosts. You need to enter a line for the host from which you'll be connecting. There is good documentation in the comments in the file itself, as well as in the PostgreSQL documentation: http://www.postgresql.org/docs/8.3/static/client-authentication.html Can you show us what error you get when trying to connect? - If the problem is with pg_hba.conf, you should have got a message to that effect. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------