[QUESTION]: Recovery of tables - Mailing list pgsql-general

From Mark Lawrence
Subject [QUESTION]: Recovery of tables
Date
Msg-id Pine.LNX.4.21.0104251023470.722-100000@null
Whole thread Raw
In response to Question: Recovery of tables  (Mark Lawrence <nomad@null.net>)
Responses Rebuilding database from table files
List pgsql-general
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: borchert@antsatwork.de (Konstantin Borchert)
Date:
Subject: Re: Problem with postgreSQL (number of backends)
Next
From: Ryan Mahoney
Date:
Subject: Re: IBM to buy Informix