Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VPIGg-0005ml-JN for pgsql-admin@arkaria.postgresql.org; Thu, 26 Sep 2013 20:34:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VPIGg-00010t-2y for pgsql-admin@arkaria.postgresql.org; Thu, 26 Sep 2013 20:34:34 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOwq6-0002MP-EM for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 21:41:42 +0000 Received: from nm39-vm6.bullet.mail.gq1.yahoo.com ([98.136.217.109]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOwq2-0007mM-RB for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 21:41:41 +0000 Received: from [98.137.12.191] by nm39.bullet.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 21:41:37 -0000 Received: from [216.39.60.195] by tm12.bullet.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 21:41:37 -0000 Received: from [127.0.0.1] by omp1082.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 21:41:37 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 543065.75280.bm@omp1082.mail.gq1.yahoo.com Received: (qmail 4150 invoked by uid 60001); 25 Sep 2013 21:41:36 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1380145296; bh=/OBnXDMtRHMPayfGTFviF/A9WL1//x70RxWr8eMfVOI=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=XRDA88yvoPPNZZLkXYR4AAlKtP+hHU3KC/qvR5wgdozv5V13MO/Glkerh6n8UMfqQTDPq0+Cxfec6bUQ+j7J8Cr+PZIOXQECKLQR17Kgmkv+aU1LlBEZVmLdxhsRtvcYH6F9iBAORFGh6vV1iLnFUJeN7qvZ4/HfOwNeVqY+wW0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=oUr7tc6MUX2SliVgDUJO6nAhc891ABGwo5hiXT3mvoGWwY4SgsDUvzqcJZkKhYjcjMLEA3O5lvgydPZBM/vpbR2LZQbYOq2lONNgZGVfn6Tqly53npP+vXVUTma8X+Rg3v4lo10lyAylbd7QfWSVH3sivzH6V8iJhOGfcwmUr1c=; X-YMail-OSG: fwxiX70VM1nny6YH2Vytva683Vs2FpHeOLYWdoqwaRNFiwX 8rwmXEEFUSzM8q6SIiqb7vSYo.DQlQoojurqSE59W8sgCJ4tO8k1sSaHYxq2 vKTIbhjxrq.xthugLY3uLnO2rKy9z1xtW45gwmPG1QDJagKBk1_qZcZK0gKp wyR_No1PH09MnPFLiMZMVCrAN2Le8w160MX6l4PcpolcVe6GlKUCa2tZ_o.e f7FcFBs_Z4UGyJyQ2D36h_.0iqL0fOct3EDjlwa8b3dOk5muX23_rtgiY2Sh BNLHUrVqmAOxfKQ4BKKXhDhwW_jk3aaml8Ya1WsAJkYFLoYUMii7NQzr8e1h TcuzjNjJsPCyZR3r2WwddgwslAejkIKCunG8OhkzWUWT4hyc4iD9yYAya4vC EWb0VxhwkFcFWzkWz4RjIy39v.vORmXMNgtXxThfUo2LGBoXifDO.BYVSRNS rrxOoYGbbiBbbVh5lWb2H5YG.PH.goIJSu.bVHy9Ypp8_XWal0gtsIVERZHi trYIfRfNTxrXyKU3lPCZB_eHakusEUhOHZnvnNpPEyQdXfijI617Ce7etBr8 chKeps0WNn8pwpbTplqGzQiMNIe_r33vj9Rft Received: from [50.241.80.25] by web125006.mail.ne1.yahoo.com via HTTP; Wed, 25 Sep 2013 14:41:36 PDT X-Rocket-MIMEInfo: 002.001, SGksCldoZW4geW91IHNheSBwcmVpbnN0YWxsZWQgd2l0aCB0aGUgc3lzdGVtLCB5b3UgbWVhbiBwcmVpbnN0YWxsZWQgd2l0aCBSZWRIYXQgTGludXg_CgpJIHNlZW0gdG8gaGF2ZSB0aGUgcmlnaHQgdmVyc2lvbiAuLi4gSSBoYWQgdG8gdXNlIHRoZSBmdWxsIHBhdGggdG8gaWRlbnRpZnkgdGhlIHZlcnNpb24uIAoKLWJhc2gtNC4xJCAvdXNyL3Bnc3FsLTkuMi9iaW4vcGdfZHVtcCAtLXZlcnNpb24KcGdfZHVtcCAoUG9zdGdyZVNRTCkgOS4yLjQKCgpIb3cgY2FuIEkgZmluZCB0aGUgcGFja2FnZSBuYW1lIGYBMAEBAQE- X-Mailer: YahooMailWebService/0.8.157.561 References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com> <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> <1380030420.19939.YahooMailNeo@web125003.mail.ne1.yahoo.com> <1380030784.27416.YahooMailNeo@web125003.mail.ne1.yahoo.com> <1380031785.83405.YahooMailNeo@web125005.mail.ne1.yahoo.com> <1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com> <52433DB4.2040206@pasteleros.org.ar> <1380143724.23836.YahooMailNeo@web125005.mail.ne1.yahoo.com> Message-ID: <1380145296.817.YahooMailNeo@web125006.mail.ne1.yahoo.com> Date: Wed, 25 Sep 2013 14:41:36 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: pd_dump server mismatch error To: Craig James Cc: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1430280533-623170080-1380145296=:817" X-Pg-Spam-Score: -2.1 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---1430280533-623170080-1380145296=:817 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0AWhen you say preinstalled with the system, you mean preinstalled with= RedHat Linux?=0A=0AI seem to have the right version ... I had to use the f= ull path to identify the version. =0A=0A-bash-4.1$ /usr/pgsql-9.2/bin/pg_du= mp --version=0Apg_dump (PostgreSQL) 9.2.4=0A=0A=0AHow can I find the packag= e name for the older version?=A0=0AThanks!=0AThara.=0A=0A=0A=0A____________= ____________________=0A From: Craig James =0ATo: Tha= ra Vadakkeveedu =0ASent: Wednesday, September 25, 2013 = 5:32 PM=0ASubject: Re: [ADMIN] pd_dump server mismatch error=0A =0A=0A=0A= =0A=0A=0A=0A=0AOn Wed, Sep 25, 2013 at 2:15 PM, Thara Vadakkeveedu wrote:=0A=0AHi =0A>I did not install the client separately. I a= ssumed i would get the right client as part of the 9.2 Yum install...=0A>= =0A=0AYou did get the right client, but that's not what you are running.=A0= You are running the preinstalled Postgres which came pre-installed on your= system.=A0 Type "which pg_dump" to see where it is located.=A0 Your best b= et is to use your package manager to remove the preinstalled version, as ot= herwise it's going to keep giving you trouble.=0A=0ACraig=0A=A0=0A=0A=0A>I = see psql is an older version too.=0A>=0A># su - postgres=0A>-bash-4.1$ psql= -d postgres=0A>psql (8.4.13, server 9.2.4)=0A>WARNING: psql version 8.4, s= erver version 9.2.=0A>=A0=A0=A0=A0=A0=A0=A0=A0 Some psql features might not= work.=0A>=0A>When I installed postgresql-9.2 using Yum (yum install postgr= esql92 postgresql92-server)=0A>=0A>The following 3 packages were installed:= =0A>=0A>=A0postgresql92=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0x86_64=A0=A0=A0= =A0=A0 9.2.4-1PGDG.rhel6=A0=A0=A0=A0=A0=A0 pgdg92=A0=A0=A0=A0=A0 970 k=0A>= =A0postgresql92-server=A0=A0=A0=A0=A0 x86_64=A0=A0=A0=A0=A0 9.2.4-1PGDG.rhe= l6=A0=A0=A0=A0=A0=A0 pgdg92=A0=A0=A0=A0=A0 3.8 M=0A>=A0postgresql92-libs=A0= =A0=A0=A0=A0=A0=A0 x86_64=A0=A0=A0=A0=A0 9.2.4-1PGDG.rhel6=A0=A0=A0=A0=A0= =A0 pgdg92=A0=A0=A0=A0=A0 185 k =0A>I assumed this took care of installing = the right client. I run the client from the same machine where the server i= s installed. =0A>=0A>Is there a=A0 separate package I should have installed= for the 9.2 client ? =0A>Thanks,=0A>TG=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>____= ____________________________=0A> From: Alejandro Brust =0A>To: pgsql-admin@postgresql.org =0A>Sent: Wednesday, September= 25, 2013 3:47 PM=0A>Subject: Re: [ADMIN] pd_dump server mismatch error=0A>= =0A>=0A>=0A>Hello, first excuse my English=0A>U cant do a backup whit a Cl= ient minor version than the server=0A>U must have same version to do the ba= ckup, so U need upgrade your=0A client (pg_dump 8.4.13) to at least 9.2.= 4=0A>=0A>=0A>See U=0A>=0A>=0A>=0A>El 25/09/2013 15:55, Thara Vadakkeveedu e= scribi=F3:=0A>=0A>=0A>>=0AHi=0A>>I wanted to take a backup of my database. = =0A>>=0A>>pg_dump throws a server mismatch version error=0A>>=0A>># cd back= ups=0A>># su - postgres=0A>>-bash-4.1$ pg_dump mydb > mydbfile=0A>>pg_dump:= server version: 9.2.4; pg_dump version: 8.4.13=0A>>pg_dump: aborting becau= se of server version mismatch=0A>>=0A>>This is a fresh install of postgresq= l on a red hat linux server=0A that did not have any previous databa= se installed on it . I=0A installed postgresql 9.2 from an rpm=0A = (pgdg-redhat92-9.2-7.noarch.rpm ) using yum install.=0A>>=0A>>Why am I= seeing this error?=0A>>How can I take a backup of my database? There are t= wo tables=0A that have 20,000+ rows in it, that I want to backup=A0 = and restore=0A when needed.=0A>>=0A>>thanks=0A>>thara.=0A>>=0A>>=0A>= =0A>=0A> ---1430280533-623170080-1380145296=:817 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,
When you say p= reinstalled with the system, you mean preinstalled with RedHat Linux?
I seem to have the right version ... I had to use the full path to identi= fy 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 nam= e for the older version? 
Thanks!
Thara.

= From: Craig James <cjam= es@emolecules.com>
To:<= /b> Thara Vadakkeveedu <tharagv@yahoo.com>
Sent: Wednesday, September 25, 2013 5:32 PM
= Subject: Re: [ADMIN] pd_d= ump server mismatch error




On Wed, Se= p 25, 2013 at 2:15 PM, Thara Vadakkeveedu <tharagv@yahoo.com> wrote:
=0A
Hi
I did not instal= l the client separately. I assumed i would get the right client as part of = the 9.2 Yum install...
=0A

Y= ou 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 sys= tem.  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.
=0A
Craig
 <= br>

I se= e psql is an older version too.
=0A
# su - postgres
-bash-4.1$ psq= l -d postgres
psql (8.4.13, server 9.2.4)
WARNING: psql version 8.4, = server version 9.2.
         Som= e psql features might not work.

When I installed postgresql-9.2 usin= g Yum (= yum install postgresql92 postgresql92-server)
=0A
The foll= owing 3 packages were installed:
=0A=0A
&n= bsp;postgresql92       &nbs= p;     x86_64  &nbs= p;  =0A9.2.4-1PGDG.rhel6    &nbs= p; =0Apgdg92      970 k
=0A=0A
 postgresql92-s= erver      x86_64  &n= bsp;   9.2.4-1PGDG.rhel6    &nbs= p;  pgdg92     =0A3.8 M
=0A<= span style=3D"font-size:12.0pt;"> postgresql92-libs=         x86_64  &= nbsp;   9.2.4-1PGDG.rhel6    &nb= sp;  pgdg92     =0A185 k<= /span>=0A=0A
I assumed this took care of installing the right clie= nt. I run the client from the same machine where the server is installed. <= br>
Is there a  separate package I should have installed for the 9.= 2 client ?
=0AThanks,
TG


=0A
From: Alejandro= Brust <alejandr= ob@pasteleros.org.ar>
=0A To= : pgsql-admi= n@postgresql.org
Sent:= Wednesday, September 25, 2013 3:47 PM
=0A Subject: Re: [ADMIN] pd_dump server mismatch error

=0A =0A=0A =0A =0A
=0A Hello,= first excuse my English
=0A U cant do a backup whit a Client minor v= ersion than the server
=0A U must have same version to do the backup,= so U need upgrade your=0A client (pg_dump 8.4.13) to at least 9.2.4
= =0A
=0A
=0A See U
=0A
=0A
=0A
El = 25/09/2013 15:55, Thara Vadakkeveedu=0A escribi=F3:
=0A
= =0A
=0A
=0A
=0A
=0A Hi
=0A I wanted to take a b= ackup of my database.
=0A
=0A pg_dump throws a server= mismatch version error
=0A
=0A # cd backups
=0A = # su - postgres
=0A -bash-4.1$ pg_dump mydb > mydbfile=0A pg_dump: server version: 9.2.4; pg_dump version: 8.4.13
=0A = pg_dump: aborting because of server version mismatch
=0A <= br>=0A This is a fresh install of postgresql on a red hat linux serv= er=0A that did not have any previous database installed on it . I=0A= installed postgresql 9.2 from an rpm=0A (pgdg-redhat92-9.2-7= .noarch.rpm ) using yum install.
=0A
=0A Why am I seei= ng this error?
=0A How can I take a backup of my database? There = are two tables=0A that have 20,000+ rows in it, that I want to backu= p  and restore=0A when needed.
=0A
=0A tha= nks
=0A thara.
=0A
=0A
=0A =
=0A
=0A
=0A
=0A <= br>=0A
=0A=0A





---1430280533-623170080-1380145296=:817--