--- On Mon, 15/6/09, Eoghan Murray <eoghanomurray@xxxxxxxxx> wrote: > From: Eoghan Murray <eoghanomurray@xxxxxxxxx> > Subject: DB Migration 8.4 -> 8.3 > To: pgsql-general@xxxxxxxxxxxxxx > Date: Monday, 15 June, 2009, 10:19 PM > 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 > Try the 8.4 pg_restore against the 8.3 server -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general