On 12-Dec-00 Ross J. Reedstrom wrote:
> It's encoded in the process environment, so the 'ps' command will
> give you what you want:
Yes! For version < 7.0.2 it's right. After 7.0.2 postgresql don't write user
in 'ps' command.
I'm use FreeBSD 4.2.
I'm make:
1. In src/include/config.h:
#define ELOG_TIMESTAMPS
...
gmake
2. In data/pg_options:
verbose=1
hostlookup
3. Running postgresql as:
#!/usr/local/bin/bash
export LC_COLLATE=ru_SU.KOI8-R
export LC_CTYPE=ru_SU.KOI8-R
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o \
"-o -F -B 256 -i" start \
2>&1 | /home/mike/program/perl/pg_user/filter.pl > /usr/local/pgsql/errlog &
4. /home/mike/program/perl/pg_user/filter.pl:
#!/usr/bin/perl
$| = 1;
while(<STDIN>) {
print $_ if /started/ || / exit/;
};
'grep' command buffered output (?) and posting filtered message more laters.
Some more ideas?
P.S. Sorry, for my bad english. :(
Good luck,
Michael
---
e-mail: M.Babakov@sochi.net.ru
http://sochi.net.ru/~mike
