DB Migration 8.4 -> 8.3

From: Eoghan Murray <eoghanomurray(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DB Migration 8.4 -> 8.3
Date: 2009-06-15 21:19:37
Message-ID: fda02c47-38a3-4745-bd68-43fd3b6ae1e5@p6g2000pre.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I unintentionally installed 8.4beta2 on a server (using yum), while I
run 8.3.7 on my dev machine.
The 8.3 version of pg_dump does not work with the server, even with
the -i option:
8.3: pg_dump: Error message from server: ERROR: column
"reltriggers" does not exist
the 8.4 pg_dump works okay, but then the 8.3 version of pg_restore is
not able to restore the resultant databases:
8.3: pg_restore: [archiver] input file does not appear to be a
valid archive

How can I migrate a database from 8.4 to 8.3?
I can't see any versioning options in pg_dump:
http://www.postgresql.org/docs/8.4/static/app-pgdump.html

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2009-06-15 21:54:48 Re: DB Migration 8.4 -> 8.3
Previous Message David Fetter 2009-06-15 21:02:46 Re: Custom Fields Database Architecture