From: DDT <410845160@qq.com>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
To: alejandrob@pasteleros.org.ar <alejandrob@pasteleros.org.ar>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pd_dump server mismatch error
Date: Thu, 26 Sep 2013 09:43:18 +0800
Message-ID: <tencent_4A1A53BE6A8B6FCE3597B251@qq.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
I think you can find if there is a pg_dump through follow 2:
ps -ef | grep postgres
there will be at least one line include the path of postgres server excutable file.
and ls that path to show if there is a pg_dump.
if your disk hasn't huge number of files,
find / -name pg_dump
try the result like the 9.2 one
------------------ Original ------------------
From: "Thara Vadakkeveedu";<tharagv@yahoo.com>;
Date: Thu, Sep 26, 2013 05:15 AM
To: "alejandrob@pasteleros.org.ar"<alejandrob@pasteleros.org.ar>; "pgsql-admin@postgresql.org"<pgsql-admin@postgresql.org>;
Subject: Re: [ADMIN] 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@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: 410845160@qq.com, tharagv@yahoo.com, alejandrob@pasteleros.org.ar
Subject: Re: pd_dump server mismatch error
In-Reply-To: <tencent_4A1A53BE6A8B6FCE3597B251@qq.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