Re: logfile subprocess and Fancy File Functions - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: logfile subprocess and Fancy File Functions
Date
Msg-id 200407201646.i6KGkXH24532@candle.pha.pa.us
Whole thread Raw
In response to Re: logfile subprocess and Fancy File Functions  (Peter Eisentraut <peter_e@gmx.net>)
List 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: logfile subprocess and Fancy File Functions
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Point in Time Recovery