From: | Mark Lawrence <nomad(at)null(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Rebuilding database from table files |
Date: | 2001-04-30 05:15:48 |
Message-ID: | Pine.LNX.4.21.0104301443250.14357-100000@null |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)null(dot)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(at)null(dot)net
> v
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2001-04-30 05:29:08 | Postgresql CVSup server down? |
Previous Message | Tom Lane | 2001-04-30 05:11:21 | Re: Re: SQL Where Like - Range it?! |