Re: Can postgresql accept mutliple connections in the same

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Dru <andru(at)treshna(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Can postgresql accept mutliple connections in the same
Date: 2004-11-19 04:27:41
Message-ID: 419D763D.7000800@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


>>
> I've spent ages going though logs and turning debugging to max. There
> is no
> error message returned at all. The connection handle is returned as
> NULL.
> This is in the php functions though so their pg_last_error() function may
> not be catching all error messages but it seems it should pass on every
> error. It is just really weird. The weirder thing i find is the fact
> it is
> doing this a lot more often while backups are running than when they
> arn't
> running. 80% of the time when it is reported by users a backup is
> running
> at the same time.

Could it be that your load is getting driven to high by lack of IO bandwidth
during a backup and your PHP connection is timing out?

J

>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 285 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2004-11-19 04:29:26 Re: Can postgresql accept mutliple connections in
Previous Message Dru 2004-11-19 04:23:10 Re: Can postgresql accept mutliple connections in the same