Rebuilding database from table files - Mailing list pgsql-general

From Mark Lawrence
Subject Rebuilding database from table files
Date
Msg-id Pine.LNX.4.21.0104301443250.14357-100000@null
Whole thread Raw
In response to [QUESTION]: Recovery of tables  (Mark Lawrence <nomad@null.net>)
Responses Re: Rebuilding database from table files
List pgsql-general
Help!

Is it possible to rebuild a database when you only have the files that
contain the table data?

There was no response when I posted this before. Does this mean that there
is no solution?

Mark.
--
 ,-_|\
/  .  \   Mark Lawrence
\_,-._/   nomad@null.net
     v


On Wed, 25 Apr 2001, Mark Lawrence wrote:

> Hi,
>
> I have a problem:
>
> Due to a mismanaged upgrade I'm in the situation of having a
> $PGDATA/base/template1 directory without any of the files from the $PGDATA
> directory itself.
>
> Using the unix 'strings' command I can see the data inside the actual
> template1 database table files, however I can't get to the data using
> postgresql.
>
> I have tried a fresh install, recreating the tables, copying the old
> template1 directory over the new but all queries return empty (no) rows.
> Any ideas on how I can use the original table files to regain my data?
>
> Thanks in advance,
>
> Mark.
> --
>  ,-_|\
> /  .  \   Mark Lawrence
> \_,-._/   nomad@null.net
>      v
>
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: SQL Where Like - Range it?!
Next
From: Alfred Perlstein
Date:
Subject: Postgresql CVSup server down?