pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jonathan Nalley <jnalley@jnalley.com>
To: dbchristopher <dbchristopher@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: unable to backup database -- psql not up to date
Date: Wed, 17 Sep 2008 10:23:23 -0400
Message-ID: <a9f2bef50809170723xa6ac23dr68f08def6ae4dc8a@mail.gmail.com> (raw)
In-Reply-To: <19520466.post@talk.nabble.com>
References: <19520466.post@talk.nabble.com>

On Tue, Sep 16, 2008 at 5:53 PM, dbchristopher <dbchristopher@gmail.com> 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?



view thread (7+ messages)  latest in thread

Message-ID: <a9f2bef50809170723xa6ac23dr68f08def6ae4dc8a@mail.gmail.com>
Permalink:  ../a9f2bef50809170723xa6ac23dr68f08def6ae4dc8a@mail.gmail.com/
Also on:    postgresql.org/message-id/a9f2bef50809170723xa6ac23dr68f08def6ae4dc8a@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jnalley@jnalley.com, dbchristopher@gmail.com
  Subject: Re: unable to backup database -- psql not up to date
  In-Reply-To: <a9f2bef50809170723xa6ac23dr68f08def6ae4dc8a@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox