Re: pd_dump server mismatch error

Hi
I did not install the client separately. I assumed i would get the right client as part of the 9.2 Yum install...

I see psql is an older version too.

# su - postgres
-bash-4.1$ psql -d postgres
psql (8.4.13, server 9.2.4)
WARNING: psql version 8.4, server version 9.2.
         Some psql features might not work.

When I installed postgresql-9.2 using Yum (yum install postgresql92 postgresql92-server)

The following 3 packages were installed:

 postgresql92             x86_64      9.2.4-1PGDG.rhel6       pgdg92      970 k
 postgresql92-server      x86_64      9.2.4-1PGDG.rhel6       pgdg92      3.8 M
 postgresql92-libs        x86_64      9.2.4-1PGDG.rhel6       pgdg92      185 k
I assumed this took care of installing the right client. I run the client from the same machine where the server is installed.

Is there a  separate package I should have installed for the 9.2 client ?
Thanks,
TG

________________________________
From: Alejandro Brust <alejandrob(at)pasteleros(dot)org(dot)ar>
To: pgsql-admin(at)postgresql(dot)org
Sent: Wednesday, September 25, 2013 3:47 PM
Subject: Re: [ADMIN] pd_dump server mismatch error

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.
>
>