Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F1B7164FCCA for ; Wed, 17 Sep 2008 18:03:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 25836-05 for ; Wed, 17 Sep 2008 18:03:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n5b.bullet.mail.ac4.yahoo.com (n5b.bullet.mail.ac4.yahoo.com [76.13.13.75]) by postgresql.org (Postfix) with SMTP id 879F964FCC0 for ; Wed, 17 Sep 2008 18:03:23 -0300 (ADT) Received: from [76.13.13.26] by n5.bullet.mail.ac4.yahoo.com with NNFMP; 17 Sep 2008 21:03:21 -0000 Received: from [76.13.10.170] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 17 Sep 2008 21:03:21 -0000 Received: from [127.0.0.1] by omp111.mail.ac4.yahoo.com with NNFMP; 17 Sep 2008 21:03:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 560657.56095.bm@omp111.mail.ac4.yahoo.com Received: (qmail 40224 invoked by uid 60001); 17 Sep 2008 14:05:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=ca97zLBDSTLBwLJ4LjCrcTSSV82BD9gck3lOxNs3b7Aure51iAirrb6rV14QPJkCoS9EXKptewgM8kQ6zVz3FEqr9TjcgzOBFpo/iXqT2mcMLMUAT3IJG/DT6i4HeSlhKZf8QVM/vFjBapj1X7ZiU8s19Kkp+8LvK5FheYgtIQI=; X-YMail-OSG: 1SpxFycVM1lHkVOvneRO0SvulpNJHf2tOoR698Zyy_raJBNy2KIQguQC0Y7B7CnVwg-- Received: from [209.88.228.11] by web59502.mail.ac4.yahoo.com via HTTP; Wed, 17 Sep 2008 07:05:23 PDT X-Mailer: YahooMailWebService/0.7.218.2 Date: Wed, 17 Sep 2008 07:05:23 -0700 (PDT) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: unable to backup database -- psql not up to date To: pgsql-admin@postgresql.org, dbchristopher In-Reply-To: <19520466.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <810549.38541.qm@web59502.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.156 tagged_above=0 required=5 tests=WHOIS_MYPRIVREG=0.156 X-Spam-Level: X-Archive-Number: 200809/186 X-Sequence-Number: 30279 > From: dbchristopher > I upgraded to postgresql 8.3.3 a few weeks ago, and it seems > that while the > server was upgraded, but for some reason none of the > accompanying software > was (pg_dump, psql, etc) > > I get this error when I try to back up the database: > pg_dump: server version: 8.3.3; pg_dump version: 8.2.6 > pg_dump: aborting because of version mismatch (Use the -i > option to proceed > anyway.) > pg_dump: *** aborted because of error > > and likewise when I log into the psql client: > WARNING: You are connected to a server with major version > 8.3, > but your psql client is major version 8.2. Some backslash > commands, > such as \d, might not work properly. > > How could this have happened? I really need to be able to > back up my > information. I reinstalled the software and it didn't > change anything. What > do I do to upgrade pg_dump to the newest version? > -- > View this message in context: > This happend wend you use a old psql client to connect a new postgresql. Maybe you have two o more postgresql install in your computer. check the psql file and the path of this. http://www.nabble.com/unable-to-backup-database----psql-not-up-to-date-tp19520466p19520466.html > Sent from the PostgreSQL - admin mailing list archive at > Nabble.com. > > > -- > Sent via pgsql-admin mailing list > (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin