Prevent pgAdmin disconnect

From: Jack Kaufman <jack(dot)kaufman(at)sanmina(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Prevent pgAdmin disconnect
Date: 2013-01-24 16:42:29
Message-ID: CAM=VM80t8=nuNHAXehF20yTnhVmBL-vEKSUJ4P+sEiXaU83ayA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Postgres 9.2 / pgAdmin III

Linux / Windows XP

Hello,

I am in a test environment, using pgAdmin III, connected to PostgreSQL on a
Linux server.

The main PgAdmin window is dropping its connection to the PostgreSQL
database. If I am away from it, say, for more than 15 minutes, I lose the
connection and must hit a few keys and wait for pgAdmin to re-connect. Not
a show-stopper but a constant nuisance.

I understand that this can be fixed on the server side; but the DBA has
more important issues, at the moment (I'm sure, when we get to production,
many months from now, it will be taken care of; but I would rather not put
up with this for months, if I don't have to).

The same thing happens in a pgAdmin Query window; but I have found a
solution for that: When I start a Query window, the first thing I run is
"set session tcp_keepalives_idle = 300;" and then it holds the connection
for the rest of the day.

I found a configuration file, "postgresql.conf" (in "C:\Program
Files\PostgreSQL\9.2\data") which has the same "keepalives" setting; and
I've tried setting that to 300, as well; but that doesn't stop the main
pgAdmin window from disconnecting from the PostgreSQL database.

What do I prevent the main pgAdmin window from disconnecting from the
PostgreSQL database every 15 minutes?

Thanks in advance, Jack

--
Jack Kaufman
MDS Application Devl (US)
Sanmina-SCI Corporation - Owego site
Email: jack(dot)kaufman(at)sanmina(dot)com
Skype: jack_kaufman_sanm
607-723-0507

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Ouellette 2013-01-24 19:54:59 Re: WAL replication question
Previous Message Michael Wood 2013-01-22 13:49:26 Re: WAL replication question