pg_xsetlog

Tom,

I have tried this on a copy of my database system.
When the postmaster boots up I get "this database has no tables" in webmin.

I am unable to compile pg_control because my gcc is too recent (RedHat 7.1) so unable to try and get the table data out.

Can you think of any other tool i might try to get the data tables back? The database structure is real simple I just need the table data.

Cheers

Tony

--
tony(at)animaproductions(dot)com

RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html
>From pgsql-general-owner(at)postgresql(dot)org Wed Jan 9 15:45:36 2002
Received: from sss.pgh.pa.us ([192.204.191.242])
by postgresql.org (8.11.3/8.11.4) with ESMTP id g09KciB95684
for <pgsql-general(at)postgresql(dot)org>; Wed, 9 Jan 2002 15:38:44 -0500 (EST)
(envelope-from tgl(at)sss(dot)pgh(dot)pa(dot)us)
Received: from sss2.sss.pgh.pa.us (tgl(at)localhost [127.0.0.1])
by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g09Kccg14893;
Wed, 9 Jan 2002 15:38:38 -0500 (EST)
To: "Ian Harding" <ianh(at)tpchd(dot)org>
cc: pgsql-general(at)postgresql(dot)org
Subject: Re: A Nit RE overlaps
In-reply-to: <sc3c0f5f(dot)062(at)mail(dot)tpchd(dot)org>
References: <sc3c0f5f(dot)062(at)mail(dot)tpchd(dot)org>
Comments: In-reply-to "Ian Harding" <ianh(at)tpchd(dot)org>
message dated "Wed, 09 Jan 2002 09:35:46 -0800"
Date: Wed, 09 Jan 2002 15:38:37 -0500
Message-ID: <14890(dot)1010608717(at)sss(dot)pgh(dot)pa(dot)us>
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
X-Archive-Number: 200201/250
X-Sequence-Number: 19209

"Ian Harding" <ianh(at)tpchd(dot)org> writes:
> As it is, it returns false. To me if the first interval ends at a
> point in time and the other begins at the same point, they overlap.
> This is splitting hairs with a timestamp, but not with a date. Am I
> the only person who feels this way?

SQL92 says that abutting time intervals don't overlap, if I'm reading
the spec correctly.

For dates, it would seem to me that you want to add 24 hours to the end
of one interval in order to get the behavior you're describing.

> In my twisted little world, a null date would be OK too and would
> indicate the beginning or end of time.

I agree, that's pretty bogus. Why not use infinity and -infinity?
(okay, they don't exist as DATE values, but they do exist as
timestamp values).

regards, tom lane