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

On Tue, Apr 23, 2013 at 04:18:17PM +0000, roberto(dot)menoncin(at)netspa(dot)it wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8107
> Logged by: Roberto
> Email address: roberto(dot)menoncin(at)netspa(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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