| 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: | Whole Thread | Raw Message | 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 |
| 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 |