surabhi.ahuja wrote:
The exact message i saw is this:
LOG: received fast shutdown request LOG: aborting any active
transactions FATAL: terminating connection due to administrator
command
so does this mean that someone is trying to stop postmaster by
sending it a kill signal?
Someone or something. It can be Linux's out-of-memory facility picking
processes to kill. Google "oom killer" for discussion. It would need to
be sent from the postgres user or root though (or a process running as
them).
i also have these questions:
1. many times i have seen two instances of postmaster running. how
does that happen and how to prevent it from happening?
Shouldn't (unless you have two installations of course). You shouldn't
have to do anything to prevent it from happening. Try and capture
details of the processes with "ps aux" and "pstree" if you can.
2. into the logfile (which i specify at the time of starting
postmaster), i want to add timestamps, for each log/warning etc. How
do i do that?
See the manuals for details - run-time environment / error reporting and
logging.
http://www.postgresql.org/docs/
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
