| From: | Alan J Batsford <AJBatsford(at)uss(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_dumpall and version confusion |
| Date: | 2007-03-12 16:50:54 |
| Message-ID: | OFC6164387.BAED6195-ON8525729C.00591F35-8525729C.00620AA7@notes.uss.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I inherited an existing system with no documents on how it was originally
configuerd, so I'll provide as much as I can. OS is CentOS 4.3 Linux
Distribution.
When I search my system for anything postgres I find a boatload of 8.0.4
source, and a boatload of 7.4.8 documentation.
postgres --version yields 8.1.4 (thats no typo)
psql --version yields 7.4.8
pg_dump --version yields 7.4.8
pg_dumpall --version yields 7.4.8
When doing 'which' on all of the above binaries I get /usr/bin/____ for all
4.
The original problem was recieving 'pg_dumpall: query failed: ERROR:
column "datpath" does not exist' error when trying to run pg_dumpall. I
learned that this is expected error if pg_dumpall is too new for the
database, but it claims to be 7.4.8. I hate to ask a terribly vague
question but how do I find out what version I'm running when postgres and
psql don't agree? There's no trace of 8.1.4 files on the system so I'm
without a lead as to how I have a binary for it.
Thanks for any assistance you can provide.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-03-12 17:16:30 | Re: Tracking disk writes? (again) |
| Previous Message | Harald Armin Massa | 2007-03-12 16:46:07 | Re: Tracking disk writes? (again) |