#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    3
    Rep Power
    0

    Pg_dump not working on Solaris


    Hi guys,

    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.

    pg_dump: server version: 9.1.3; pg_dump version: 8.1.19
    pg_dump: aborting because of version mismatch (Use the -i option to proceed anyway.)
    pg_dump: *** aborted because of error
    When I add "-i" option, I get this:

    pg_dump: server version: 9.1.3; pg_dump version: 8.1.19
    pg_dump: proceeding despite version mismatch
    pg_dump: reading schemas
    pg_dump: reading user-defined functions
    pg_dump: reading user-defined types
    pg_dump: reading procedural languages
    pg_dump: reading user-defined aggregate functions
    pg_dump: reading user-defined operators
    pg_dump: reading user-defined operator classes
    pg_dump: reading user-defined conversions
    pg_dump: reading user-defined tables
    pg_dump: SQL command failed
    pg_dump: Error message from server: ERROR: column "reltriggers" does not exist at character 153
    pg_dump: The command was: SELECT c.tableoid, c.oid, relname, relacl, relkind, relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = relowner) as rolname, relchecks, reltriggers, relhasindex, relhasrules, relhasoids, d.refobjid as owning_tab, d.refobjsubid as owning_col, (SELECT spcname FROM pg_tablespace t WHERE t.oid = c.reltablespace) AS reltablespace from pg_class c left join pg_depend d on (c.relkind = 'S' and d.classid = c.tableoid and d.objid = c.oid and d.objsubid = 0 and d.refclassid = c.tableoid and d.deptype = 'i') where relkind in ('r', 'S', 'v', 'c') order by c.oid
    pg_dump: *** aborted because of error
    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,
    Loreia
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    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

    • Loreia agrees
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    3
    Rep Power
    0
    Originally Posted by shammat
    I'd say you have two different versions installed with the old pg_dump binaries are first in the search path.
    BINGO !!
    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.
    BR
    Loreia

IMN logo majestic logo threadwatch logo seochat tools logo