From: | Mark Lawrence <nomad(at)null(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Question: Recovery of tables |
Date: | 2001-04-19 11:54:26 |
Message-ID: | Pine.LNX.4.21.0104192112090.568-100000@null |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a problem:
I started out with a 6.3 version system, and attempted an upgrade to
Debian's unstable release (maybe version 7.?), which unfortunately
appeared to have failed the dump/import to the new database format.
Realizing this was probably not what I wanted in the first place I tried
to go back to what I had originally but of course this is not straight
forward.
Unfortunately all I had backed up were files from the data/base/template1
directory downwards which means I have the raw table data but none of the
important files/information from the data/ directory. I can do a fresh
install, recreate the tables, copy 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.
p.s. Please respond to this email address.
--
,-_|\
/ . \ Mark Lawrence
\_,-._/ nomad(at)null(dot)net
v
From | Date | Subject | |
---|---|---|---|
Next Message | Konstantinos Agouros | 2001-04-19 12:09:00 | Re: How to read a query plan? |
Previous Message | Pruner Jan | 2001-04-19 11:16:56 | confirmation of insert/update |