Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5693D64FF09 for ; Tue, 16 Sep 2008 18:53:08 -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 87224-07 for ; Tue, 16 Sep 2008 18:53:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 7050D64FEE1 for ; Tue, 16 Sep 2008 18:53:05 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1KfiTn-0002yw-9E for pgsql-admin@postgresql.org; Tue, 16 Sep 2008 14:53:03 -0700 Message-ID: <19520466.post@talk.nabble.com> Date: Tue, 16 Sep 2008 14:53:03 -0700 (PDT) From: dbchristopher To: pgsql-admin@postgresql.org Subject: unable to backup database -- psql not up to date MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: dbchristopher@gmail.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.587 tagged_above=0 required=5 tests=DNS_FROM_OPENWHOIS=2.431, WHOIS_MYPRIVREG=0.156 X-Spam-Level: ** X-Archive-Number: 200809/170 X-Sequence-Number: 30263 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: 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.