Re: logfile subprocess and Fancy File Functions

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

In response to

Browse pgsql-patches by date

  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