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
