Re: Restore from 7.3 to 7.2

From: Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org>
To: chris(dot)gamble(at)CPBINC(dot)com
Subject: Re: Restore from 7.3 to 7.2
Date: 2003-02-13 20:04:14
Message-ID: 3E4BFA3E.80109@bacbuc.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

chris(dot)gamble(at)CPBINC(dot)com wrote:
> I have a 7.3 postgres database that I need to create a backup from, and
> restore onto a 7.2 database. Is this possible and if so where can I find
> references on doing so?

I stumbled on this one recently. The only way I found was to do a *text*
dump (pg_dump -F p) and edit the dump : you have to delete all references
to schemas and all references to column names in the "copy" commands
restoring data.

Not a pretty sight ... :-((.

Hope this helps,

Emmanuel Charpentier

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message P G 2003-02-13 20:16:03 What other parameters to consider when increasing max connections?
Previous Message Dennis Gearon 2003-02-13 20:03:10 using serial values