Обсуждение: Timing out.
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.
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 />
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.
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
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 />
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
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.
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:Yes, drop the %22 here, but this is not what I'm talking about.
> 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 ...
>
This is what you're looking for:
http://www.postgresql.org/docs/9.0/interactive/libpq-pgservice.html> documentation<http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html%22>link
> Using pgAdmin III
> Control Server
> *Server *link
> see pgpass> (this is the broken link)--
-----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-----
-----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-----
>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.
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
I have 1.14.0 Beta 2.
Is there a newer version?
I am running Windows 7, 64-bit, if that makes any difference.
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:It's nowhere in the docs. Should have already been fixed.
> 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.
>
--
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
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
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