Re: unable to backup database -- psql not up to date

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org, dbchristopher <dbchristopher(at)gmail(dot)com>
Subject: Re: unable to backup database -- psql not up to date
Date: 2008-09-17 14:05:23
Message-ID: 810549.38541.qm@web59502.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> From: dbchristopher <dbchristopher(at)gmail(dot)com>

> 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:
>
This happend wend you use a old psql client to connect a new postgresql. Maybe you have two o more postgresql install in your computer. check the psql file and the path of this.

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.
>
>
> --
> Sent via pgsql-admin mailing list
> (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jonathan Nalley 2008-09-17 14:23:23 Re: unable to backup database -- psql not up to date
Previous Message Vivek_Sharan 2008-09-17 13:18:24 Re: Heavy postgres process