From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Yulius Tjahjadi <yulius(at)xfire(dot)com> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: pg_pconnect causing |
Date: | 2005-03-16 05:01:58 |
Message-ID: | 4237BDC6.9070107@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Yulius Tjahjadi wrote:
>Hi,
>
>When I use pg_pconnect() and the apache process exits for reaping,
>I get these errors. I'm using Postgres 8.0.1 on Ferdora Core 2.
>
>LOG: unexpected EOF on client connection
>LOG: unexpected EOF on client connection
>LOG: unexpected EOF on client connection
>
>I think I know what's going on. Since there is a persistent
>connection, when the apache process dies postgres thinks
>the connection was abruptly disconnected w/o a proper
>close function. It's not causing me any problems, but I
>would like to remove any bad messages from the log file.
>I was wondering if this is just a bug that needs to be
>fixed.
>
>
You are correct in your assumption but it is not a bug.
PostgreSQL is doing exactly what it should.
The bug (if it was considered to be a bug) would be in the communication
between PHP and Apache and PHP not closing the connection before Apache
drops its process.
Sincerely,
Joshua D. Drake
>Thanks.
>
>yulius
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
--
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 | Yulius Tjahjadi | 2005-03-16 19:07:29 | Re: pg_pconnect causing |
Previous Message | Yulius Tjahjadi | 2005-03-16 02:27:23 | pg_pconnect causing |