Skip site navigation (1) Skip section navigation (2)

Re: MacOSX and pg_service

From: Herouth Maoz <herouth(at)spamcop(dot)net>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: MacOSX and pg_service
Date: 2012-01-26 13:51:17
Message-ID: 89EC2BDA-987A-40FF-A75B-75184F0125F5@spamcop.net (view raw or flat)
Thread:
Lists: pgadmin-support
On 26/01/2012, at 01:33, Tim Uckun wrote:

>> With the informations you told us, I can only conclude that the problem
>> is not pgAdmin or the pg_service file, but Mac OS X.
> 
> You may be right.  I was not having this problem with Linux.

You may have the same problem that I have - that when MacOS falls asleep, it truly doesn't allow any activity, including network activity, and thus the connection is not kept alive. I see this with all my interfaces to PostgreSQL (which resides on a different machine on the same network), not just pgAdmin. They all require reconnect after the Mac has been sleeping.

Linux machines tend not to be set up to sleep at all (at least my desktop Linuxes never fully sleep, just have their monitors sleep), and thus you may not have the same problem on your Linux.

I still wish it would be easier to reconnect after a connection is dropped in pgAdmin.

Herouth

In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2012-01-26 21:14:09
Subject: Re: column level privilages error
Previous:From: Emre HasegeliDate: 2012-01-26 10:41:36
Subject: [bug] Execute pgScript Returns Error Without Executing The Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group