pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Valentin Bogdanov <valiouk@yahoo.co.uk>
To: pgsql-admin@postgresql.org
Subject: Re: unable to backup database -- psql not up to date
Date: Wed, 17 Sep 2008 15:44:29 +0000 (GMT)
Message-ID: <850986.33638.qm@web25801.mail.ukl.yahoo.com> (raw)
In-Reply-To: <a9f2bef50809170723xa6ac23dr68f08def6ae4dc8a@mail.gmail.com>




--- On Wed, 17/9/08, Jonathan Nalley <jnalley@jnalley.com> wrote:

> From: Jonathan Nalley <jnalley@jnalley.com>
> Subject: Re: [ADMIN] unable to backup database -- psql not up to date
> To: "dbchristopher" <dbchristopher@gmail.com>, pgsql-admin@postgresql.org
> Date: Wednesday, 17 September, 2008, 3:23 PM
> 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?

yup, the postgres clients are usually shipped in their own packages, separate from the server package. I do have to manually upgrade the client packages on a Debian system.




      



view thread (7+ messages)  latest in thread

Message-ID: <850986.33638.qm@web25801.mail.ukl.yahoo.com>
Permalink:  ../850986.33638.qm@web25801.mail.ukl.yahoo.com/
Also on:    postgresql.org/message-id/850986.33638.qm@web25801.mail.ukl.yahoo.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: valiouk@yahoo.co.uk
  Subject: Re: unable to backup database -- psql not up to date
  In-Reply-To: <850986.33638.qm@web25801.mail.ukl.yahoo.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