Thread: Timing out.

Timing out.

From
Tim Uckun
Date:
There was a discussion recently about pgadmin timing out and hanging
up. I suffer from this a lot because I work with remote databases and
it really is painful.

I would like to make a request that there be an option for pgadmin to
send a query to the database every 10 seconds or something to keep the
connection alive.  It would save me so much pain.

Thanks.


Re: Timing out.

From
Dave Page
Date:
Use the keep-alive options on the server.<br /><br />On Tuesday, August 9, 2011, Tim Uckun <<a
href="mailto:timuckun@gmail.com">timuckun@gmail.com</a>>wrote:<br />> There was a discussion recently about
pgadmintiming out and hanging<br /> > up. I suffer from this a lot because I work with remote databases and<br
/>>it really is painful.<br />><br />> I would like to make a request that there be an option for pgadmin
to<br/>> send a query to the database every 10 seconds or something to keep the<br /> > connection alive.  It
wouldsave me so much pain.<br />><br />> Thanks.<br />><br />> --<br />> Sent via pgadmin-support
mailinglist (<a href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br /> > To make
changesto your subscription:<br />> <a
href="http://www.postgresql.org/mailpref/pgadmin-support">http://www.postgresql.org/mailpref/pgadmin-support</a><br
/>><br/><br />-- <br />Dave Page<br />Blog: <a href="http://pgsnake.blogspot.com"
target="_blank">http://pgsnake.blogspot.com</a><br/> Twitter: @pgsnake<br /><br />EnterpriseDB UK: <a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a><br />The Enterprise PostgreSQL
Company<br/><br /> 

Re: Timing out.

From
Tim Uckun
Date:
On Tue, Aug 9, 2011 at 7:51 PM, Dave Page <dpage@pgadmin.org> wrote:
> Use the keep-alive options on the server.

That effects all the clients.  Tora has a feature where you can tell
it to ping the server every once in a while so I think this would be a
good feature for pgadmin too.


Re: Timing out.

From
Guillaume Lelarge
Date:
On Tue, 2011-08-09 at 20:53 +1200, Tim Uckun wrote:
> On Tue, Aug 9, 2011 at 7:51 PM, Dave Page <dpage@pgadmin.org> wrote:
> > Use the keep-alive options on the server.
> 
> That effects all the clients.  Tora has a feature where you can tell
> it to ping the server every once in a while so I think this would be a
> good feature for pgadmin too.
> 

Use a pg_service.conf file, and pgAdmin 1.14. This way, only pgAdmin
will use the connection configuration.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Timing out.

From
Michael Shapiro
Date:
Where is the pg_service.conf file described? I can not find anything about it in the help that comes with PgAdmin.<br
/>Also,while looking in the help, I discovered a broken link (to an external page for the pgpass documentation<br /><br
/><ahref="http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22"
target="_blank">http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22</a><br/><br />The %22 shouldn't
bethere ...<br /><br />Using pgAdmin III<br />  Control Server<br />    <u>Server </u>link<br />      see <a
href="http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22"target="_blank">pgpass documentation</a>
link(this is the broken link)<br /><br /><br /><div class="gmail_quote">On Tue, Aug 9, 2011 at 10:53 AM, Guillaume
Lelarge<span dir="ltr"><<a href="mailto:guillaume@lelarge.info"
target="_blank">guillaume@lelarge.info</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex">On Tue, 2011-08-09 at 20:53 +1200, Tim Uckun wrote:<br /> > On Tue,
Aug9, 2011 at 7:51 PM, Dave Page <<a href="mailto:dpage@pgadmin.org" target="_blank">dpage@pgadmin.org</a>>
wrote:<br/> > > Use the keep-alive options on the server.<br /> ><br /> > That effects all the clients.
 Torahas a feature where you can tell<br /> > it to ping the server every once in a while so I think this would be
a<br/> > good feature for pgadmin too.<br /> ><br /><br /> Use a pg_service.conf file, and pgAdmin 1.14. This
way,only pgAdmin<br /> will use the connection configuration.<br /><br /><br /> --<br /> Guillaume<br />  <a
href="http://blog.guillaume.lelarge.info"target="_blank">http://blog.guillaume.lelarge.info</a><br />  <a
href="http://www.dalibo.com"target="_blank">http://www.dalibo.com</a><br /><font color="#888888"><br /><br /> --<br />
Sentvia pgadmin-support mailing list (<a href="mailto:pgadmin-support@postgresql.org"
target="_blank">pgadmin-support@postgresql.org</a>)<br/> To make changes to your subscription:<br /><a
href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></font></blockquote></div><br /> 

Re: Timing out.

From
Guillaume Lelarge
Date:
On Tue, 2011-08-09 at 11:02 -0500, Michael Shapiro wrote:
> Where is the pg_service.conf file described? I can not find anything about
> it in the help that comes with PgAdmin.
> Also, while looking in the help, I discovered a broken link (to an external
> page for the pgpass documentation
> 
> http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22
> 
> The %22 shouldn't be there ...
> 

Yes, drop the %22 here, but this is not what I'm talking about.

This is what you're looking for:
 http://www.postgresql.org/docs/9.0/interactive/libpq-pgservice.html

> Using pgAdmin III
>  Control Server
>     *Server *link
>       see pgpass
> documentation<http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22>link
> (this is the broken link)


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Timing out.

From
Michael Shapiro
Date:
This documentation tends to oriented toward Unix machines. Where would the pg_service.conf file be found on a Windows box?
It doesn't exist on my machine at the present, so I have no idea where I would create it so that PgAdmin could use it.

On Tue, Aug 9, 2011 at 11:16 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
On Tue, 2011-08-09 at 11:02 -0500, Michael Shapiro wrote:
> Where is the pg_service.conf file described? I can not find anything about
> it in the help that comes with PgAdmin.
> Also, while looking in the help, I discovered a broken link (to an external
> page for the pgpass documentation
>
> http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22
>
> The %22 shouldn't be there ...
>

Yes, drop the %22 here, but this is not what I'm talking about.

This is what you're looking for:

 http://www.postgresql.org/docs/9.0/interactive/libpq-pgservice.html

> Using pgAdmin III
>  Control Server
>     *Server *link
>       see pgpass
> documentation<http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22>link
> (this is the broken link)


--

Re: Timing out.

From
Andreas Neumann
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/09/2011 06:02 PM, Michael Shapiro wrote:
> Where is the pg_service.conf file described? I can not find anything about
> it in the help that comes with PgAdmin.

http://www.postgresql.org/docs/current/static/libpq-pgservice.html

My GIS database clients store a lot of PG references using connection
info with host/db/etc. Recently I switched to pg_service and
pg_service.conf - When I want to connect to a different server it is
handy just to edit the connection once and centrally in the
pg_service.conf rather than hard-wiring server names or IP-addresses and
having to find/replace connection infos in multiple project files.

Andreas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJOQVwBAAoJELiCsGDopvBCOuEH/jVQr3e2a54fArhP8GfAlpt3
bHzTHV4goHJhF338QnfPLhBH4a1daj31WdvygzFRDVe5+/IyYrKmK5xpq8MbZ32P
gZOmIWN/lNzRZUA4JdlPe+yKmCAPYSCwdIF5F0deRAPcTcQZrgZcIVvIZouglThe
QzxzrDfkkPtraOVXSo1c8q3LiXtKmn3Wt5hoUqhZUzzkcDKDh1ts99OzbjRDLu2a
JcnVOYzdifjZzRwE+gx9p1/0Gi44xZAG7+CBONayfTI843TAlcs3VNdhIUF/JmQL
uWwnrTsgCNICri7bFFVk0lNEaE8M/xR08ZiXkHRORMYOVH9Jx9r1aT8VEMDOGDc=
=hND7
-----END PGP SIGNATURE-----


Re: Timing out.

From
Andreas Neumann
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/09/2011 06:24 PM, Michael Shapiro wrote:
> This documentation tends to oriented toward Unix machines. Where would the
> pg_service.conf file be found on a Windows box?

you can have it anywhere you like. I usually have it on a network drive
so it can be shared between different machines.

Just create a regular windows environment variable named PGSYSCONFDIR
(either on a user or system level) and point it to the path where you
want to place the pg_service.conf file.

Hope this helps,
Andreas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJOQX45AAoJELiCsGDopvBCicAH/iY+DeMxwtRo9WjRQroiAnvE
Sy55nUZqcodlHOOdjq8DJsR+RhiLrlk8GiGSI8bqVZFkoLUfLi3MaXkBl0grJH4B
pYmLAtuCtb2DHc0PboITr/GfEYqhRRFWVCt9d3V3Hlbia5FswMdjpb1oHkzrNJ00
4qUWO5O7yi3sMQkvxDastZxgEfpljRwLuoaVATceI377K2mPvNuPhlCKdgB0lkiq
lcaKgTGnib+hRjBbQ+rZBOOSMkilace2PuEMg02Ys1uCwmnYA5OlUt+jxZBosVuZ
giMnOFrPxbZcxh4hkeiDezytGUfCiEokT47FPCs7uqc91SspG382oMLdzXpybt0=
=Cy9I
-----END PGP SIGNATURE-----


Re: Timing out.

From
Tim Uckun
Date:
>Use a pg_service.conf file, and pgAdmin 1.14. This way, only pgAdmin
>will use the connection configuration.



Are there debs or a ppa for the pgadmin 1.14?  I saw that you had debs
for older Ubuntu version but not the recent ones.


Re: Timing out.

From
Guillaume Lelarge
Date:
On Tue, 2011-08-09 at 11:20 -0500, Michael Shapiro wrote:
> Thanks. I realize that the broken link wasn't the topic of discussion, but
> since I ran across it while trying to the info about pg_service, I thought
> I'd point it out. It is in the help distributed with pg_admin so it should
> be fixed there.
> 

It's nowhere in the docs. Should have already been fixed.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Timing out.

From
Michael Shapiro
Date:
I have 1.14.0 Beta 2.
Is there a newer version?
I am running Windows 7, 64-bit, if that makes any difference.

On Thu, Aug 11, 2011 at 4:05 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
On Tue, 2011-08-09 at 11:20 -0500, Michael Shapiro wrote:
> Thanks. I realize that the broken link wasn't the topic of discussion, but
> since I ran across it while trying to the info about pg_service, I thought
> I'd point it out. It is in the help distributed with pg_admin so it should
> be fixed there.
>

It's nowhere in the docs. Should have already been fixed.


--

Re: Timing out.

From
Guillaume Lelarge
Date:
On Thu, 2011-08-11 at 16:10 -0500, Michael Shapiro wrote:
> I have 1.14.0 Beta 2.
> Is there a newer version?

Beta 3, and a few fixes since.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Timing out.

From
Guillaume Lelarge
Date:
On Wed, 2011-08-10 at 10:11 +1200, Tim Uckun wrote:
> >Use a pg_service.conf file, and pgAdmin 1.14. This way, only pgAdmin
> >will use the connection configuration.
> 
> 
> 
> Are there debs or a ppa for the pgadmin 1.14?  I saw that you had debs
> for older Ubuntu version but not the recent ones.
> 

AFAICT, no. Last one is 1.12.3 in Ubuntu 11.10dev
(https://launchpad.net/ubuntu/+source/pgadmin3). 1.12.3 is available for
sid, and 1.14.0 beta 1 is in experimental.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Timing out.

From
Guillaume Lelarge
Date:
On Thu, 2011-08-11 at 16:46 -0500, Michael Shapiro wrote:
> I just installed Beta 3 and the problem with the %22 in the URL in the help
> remains.
> 

You're right. It should be fixed now (but know that it's already too
late for 1.14.0).


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com