postgresql shutdown problem

[Anon]

For a project i'm using php in combination with postgresql, which works very well.

But there is one (sometimes a whole list)warning when i shutdown the postgresql database:

DEBUG: database system is in production state
Fast Shutdown request at Thu Jan 24 17:36:00 2002
Aborting any active transaction...
FATAL 1: This connection has been terminated by the administrator.
DEBUG: shutting down

DEBUG: database system is shut down

I use this php code in every script:

$db = pg_pconnect ("host=10.0.0.2 port=5432 dbname=texel user=username password=password");
if (!$db)
{
fatal_error("no connection.");

}

I do not use pg_close(), could that be the cause of the "FATAL 1: .." error?

Thanks,
Twan

[bfranco]

The problem is that you're using persistant conections (pg_pconnect() function).

Each time you request a page which uses this function, it estableshes a new connection to the database and it leaves it open forever, so next time a DB connection is needed, the existent connection can be used.

When you want to shutdown postgresql, it tells you that there are active connections. What I do, is to send a SIGHUP to httpd before shutting down postgresql, like this

killall -HUP httpd

this closes every persistant connection because apache kills all its child proceses, re-reads the configuration and creates new childs, which are not connected to the DB.

About pg_close(), the php site says:
"pg_close() will not close persistent links generated by pg_pconnect()", so it won't work.

[Anon]

Thanks for the pointer, now i understand how it all works and why the warnings appear.