From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: logfile subprocess and Fancy File Functions |
Date: | 2004-07-20 16:46:33 |
Message-ID: | 200407201646.i6KGkXH24532@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > Peter Eisentraut wrote:
> > > Andreas Pflug wrote:
> > > > How should the prefix be named? pgsql_ ?
> > >
> > > Make the file names configurable.
> >
> > He has code to interpret the file names as timestamps that can be
> > used in queries. If we allowed full user control over the file name,
> > he couldn't do that.
>
> I can't see this working. As you know, there are constantly people who
> want to install and configure PostgreSQL in the weirdest ways. If we
> tell everybody, you log files must be named like this, it will start
> all over again.
>
> Maybe it would be better if the time stamps of the files are used as
> time stamps in queries.
I guess you could use the creation time of the inode as the start time,
yes, and then they could call the file names whatever they want. We
could even add the modification time as the end time.
--
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 | Simon Riggs | 2004-07-20 17:27:58 | Re: [HACKERS] Point in Time Recovery |
Previous Message | Peter Eisentraut | 2004-07-20 16:42:37 | Re: logfile subprocess and Fancy File Functions |