Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 201F364FD36 for ; Wed, 17 Sep 2008 11:30:14 -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 98071-09 for ; Wed, 17 Sep 2008 11:30:07 -0300 (ADT) X-Greylist: delayed 00:06:39.765245 by SQLgrey-1.7.6 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.176]) by postgresql.org (Postfix) with ESMTP id 322E664FD35 for ; Wed, 17 Sep 2008 11:30:06 -0300 (ADT) Received: by el-out-1112.google.com with SMTP id p32so1205612elf.10 for ; Wed, 17 Sep 2008 07:30:04 -0700 (PDT) Received: by 10.142.246.6 with SMTP id t6mr886155wfh.119.1221661404019; Wed, 17 Sep 2008 07:23:24 -0700 (PDT) Received: by 10.142.134.5 with HTTP; Wed, 17 Sep 2008 07:23:23 -0700 (PDT) Message-ID: Date: Wed, 17 Sep 2008 10:23:23 -0400 From: "Jonathan Nalley" To: dbchristopher , pgsql-admin@postgresql.org Subject: Re: unable to backup database -- psql not up to date In-Reply-To: <19520466.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <19520466.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/171 X-Sequence-Number: 30264 On Tue, Sep 16, 2008 at 5:53 PM, dbchristopher wrote: > > 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? What OS are you running on? How did you perform this upgrade? In a packaged form like rpm? or did you compile from source?