Re: [SQL] Issue with postgres connectivity

2011-01-22 Thread Arindam Hore
...@postgresql.org] On Behalf Of Jasen Betts Sent: Saturday, January 22, 2011 2:24 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Issue with postgres connectivity On 2011-01-21, Arindam Hore wrote: > We are accessing database using ip address. try adding the IP addresses of some of the clients

Re: [SQL] Issue with postgres connectivity

2011-01-22 Thread Arindam Hore
-sql@postgresql.org Subject: Re: [SQL] Issue with postgres connectivity We are accessing database using ip address. -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Reinoud van Leeuwen Sent: Friday, January 21, 2011 4:27 PM To

Re: [SQL] Issue with postgres connectivity

2011-01-22 Thread Jasen Betts
On 2011-01-21, Arindam Hore wrote: > We are accessing database using ip address. try adding the IP addresses of some of the clients as seen by the server to /etc/hosts on the server. see if that helps. try connecting to the server locally using 'su postgres -c psql' see if that's slow too. --

Re: [SQL] Issue with postgres connectivity

2011-01-21 Thread Edward W. Rouse
: [SQL] Issue with postgres connectivity We are accessing database using ip address. -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Reinoud van Leeuwen Sent: Friday, January 21, 2011 4:27 PM To: pgsql-sql@postgresql.org Subject

Re: [SQL] Issue with postgres connectivity

2011-01-21 Thread Arindam Hore
We are accessing database using ip address. -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Reinoud van Leeuwen Sent: Friday, January 21, 2011 4:27 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Issue with postgres

Re: [SQL] Issue with postgres connectivity

2011-01-21 Thread Arindam Hore
] Issue with postgres connectivity On Fri, Jan 21, 2011 at 10:45:37AM +, Arindam Hore wrote: > Hello All, > > I am facing a big problem in postgres connectivity using php application. It > is taking almost 10 sec for connection establishment. All my applications > were working p

Re: [SQL] Issue with postgres connectivity

2011-01-21 Thread Reinoud van Leeuwen
On Fri, Jan 21, 2011 at 10:45:37AM +, Arindam Hore wrote: > Hello All, > > I am facing a big problem in postgres connectivity using php application. It > is taking almost 10 sec for connection establishment. All my applications > were working perfectly 2 days before. Yesterday just it starte

[SQL] Issue with postgres connectivity

2011-01-21 Thread Arindam Hore
Hello All, I am facing a big problem in postgres connectivity using php application. It is taking almost 10 sec for connection establishment. All my applications were working perfectly 2 days before. Yesterday just it started giving problem. Using pg-admin also it is taking time to connect as w