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.Babakov@sochi.net.ru
http://sochi.net.ru/~mike