It is unreasonable to expect 8.3 programs to be able to understand everything that 8.4 programs might write. What format is your dump in? Plain text (--format=p) might work. Or try dumping the 8.4 database with the 8.3 version of pg_dump, or maybe use the 8.4 pg_restore against the 8.3 database. -- Ian. On Tue, Feb 23, 2010 at 9:17 AM, Net Tree Inc. <nettreeinc@xxxxxxxxx> wrote: > Why am I keep getting error with version issues.... I am trying to restore a > backup file from a 8.4 postgresql server to a 8.3 postgresql server. > [postgres@localhost ~]$ pg_restore -C -d postgres -i isamdb.backup > pg_restore.bin: [archiver] unsupported version (1.11) in file header > > On Tue, Feb 23, 2010 at 1:02 PM, Kevin Grittner > <Kevin.Grittner@xxxxxxxxxxxx> wrote: >> >> "Net Tree Inc." wrote: >> >> > When I do restore it shown alot errors related with constraints. >> > How can I dump and to restore from old to new without dealing with >> > constraint and just forces data dump to where it suppose to belong? >> >> What version are you dumping from and to? Exactly what errors are >> you getting? (Copy and paste samples, please.) >> >> You might want to review this page: >> >> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems >> >> -Kevin >> >> > > > > -- > --------------------------------------- > Steven Huang > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
