Re: Can postgresql accept mutliple connections in the same - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Can postgresql accept mutliple connections in the same
Date
Msg-id 419D763D.7000800@commandprompt.com
Whole thread Raw
In response to Re: Can postgresql accept mutliple connections in the same  (Dru <andru@treshna.com>)
List 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@postgresql.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@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


Attachment

pgsql-hackers by date:

Previous
From: Dru
Date:
Subject: Re: Can postgresql accept mutliple connections in the same
Next
From: Neil Conway
Date:
Subject: Re: Can postgresql accept mutliple connections in