Hi Tom, I decided to test your theory that I had an old version of Postgres on my system when I installed version 8.1.3. By the way, the Linux install we a fresh one to start with. So this morning I first did a search on my system for all pg_dump files, and wrote the locations down. I them removed the entire file structure of postgresql-8.1.3 from my system. I then did a system search for pg_dump again to confirm that all files by the name of pg_dump were removed, which they were. I then re-installed PostgreSQL version 8.1.3. After completing, I did a system search for the pg_dump again and found them in the locations I expected. I them recreated my database and tested the pg_dump. I got the same error. Version mismatch with the same version numbers as before. I think that an old version of pg_dump is bundled up with the install of version 8.1.3. How can I get the correct version of pg_dump? Or any of the other files that are not the correct version? Brian >>> Tom Lane <tgl@xxxxxxxxxxxxx> 3/22/2006 2:38 PM >>> "Brian Kitzberger" <KITZBERGERB@xxxxxxxxxxxxxxxxxxxxxxxx> writes: > When I did I get "pg_dump: server version: 8.1.3; pg_dump version: > 7.4.8" Apparently you already had a 7.4.8 postgres installed on your machine. Most versions of Linux do have PG in them. You probably want to remove the 7.4.8 files to avoid confusion like this. > The dump also failed with this error: > Error message from server: ERROR: column "datpath" does not exist That's because that version of pg_dump is too old to understand the 8.1 server's catalog layout. There's a good reason why it refused to dump from a newer server by default; it knows it probably ain't gonna work. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
