August 6th, 2012, 04:02 AM
Pg_dump not working on Solaris
since Google wasn't of much help, I'll try my luck here.
I've installed postgres 9.1 on one of my company's Solaris 10 sparc machines. I installed binaries from postgres home page (I LOVE how they offer Solaris binaries, very classy move).
Everything is working well except the backup. When I try to use pg_dump, I get an error about version mismatch.
When I add "-i" option, I get this:
What is the deal with pg_dump being old? Is that an error in packaging, or is this program not maintained on Solaris?
Is there an alternative way to create database backups from command line?
Thank you and best regards,
August 6th, 2012, 04:23 AM
I'd say you have two different versions installed with the old pg_dump binaries are first in the search path.
Comments on this post
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions:
August 6th, 2012, 07:04 AM
Originally Posted by shammat
A simple "which pg_dump" revealed another installed version.
Funny thing is, I did "cd" to my install directory, but forgot to add "./" before "pg_dump".
In my defense I can say I am really tired this Monday morning
Thanks a lot.