Обсуждение: Re: serverlog function (log_destination file)

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 07 June 2004 15:32
> To: Dave Page
> Cc: Andreas Pflug; PostgreSQL Development
> Subject: Re: [HACKERS] serverlog function (log_destination file)
>
>
> If I were trying to solve Andreas' problem, I'd pipe stderr
> to some program that stores recent log output in a file that
> I know the location of and can read from the hypothetical
> log-grabber function.  Actually I don't see that there's any
> need to involve Postgres itself in this issue at all ---
> seems like the only agreement needed is between the GUI and
> the postmaster launching script about where the log file is.

Thanks Tom. I wonder if we (the pgAdmin team) finally need to bite the
proverbial bullet and write a helper daemon that can allow access to
logs as well as config files and pg_ctl etc. as an optional extra
component.

Regards, Dave.

"Dave Page" <dpage@vale-housing.co.uk> writes:
> Thanks Tom. I wonder if we (the pgAdmin team) finally need to bite the
> proverbial bullet and write a helper daemon that can allow access to
> logs as well as config files and pg_ctl etc. as an optional extra
> component.

Red Hat's RHDB group already did a fair amount of work on such a tool:
see Control Center available from http://sources.redhat.com/rhdb/

IIRC it's all in Java and thus at least theoretically portable to
Windows.

At the moment Red Hat is devoting no resources to it (and so I think
it's stuck in the 7.3 time frame) but I'd be very happy to see someone
else pick it up and work on it.
        regards, tom lane