Re: pg_dump, restore and versioning

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sol <sol(at)autonomon(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dump, restore and versioning
Date: 2002-07-09 16:20:27
Message-ID: 5127.1026231627@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

sol <sol(at)autonomon(dot)net> writes:
> Are there any known issues with restoring dumpfiles from later versions
> of Postgresql into earlier versions?

As a general rule, that won't work. It certainly won't work to just do
it blindly without careful analysis of the SQL commands contained in the
dump. Dumps from later versions are likely to use features that didn't
exist in the earlier ones.

> is there any known way around this problem? Or is it time to upgrade?

Time to upgrade.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2002-07-09 16:48:38 Re: update problem?
Previous Message Tom Lane 2002-07-09 13:59:19 Re: Network Connection Problem