Thread: Desperately seeking data...

Desperately seeking data...

From
Ulf Thorsen
Date:
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

Re: Desperately seeking data...

From
"Ross J. Reedstrom"
Date:
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