BUG #8107: How to downgrade database from 9.2.3 to 8.4 ?

On Tue, Apr 23, 2013 at 04:18:17PM +0000, roberto.menoncin@netspa.it wrote:

The following bug has been logged on the website:

Bug reference: 8107
Logged by: Roberto
Email address: roberto.menoncin@netspa.it
PostgreSQL version: 9.2.3
Operating system: CentOS 5.6 (Final)
Description:

Hy.

This is not a bug but a simple request !

Is there a way to downgrade a database from version 9.2.3 to 8.4.x ?

I tried a pg_dump from 9.2.3 and a pg_restore from 9.2.3 TO a 8.4.7 server.

but I receive several errors.

Does it exist another way ?

I recommend doing a schema dump, adjusting the output file until it
generates no errors, then restore that, and then restore the data.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs