Re: users work now with PostgreSQL

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(dot)Babakov(at)sochi(dot)net(dot)ru
http://sochi.net.ru/~mike