Re: pd_dump server mismatch error

[Thara Vadakkeveedu <tharagv@xxxxxxxxx>]

Hi,
When you say preinstalled with the system, you mean preinstalled with RedHat Linux?

I seem to have the right version ... I had to use the full path to identify the version.

-bash-4.1$ /usr/pgsql-9.2/bin/pg_dump --version
pg_dump (PostgreSQL) 9.2.4

How can I find the package name for the older version? 

Thanks!

Thara.

---

From: Craig James <cjames@xxxxxxxxxxxxxx>
To: Thara Vadakkeveedu <tharagv@xxxxxxxxx>
Sent: Wednesday, September 25, 2013 5:32 PM
Subject: Re: pd_dump server mismatch error

On Wed, Sep 25, 2013 at 2:15 PM, Thara Vadakkeveedu <tharagv@xxxxxxxxx> wrote:

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

You did get the right client, but that's not what you are running.  You are running the preinstalled Postgres which came pre-installed on your system.  Type "which pg_dump" to see where it is located.  Your best bet is to use your package manager to remove the preinstalled version, as otherwise it's going to keep giving you trouble.

Craig
 

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@xxxxxxxxxxxxxxxxx>
To: pgsql-admin@xxxxxxxxxxxxxx
Sent: Wednesday, September 25, 2013 3:47 PM
Subject: Re: 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.