Forum OpenACS Q&A: Response to PostgreSQL dying

Collapse
Posted by Roberto Mello on
Sometimes it also puts this in the logs:

[10/Jul/2000:18:29:27][5675.4101][-conn0-] Notice: starting: waiting for connections
[10/Jul/2000:18:29:37][5675.4101][-conn0-] Notice: Ns_PgExec: Trying to reopen database connection
[10/Jul/2000:18:29:37][5675.4101][-conn0-] Notice: Opening exchange on localhost
[10/Jul/2000:18:29:37][5675.4101][-conn0-] Error: Ns_PgOpenDb(postgres):  Could not connect to localhost::exchange:  The Data Base System is starting up

[10/Jul/2000:18:29:37][5675.4101][-conn0-] Error: nsd.db: error(localhost::exchange, pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
): update users
set last_visit = sysdate()
where user_id = 3