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
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 |