--- On Wed, 17/9/08, Jonathan Nalley <jnalley@xxxxxxxxxxx> wrote: > From: Jonathan Nalley <jnalley@xxxxxxxxxxx> > Subject: Re: [ADMIN] unable to backup database -- psql not up to date > To: "dbchristopher" <dbchristopher@xxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx > Date: Wednesday, 17 September, 2008, 3:23 PM > On Tue, Sep 16, 2008 at 5:53 PM, dbchristopher > <dbchristopher@xxxxxxxxx> 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.
