Обсуждение: Backend crash
I am facing some problem while using postgres (version 7.3.1) On trying to execute a psql command from the postges interactive terminal as user 'test' (which exists in the pg database), pgsql seems to be crashing. The postmaster log file contains the following - -------------------------------------------------------------------------------- WARNING: ROLLBACK: no transaction in progress FATAL: Password authentication failed for user "test" LOG: fast shutdown request LOG: shutting down ....... StreamConnection: accept() failed: Connection aborted ------------------------------------------------------------------------------------ Can anyone please tell me why postmaster is shutting down ? What all causes the SIGINT signal to be sent to postmaster that causes rollback of open transactions and disconnection of open connections ? _________________________________________________________________ Get a Citibank Home Loan now. http://go.msnserver.com/IN/49351.asp Build with Citibank Home Loans.
"angshumitra ghosh" <angshumitrag@hotmail.com> writes: > Can anyone please tell me why postmaster is shutting down ? What all > causes the SIGINT signal to be sent to postmaster that causes rollback of > open transactions and disconnection of open connections ? I suspect that you are doing something roughly along the lines of postmaster ... & psql ... ^C When you launch the postmaster from an interactive session, it is still susceptible to being SIGINT'd by your shell unless you take steps to prevent that. When I need to manually launch a postmaster, I usually do this sort of thing: nohup postmaster ...args... </dev/null >logfile 2>&1 & The combination of nohup and making sure that none of stdin, stdout, stderr are still connected to your terminal is enough to disconnect the postmaster from your shell session in the Unixen that I've used. regards, tom lane