pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBackend crash
2+ messages / 2 participants
[nested] [flat]
* Backend crash
@ 2004-05-25 11:34 angshumitra ghosh <angshumitrag@hotmail.com>
2004-05-31 04:30 ` Re: Backend crash Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: angshumitra ghosh @ 2004-05-25 11:34 UTC (permalink / raw)
To: pgsql-admin; pgsql-general@postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Backend crash
2004-05-25 11:34 Backend crash angshumitra ghosh <angshumitrag@hotmail.com>
@ 2004-05-31 04:30 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-05-31 04:30 UTC (permalink / raw)
To: angshumitra ghosh <angshumitrag@hotmail.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-05-31 04:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-25 11:34 Backend crash angshumitra ghosh <angshumitrag@hotmail.com>
2004-05-31 04:30 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox