Re: users work now with PostgreSQL - Mailing list pgsql-admin

From Michael B. Babakov
Subject Re: users work now with PostgreSQL
Date
Msg-id XFMail.001212222543.M.Babakov@sochi.net.ru
Whole thread Raw
In response to Re: users work now with PostgreSQL  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Responses Re: users work now with PostgreSQL
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: users work now with PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] postmaster does not start up