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. +