"pobox@xxxxxxxxxxxxx" <pobox@xxxxxxxxxxxxx> writes: > I have a PostgreSQL 8.2.6 on FreeBSD 6.3 (but the described behavior > appears during several earlier minor versions as well) - which powers a > php based web application. What I experience is the message (below) > which appears during the first 5-7 clicks after the database has been > cleanly imported (dropped and imported) - > PGSQL ERROR: FATAL: terminating connection due to administrator command This means that something sent the server process a SIGTERM signal. One way that could happen is if the postmaster gets sent a SIGINT (it will SIGTERM all its children and then quit). However, if you are able to reconnect to the database afterwards, then that's not what's happening because the postmaster must still be there. You need to trawl around for some mechanism within your system that might be SIGTERM'ing server processes. I've heard of systems that do this when a process exceeds some ulimit setting (though I didn't think FreeBSD was one). Also, if you are starting the postmaster from a terminal window rather than a system init script, you should check into the possibility that actions such as closing the terminal window are causing it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
