Skip site navigation (1) Skip section navigation (2)

Re: Mergin a old dir with current system

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: Jyry Kuukkanen <jyry(at)neutech(dot)fi>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Mergin a old dir with current system
Date: 2000-06-29 15:37:03
Message-ID: Pine.GSO.4.02A.10006291734110.8364-100000@Rama.DoCS.UU.SE (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Wed, 28 Jun 2000, Jyry Kuukkanen wrote:

> I've got a dir containing a valuable 6.5x db with one table, but I
> foolishly upgraded to 7.0 without pg_dumpall:in first.
> I tried going back to 6.53, vreated the db, then copied the backup to the
> place, but psql can't see the old table.

There's no way to "plug-in" tables files like that. You are more or less
out of luck. (The reason is that the table file only contains half the
truth. The other half is in the pg_log file that used to belong to it, but
it seems you don't have that anymore.)

Peter Eisentraut                  Sernanders väg 10:115
peter_e(at)gmx(dot)net                   75262 Uppsala            Sweden

In response to

pgsql-admin by date

Next:From: Irfan QaiserDate: 2000-06-30 06:55:27
Subject: problem in pg_hba.conf file
Previous:From: Anthony E. GreeneDate: 2000-06-29 13:29:26
Subject: Re: Exporting database

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group