From: Thara Vadakkeveedu <tharagv@yahoo.com>
To: Craig James <cjames@emolecules.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pd_dump server mismatch error
Date: Wed, 25 Sep 2013 14:41:36 -0700 (PDT)
Message-ID: <1380145296.817.YahooMailNeo@web125006.mail.ne1.yahoo.com> (raw)
In-Reply-To: <CAFwQ8reA2DcnSE71c8dAh_rp4aZ3T1eezPw-FrTTVP_ff9HQrw@mail.gmail.com>
References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com>
<1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com>
<A737B7A37273E048B164557ADEF4A58B17C23A2B@ntex2010a.host.magwien.gv.at>
<1380030420.19939.YahooMailNeo@web125003.mail.ne1.yahoo.com>
<1380030784.27416.YahooMailNeo@web125003.mail.ne1.yahoo.com>
<1380031785.83405.YahooMailNeo@web125005.mail.ne1.yahoo.com>
<A737B7A37273E048B164557ADEF4A58B17C23CED@ntex2010a.host.magwien.gv.at>
<1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com>
<52433DB4.2040206@pasteleros.org.ar>
<1380143724.23836.YahooMailNeo@web125005.mail.ne1.yahoo.com>
<CAFwQ8reA2DcnSE71c8dAh_rp4aZ3T1eezPw-FrTTVP_ff9HQrw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
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
>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@pasteleros.org.ar>
>To: pgsql-admin@postgresql.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.
>>
>>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tharagv@yahoo.com, cjames@emolecules.com
Subject: Re: pd_dump server mismatch error
In-Reply-To: <1380145296.817.YahooMailNeo@web125006.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox