Re: pd_dump server mismatch error - Mailing list pgsql-admin
| From | Thara Vadakkeveedu |
|---|---|
| Subject | Re: pd_dump server mismatch error |
| Date | |
| Msg-id | 1380145296.817.YahooMailNeo@web125006.mail.ne1.yahoo.com Whole thread Raw |
| In response to | accidentally deleted data directory (Thara Vadakkeveedu <tharagv@yahoo.com>) |
| Responses |
Re: pd_dump server mismatch error
|
| List | pgsql-admin |
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
From: Craig James <cjames@emolecules.com>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
Sent: Wednesday, September 25, 2013 5:32 PM
Subject: Re: [ADMIN] pd_dump server mismatch error
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@emolecules.com>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
Sent: Wednesday, September 25, 2013 5:32 PM
Subject: Re: [ADMIN] pd_dump server mismatch error
On Wed, Sep 25, 2013 at 2:15 PM, Thara Vadakkeveedu <tharagv@yahoo.com> 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
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 kpostgresql92-server x86_64 9.2.4-1PGDG.rhel6 pgdg92 3.8 Mpostgresql92-libs x86_64 9.2.4-1PGDG.rhel6 pgdg92 185 kI 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@pasteleros.org.ar>
To: pgsql-admin@postgresql.org
Sent: Wednesday, September 25, 2013 3:47 PM
Subject: Re: [ADMIN] pd_dump server mismatch errorHello, 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 UEl 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.
pgsql-admin by date: