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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
