From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: serverlog rotation/functions |
Date: | 2004-07-16 18:32:45 |
Message-ID: | 200407161832.i6GIWj406590@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Andreas Pflug wrote:
> Bruce Momjian wrote:
>
> >
> > This seems quite involved. Can we get the basic functionality I
> > described first?
>
> On the way.
>
> > Also I am not sure how all this information is going
> > to be passed from the logging process to the backend requesting the
> > information, and it seems overly complicated.
>
> There's *no* information passing from the logging process, with the
> single exception of the latest logfile timestamp (if allowed). I'd
> rather like to have that information from the logger, to be safe in case
> the system time was manipulated and the last logfile is not the current one.
> The rest is just a reworked version of pg_dir_ls, with internal
> knowledge of how the timestamp is formatted.
Oh, so you are hardcoding the logfile name so you can interpret the
timestamp from that? It seems cleaner to allow the admin to specify
whatever log pattern the want.
However, you idea of expiring the log files based on timestamp values is
pretty powerful.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-07-16 18:38:41 | Re: serverlog rotation/functions |
Previous Message | Bruce Momjian | 2004-07-16 18:30:13 | Re: Point in Time Recovery |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-07-16 18:52:52 | Re: pg_autovacuum integration attempt #2 |
Previous Message | Magnus Hagander | 2004-07-16 16:34:50 | Re: initdb authentication |