Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOwQr-0007PT-Qb for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 21:15:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VOwQr-0007C3-A5 for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 21:15:37 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOwQp-0007Bw-Qt for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 21:15:36 +0000 Received: from nm26-vm0.bullet.mail.bf1.yahoo.com ([98.139.213.74]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOwQh-0007LF-Ej for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 21:15:35 +0000 Received: from [98.139.212.144] by nm26.bullet.mail.bf1.yahoo.com with NNFMP; 25 Sep 2013 21:15:26 -0000 Received: from [98.139.212.249] by tm1.bullet.mail.bf1.yahoo.com with NNFMP; 25 Sep 2013 21:15:26 -0000 Received: from [127.0.0.1] by omp1058.mail.bf1.yahoo.com with NNFMP; 25 Sep 2013 21:15:26 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 537301.63297.bm@omp1058.mail.bf1.yahoo.com Received: (qmail 23916 invoked by uid 60001); 25 Sep 2013 21:15:25 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1380143725; bh=Z1b/rryflrClBJ+ZoJqasAtIo4TdV6XgWUrnZ7gsHCE=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=VSsSfMJtkn5MjbpWj1jvVCsWVIDiAw7zb4hRzKrozCjbTWbgVbRMm6nOOujCJeX3wskMW2zWJLQ9jP1WyZKUTdNYbWc5awgLPQYmA7L1I+xmUQGsBmLglvlHgyZck5pVzTR3FWkSR4dDI4dx6XfA78yNXZAWm1fqeD/uXzbdDrk= 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:In-Reply-To:MIME-Version:Content-Type; b=5vjPULK2gYD9aG+1495K1DH8LfY953O/InNNxPGNgHxayZo9wAHx3Zd0+VvtALzjbYOgDvqf1J9BICsGG2QTZcvh+WtCZ8qI3QAo7VARpmxgztV7WjMD6if8qNhvcFgcS+gSSHA8nkaeFs7ZtT0X44GEjRFDYZMLKLvYu/m5Cn4=; X-YMail-OSG: B_zgyt8VM1kzB6n_rCQNVsHH..WHAf3foh5qMCZduvtatek KTHTeIbNJTTnGnAD_5p_k Received: from [50.241.80.25] by web125005.mail.ne1.yahoo.com via HTTP; Wed, 25 Sep 2013 14:15:24 PDT X-Rocket-MIMEInfo: 002.001, SGkgCkkgZGlkIG5vdCBpbnN0YWxsIHRoZSBjbGllbnQgc2VwYXJhdGVseS4gSSBhc3N1bWVkIGkgd291bGQgZ2V0IHRoZSByaWdodCBjbGllbnQgYXMgcGFydCBvZiB0aGUgOS4yIFl1bSBpbnN0YWxsLi4uCgpJIHNlZSBwc3FsIGlzIGFuIG9sZGVyIHZlcnNpb24gdG9vLgoKIyBzdSAtIHBvc3RncmVzCi1iYXNoLTQuMSQgcHNxbCAtZCBwb3N0Z3Jlcwpwc3FsICg4LjQuMTMsIHNlcnZlciA5LjIuNCkKV0FSTklORzogcHNxbCB2ZXJzaW9uIDguNCwgc2VydmVyIHZlcnNpb24gOS4yLgrCoMKgwqDCoMKgwqDCoAEwAQEBAQ-- 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> Message-ID: <1380143724.23836.YahooMailNeo@web125005.mail.ne1.yahoo.com> Date: Wed, 25 Sep 2013 14:15:24 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: pd_dump server mismatch error To: "alejandrob@pasteleros.org.ar" , "pgsql-admin@postgresql.org" In-Reply-To: <52433DB4.2040206@pasteleros.org.ar> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1988236031-1387496117-1380143724=:23836" X-Pg-Spam-Score: -1.3 (-) 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 --1988236031-1387496117-1380143724=:23836 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi =0AI did not install the client separately. I assumed i would get the ri= ght client as part of the 9.2 Yum install...=0A=0AI see psql is an older ve= rsion too.=0A=0A# su - postgres=0A-bash-4.1$ psql -d postgres=0Apsql (8.4.1= 3, server 9.2.4)=0AWARNING: psql version 8.4, server version 9.2.=0A=A0=A0= =A0=A0=A0=A0=A0=A0 Some psql features might not work.=0A=0AWhen I installed= postgresql-9.2 using Yum (yum install postgresql92 postgresql92-server)=0A= =0AThe 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.rhel6=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 = =0AI assumed this took care of installing the right client. I run the clien= t from the same machine where the server is installed. =0A=0AIs there a=A0 = separate package I should have installed for the 9.2 client ? =0AThanks,=0A= TG=0A=0A=0A=0A=0A=0A________________________________=0A From: Alejandro Bru= st =0ATo: pgsql-admin@postgresql.org =0ASent:= Wednesday, September 25, 2013 3:47 PM=0ASubject: Re: [ADMIN] pd_dump serve= r mismatch error=0A =0A=0A=0AHello, first excuse my English=0AU cant do a b= ackup whit a Client minor version than the server=0AU must have same versio= n to do the backup, so U need upgrade your=0A client (pg_dump 8.4.13) to= at least 9.2.4=0A=0A=0ASee U=0A=0A=0A=0AEl 25/09/2013 15:55, Thara Vadakke= veedu escribi=F3:=0A=0A=0A>=0AHi=0A>I wanted to take a backup of my databas= e. =0A>=0A>pg_dump throws a server mismatch version error=0A>=0A># cd backu= ps=0A># su - postgres=0A>-bash-4.1$ pg_dump mydb > mydbfile=0A>pg_dump: ser= ver version: 9.2.4; pg_dump version: 8.4.13=0A>pg_dump: aborting because of= server version mismatch=0A>=0A>This is a fresh install of postgresql on a = red hat linux server=0A that did not have any previous database inst= alled on it . I=0A installed postgresql 9.2 from an rpm=0A (p= gdg-redhat92-9.2-7.noarch.rpm ) using yum install.=0A>=0A>Why am I seeing t= his 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 backup=A0 and resto= re=0A when needed.=0A>=0A>thanks=0A>thara.=0A>=0A> --1988236031-1387496117-1380143724=:23836 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi
I did not inst= all the client separately. I assumed i would get the right client as part o= f 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.
   &= nbsp;     Some psql features might not work.

Whe= n I installed postgresql-9.2 using Yum (<= span style=3D"font-size:12.0pt;line-height:115%;font-family:"Times New= Roman","serif";=0Amso-fareast-font-family:"Times New R= oman";color:#4F6228;mso-themecolor:accent3;=0Amso-themeshade:128;mso-a= nsi-language:EN-US;mso-fareast-language:EN-US;=0Amso-bidi-language:AR-SA">y= um install postgresql92 postgresql92-server)

The following 3 packages were installed:=
=0A= =0A
 postgresql92             x86_64     =0A9.2.4-1PGDG.rhel= 6      =0Apgdg92      = 970 k
=0A=0A
 postgre= sql92-server     = x86_64    &nbs= p; 9.2.4-1PGDG.rhel6  &nb= sp;    pgdg92 &= nbsp;   =0A3.8 M
 postgresql92-libs=         x86_64      9.2.4-1PGDG.rhel6       pgdg= 92     =0A= 185 k=0A=0A
I assumed this took care of installing the righ= t client. I run the client from the same machine where the server is instal= led.

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

=0A =0A=0A =0A =0A
=0A Hello, first exc= use my English
=0A U cant do a backup whit a Client minor version tha= n 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 e= scribi=F3:
=0A
=0A
=0A
=0A

=0A <= /span>
=0A Hi
=0A I wanted to take a backup of my dat= abase.
=0A
=0A pg_dump throws a server mismatch versi= on error
=0A
=0A # cd backups
=0A # su - pos= tgres
=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
=0A T= his is a fresh install of postgresql on a red hat linux server=0A th= at did not have any previous database installed on it . I=0A install= ed postgresql 9.2 from an rpm=0A (pgdg-redhat92-9.2-7.noarch.rpm ) u= sing yum install.
=0A
=0A Why am I seeing this error?<= br>=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 backup  and re= store=0A when needed.
=0A
=0A thanks
=0A = thara.
=0A
=0A
=0A
=0A
=0A
=0A
=0A
=0A
= =0A=0A


--1988236031-1387496117-1380143724=:23836--