Re: [GENERAL] monitoring database activity on solaris

2005-04-10 Thread Bruce Momjian
Tom Lane wrote: > "David Parker" <[EMAIL PROTECTED]> writes: > >> The best bet is to make sure that your postmaster start script > >> invokes the postmaster as > >>postmaster > >> no more. No path (set PATH beforehand instead). No > >> command-line switches (whatever you might want there ca

Re: [GENERAL] monitoring database activity on solaris

2005-04-06 Thread Tom Lane
"David Parker" <[EMAIL PROTECTED]> writes: >> The best bet is to make sure that your postmaster start script >> invokes the postmaster as >> postmaster >> no more. No path (set PATH beforehand instead). No >> command-line switches (whatever you might want there can be >> put into postgres

Re: [GENERAL] monitoring database activity on solaris

2005-04-06 Thread David Parker
OK, thanks. We're using pg_ctl to start it at the moment, but we can obviously change that. - DAP >-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 06, 2005 6:18 PM >To: David Parker >Cc: postgres general >Subject: Re: [GENER

Re: [GENERAL] monitoring database activity on solaris

2005-04-06 Thread Tom Lane
"David Parker" <[EMAIL PROTECTED]> writes: > According to the 7.4 doc section on monitoring database activity, one > should be able to see the current activity happening in a given postgres > process. It mentions that on Solaris (which we are running on) you need > to use /usr/ucb/ps, and it also s

[GENERAL] monitoring database activity on solaris

2005-04-06 Thread David Parker
According to the 7.4 doc section on monitoring database activity, one should be able to see the current activity happening in a given postgres process. It mentions that on Solaris (which we are running on) you need to use /usr/ucb/ps, and it also says   " your original invocation of the po