Re: Desperately seeking data...

Ulf -
Did you copy the pg_log file? Despite it's name, it's not a just a log:
it's used to keep track of the commit state of transactions. Without
it, the system will assume than none of your transactions are commited,
so will not show you the tuples in those transactions.

Ross

On Fri, Jan 12, 2001 at 11:09:14AM +0100, Ulf Thorsen wrote:
> After some disc problems we had to copy our database directory to
> another computer and installed the same version of postgresql (6.5.3-6).
>
> The dataTable file, Key file, and the datamodel seems all right when
> manually inspecting them in an editor.
>
> When running psql, we can access the database and add new elements, but
> we can't access the data previously stored. We tried to inspect the
> files under .../psql/base and new elements are stored at the end of
> existing files or at empty spaces in them.
>
> Any ideas???
>
> -Ulf
> --
> Ulf Thorsen, Senior Software Engineer Phone: +47 66 85 51 21
> Kongsberg Scanners AS Fax : +47 66 85 51 01
> Billingstadsletta 14, PB 132, Cell : +47 97 54 45 46
> N-1376 Billingstad, Norway http://www.kscanners.com/~uth