"Brian Kitzberger" <KITZBERGERB@mail.co.stanislaus.ca.us> 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