From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
---|---|
To: | "Frank Bax" <fbax(at)sympatico(dot)ca> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: connection timeout? |
Date: | 2007-02-03 18:35:23 |
Message-ID: | bf54be870702031035t1b228d8an28c5a8b86d28f945@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Make sure there is no firewall setting in between the database server and
application that might be closing the connections...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/3/07, Frank Bax <fbax(at)sympatico(dot)ca> wrote:
>
> Is there a connection timeout? I'm using DBD::Pg (1.47) in perl to
> access
> 8.2.1 database.
>
> I've got a rather long running script; it does a bit of database access,
> then did some other crunching for about 11-12 hours before making another
> pgsql call; at which point, I get this error:
>
> FATAL: This connection has been terminated by the administrator.
>
> I've restarted my script on a faster system and expect to get to the same
> point in about 4 hours this time. Hopefully timeout values won't get in
> the way this time?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2007-02-03 20:15:59 | Re: Send Email from Postgressql |
Previous Message | Frank Bax | 2007-02-03 18:28:49 | connection timeout? |