Thread: Issue with postgres connectivity

Issue with postgres connectivity

From
Arindam Hore
Date:
<div class="Section1"><p class="MsoNormal">Hello All,<p class="MsoNormal"> <p class="MsoNormal">I am facing a big
problemin postgres connectivity using php application. It is taking almost 10 sec for connection establishment. All my
applicationswere working perfectly 2 days before. Yesterday just it started giving problem. Using pg-admin also it is
takingtime to connect as well as same with opening server status window or with sql query window.<p
class="MsoNormal"> <pclass="MsoNormal">Postgres is installed in linux environment. Don’t know whether is it due to some
virusor something else.<p class="MsoNormal"> <p class="MsoNormal">Please provide me with some guidelines. Ask me any
queries.<pclass="MsoNormal"> <p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">Thanks,</span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">Arindam</span><pclass="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif""> </span></b><pclass="MsoNormal"><b><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">V2Solutions<br/></span></i></b><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">ANew Vision to Solutions</span></i><i><span
style="font-size:10.0pt;font-family:
"Courier New""><br /></span></i><i><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">India:
+91-22-66733201Ext:- 676<br /> US : 1-408-454-6051 Ext:- 263<br /></span></i><i><a
href="http://www.v2solutions.com/"><spanstyle="font-size: 
10.0pt;font-family:"Arial","sans-serif";color:blue">http://www.v2solutions.com</span></a><br /></i><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">TZ: +5:30 GMT</span></i><i></i><p class="MsoNormal"> </div>
Thisemail and any files transmitted with it are confidential and intended solely for the use of the individual or
entityto whom they are addressed. If you have received this email in error please notify the system manager. This
messagecontains confidential information and is intended only for the individual named. If you are not the named
addresseeyou should not disseminate, distribute or copy this e-mail.  

Re: Issue with postgres connectivity

From
Reinoud van Leeuwen
Date:
On Fri, Jan 21, 2011 at 10:45:37AM +0000, 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 started giving problem. Using
pg-adminalso it is taking time to connect as well as same with opening server status window or with sql query window.
 
> 
> Postgres is installed in linux environment. Don't know whether is it due to some virus or something else.
> 
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________


Re: Issue with postgres connectivity

From
Arindam Hore
Date:
Thanks Reinoud for quick reply. How can I test it? Is there any way?

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@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

On Fri, Jan 21, 2011 at 10:45:37AM +0000, 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 started giving problem. Using
pg-adminalso it is taking time to connect as well as same with opening server status window or with sql query window. 
>
> Postgres is installed in linux environment. Don't know whether is it due to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended solely for the use of the individual or
entityto whom they are addressed. If you have received this email in error please notify the system manager. This
messagecontains confidential information and is intended only for the individual named. If you are not the named
addresseeyou should not disseminate, distribute or copy this e-mail. 


Re: Issue with postgres connectivity

From
Arindam Hore
Date:
We are accessing database using ip address.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@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

On Fri, Jan 21, 2011 at 10:45:37AM +0000, 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 started giving problem. Using
pg-adminalso it is taking time to connect as well as same with opening server status window or with sql query window. 
>
> Postgres is installed in linux environment. Don't know whether is it due to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended solely for the use of the individual or
entityto whom they are addressed. If you have received this email in error please notify the system manager. This
messagecontains confidential information and is intended only for the individual named. If you are not the named
addresseeyou should not disseminate, distribute or copy this e-mail. 


Re: Issue with postgres connectivity

From
"Edward W. Rouse"
Date:
When was the last time you did a vacuum analyze?

Edward W. Rouse


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Arindam Hore
Sent: Friday, January 21, 2011 6:44 AM
To: Reinoud van Leeuwen; pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

We are accessing database using ip address.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@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

On Fri, Jan 21, 2011 at 10:45:37AM +0000, 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 started giving
problem. Using pg-admin also it is taking time to connect as well as same
with opening server status window or with sql query window.
>
> Postgres is installed in linux environment. Don't know whether is it due
to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



Re: Issue with postgres connectivity

From
Jasen Betts
Date:
On 2011-01-21, Arindam Hore <arindam.hore@in.v2solutions.com> 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.

-- 
⚂⚃ 100% natural


Re: Issue with postgres connectivity

From
Arindam Hore
Date:
Sorry for late reply. We usually do vacuum analyze daily basis using cron.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Edward W. Rouse
Sent: Friday, January 21, 2011 8:17 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

When was the last time you did a vacuum analyze?

Edward W. Rouse


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Arindam Hore
Sent: Friday, January 21, 2011 6:44 AM
To: Reinoud van Leeuwen; pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

We are accessing database using ip address.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@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

On Fri, Jan 21, 2011 at 10:45:37AM +0000, 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 started giving
problem. Using pg-admin also it is taking time to connect as well as same
with opening server status window or with sql query window.
>
> Postgres is installed in linux environment. Don't know whether is it due
to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended solely for the use of the individual or
entityto whom they are addressed. If you have received this email in error please notify the system manager. This
messagecontains confidential information and is intended only for the individual named. If you are not the named
addresseeyou should not disseminate, distribute or copy this e-mail. 


Re: Issue with postgres connectivity

From
Arindam Hore
Date:
What I have seen is that, when I am trying to connect the db server from application server using ssh, the response was
veryslow. While from db server to application server it is very quick as usually.
 

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@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 <arindam.hore@in.v2solutions.com> 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.

--
⚂⚃ 100% natural

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended solely for the use of the individual or
entityto whom they are addressed. If you have received this email in error please notify the system manager. This
messagecontains confidential information and is intended only for the individual named. If you are not the named
addresseeyou should not disseminate, distribute or copy this e-mail.