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