Re: serverlog function

From: "Bort, Paul" <pbort(at)tmwsystems(dot)com>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: serverlog function
Date: 2004-06-07 15:54:36
Message-ID: 735D404BD9E7EB44B9CDFC27FC88809B01C4DA20@mail2.tmwsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas wrote:
>
> AFAICS, we have some alternatives:
> - try to grab the currently created files/syslog/eventlog.
> Seems hard to
> do, because we'd depend on additional external tools.
> - redirect stderr to a postgresql.conf known file.
> Disadvantage: breaks
> piping.
> - maintain a sharedMem for the latest messages. Disadvantage: limited
> space, no access to older entries after postmaster restart.
> - additional log_destination "file". Disadvantage: Yet Another File
> besides the redirected stderr, but this seems a minor problem.
>

Another alternative would be to add code to the admin tool to get the log
via scp or a similar method. IMHO PostgreSQL is doing the right thing here
by using the OS logging, and breaking that isn't a good idea when there are
other ways to solve the problem.

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2004-06-07 16:01:19 Re: serverlog function (log_destination file)
Previous Message Tom Lane 2004-06-07 15:50:40 Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?