Re: pd_dump server mismatch error

Alejandro Brust <alejandrob@xxxxxxxxxxxxxxxxx> · Wed, 25 Sep 2013 16:47:00 -0300



    Hello, first excuse my English

    U cant do a backup whit a Client minor version than the server

    U must have same version to do the backup, so U need upgrade your
    client (pg_dump 8.4.13) to at least 9.2.4

    
    See U

    
    El 25/09/2013 15:55, Thara Vadakkeveedu
      escribió:

    
        Hi

        I wanted to take a backup of my database. 

        
        pg_dump throws a server mismatch version error

        
        # cd backups

        # su - postgres

        -bash-4.1$ pg_dump mydb > mydbfile

        pg_dump: server version: 9.2.4; pg_dump version: 8.4.13

        pg_dump: aborting because of server version mismatch

        
        This is a fresh install of postgresql on a red hat linux server
        that did not have any previous database installed on it . I
        installed postgresql 9.2 from an rpm
        (pgdg-redhat92-9.2-7.noarch.rpm ) using yum install.

        
        Why am I seeing this error?

        How can I take a backup of my database? There are two tables
        that have 20,000+ rows in it, that I want to backup  and restore
        when needed.

        
        thanks

        thara.