Re: pg_dump, restore and versioning - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_dump, restore and versioning
Date
Msg-id 5127.1026231627@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump, restore and versioning  (sol <sol@autonomon.net>)
List pgsql-novice
sol <sol@autonomon.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

pgsql-novice by date:

Previous
From: sol
Date:
Subject: pg_dump, restore and versioning
Next
From: Randy Neumann
Date:
Subject: Server side functions