yeah that's what I means to do. How do I use 8.4 pg_restore? the DB server I am trying to restore is using 8.3. Do you mean do pg_restore on the same machine that I did pg_dump?? I am thinking of doing that too, but I am not sure how to do the command.
Is this correct? pg_restore -h (my target machine IP) -U postgres -d (target db) mydb.dump Steven On Tue, Feb 23, 2010 at 10:31 PM, Richard Huxton <d...@archonet.com> wrote: > On 23/02/10 09:17, Net Tree Inc. 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. >> > > Well, an 8.4 dump isn't always going to be compatible with an 8.3 server, > is it? If there weren't differences, the version number wouldn't have > changed. > > > [postg...@localhost ~]$ pg_restore -C -d postgres -i isamdb.backup >> pg_restore.bin: [archiver] unsupported version (1.11) in file header >> > > Try using the 8.4 pg_restore (but keep the "-i" to tell it to ignore the > version checks). You may still see errors, but there is a good chance it > will work. > > You're also restoring into the "postgres" database here - is that what you > meant to do? > > -- > Richard Huxton > Archonet Ltd > -- --------------------------------------- Steven Huang
