Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOuF3-0001VT-8D for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 18:55:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VOuF2-0000uf-ND for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 18:55:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOuF1-0000uF-CF for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 18:55:15 +0000 Received: from nm31.bullet.mail.gq1.yahoo.com ([98.136.217.14]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOuEw-0006vv-P8 for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 18:55:14 +0000 Received: from [98.137.12.57] by nm31.bullet.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 18:55:07 -0000 Received: from [98.137.12.228] by tm2.bullet.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 18:55:07 -0000 Received: from [127.0.0.1] by omp1036.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 18:55:07 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 420838.1486.bm@omp1036.mail.gq1.yahoo.com Received: (qmail 67781 invoked by uid 60001); 25 Sep 2013 18:55:06 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1380135306; bh=NxYvPpUUGW62beBMrZQ+TtHS4glpfzkEvh9nRsO8FTQ=; 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=NU5dFUtb1cFEawViv+FOhyTlHSFJQGyedpdyVGbptB3XUBBrusprdEBew8dIkAibPZzZgqY3t3hiLvjsndX1ZCESAnNIt9dI9ZjkhNnHdbo86pqW0ka4rpe40qrIfNwOhwdMzaCQ+fL4PhaSed5Uantf6CbbTnT8r8KNZNfVoAY= 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=hclSYGg6EbdMtUSLoJG672LgJ7y7WX6OLIxWReX3v14EbuGmYttrRp9ARs4+drSXx6cLfndiMW7sDMa+yJrXR0p8e8aJfW8ZsPapjOfdUEcMFitGcVwMh/KRCYNTo3uEU33ybEkFsIMuagQ9fxdaIGIIKbnxVZmD75Go0qHA6t8=; X-YMail-OSG: hdvw1KUVM1lVdFSruLj0LrKvqXmxRixDs9U8YUkmhUbg6u0 G70k0TRPBhsXhOvCGtYwU_EZctCSNmZHtS79m9GTPboS9u_rRR5lq5KcP2id yZv7Ap6ldBYp484SP.cxSsbOi8hCe3zxf93YLKue1mO4amHT7c2A6bipGIIm oMtgAhe_BQif7lm8S7oIPyRw7twl4L2tzrHe5hwQCFD2o8yXKaRaVegjgIoB CUAXcWssQ1ST19bFKR6YtHkYXJMJUR_fsD5_eb9owVYn9t19Fv6yuzi0y3Jm NenCzPm.40KqoSGp37rLAV_fheoaSMBUuri7CU4Ky_hcmt1Rba2qLTpzTx5. ytJd6651jkpTQPiicfi5Rvr9GZ5WMfWeMDC2Qqwsxf5n54kcwdt.As75ynxv bSR93diCu0SxvaPhXVV9bWVyGreoT9O_koQASQo0G_rAIjOtuASXJ.t2vZaN gy3akSEpa8sq7D7SnREGJinhE2H5a2QF61O1RVRVcRC5DkhPsgl2Ahz7P1Zq ojn9F7mbUqTNWesxG8DqrxOxoM5YmxaTMfFzTOpfVmnoAFLTe1vK8d3StlgM lg_bupreI.m1AcjplXRD2ZPP2Nio4730- Received: from [50.241.80.25] by web125005.mail.ne1.yahoo.com via HTTP; Wed, 25 Sep 2013 11:55:05 PDT X-Rocket-MIMEInfo: 002.001, CkhpCkkgd2FudGVkIHRvIHRha2UgYSBiYWNrdXAgb2YgbXkgZGF0YWJhc2UuIAoKcGdfZHVtcCB0aHJvd3MgYSBzZXJ2ZXIgbWlzbWF0Y2ggdmVyc2lvbiBlcnJvcgoKIyBjZCBiYWNrdXBzCiMgc3UgLSBwb3N0Z3JlcwotYmFzaC00LjEkIHBnX2R1bXAgbXlkYiA.IG15ZGJmaWxlCnBnX2R1bXA6IHNlcnZlciB2ZXJzaW9uOiA5LjIuNDsgcGdfZHVtcCB2ZXJzaW9uOiA4LjQuMTMKcGdfZHVtcDogYWJvcnRpbmcgYmVjYXVzZSBvZiBzZXJ2ZXIgdmVyc2lvbiBtaXNtYXRjaAoKVGhpcyBpcyBhIGZyZXNoIGluc3QBMAEBAQE- 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> Message-ID: <1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com> Date: Wed, 25 Sep 2013 11:55:05 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: pd_dump server mismatch error To: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1988236031-1053496879-1380135305=:67283" X-Pg-Spam-Score: -4.0 (----) 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-1053496879-1380135305=:67283 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0AHi=0AI wanted to take a backup of my database. =0A=0Apg_dump throws a se= rver mismatch version error=0A=0A# cd backups=0A# su - postgres=0A-bash-4.1= $ pg_dump mydb > mydbfile=0Apg_dump: server version: 9.2.4; pg_dump version= : 8.4.13=0Apg_dump: aborting because of server version mismatch=0A=0AThis i= s 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.=0A=0AWhy am I see= ing this error?=0AHow can I take a backup of my database? There are two tab= les that have 20,000+ rows in it, that I want to backup=A0 and restore when= needed.=0A=0Athanks=0Athara. --1988236031-1053496879-1380135305=:67283 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

Hi
I wanted to take a backup of my database.

pg_dump thro= ws 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 mism= atch

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 post= gresql 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 databa= se? There are two tables that have 20,000+ rows in it, that I want to backu= p  and restore when needed.

thanks
thara.

--1988236031-1053496879-1380135305=:67283--