pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedunable to backup database -- psql not up to date
7+ messages / 7 participants
[nested] [flat]
* unable to backup database -- psql not up to date
@ 2008-09-16 21:53 dbchristopher <dbchristopher@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: dbchristopher @ 2008-09-16 21:53 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: unable to backup database -- psql not up to date
@ 2008-09-17 14:05 Lennin Caro <lennin.caro@yahoo.com>
parent: dbchristopher <dbchristopher@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Lennin Caro @ 2008-09-17 14:05 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, dbchristopher <dbchristopher@gmail.com>
> From: dbchristopher <dbchristopher@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: unable to backup database -- psql not up to date
@ 2008-09-17 14:23 Jonathan Nalley <jnalley@jnalley.com>
parent: dbchristopher <dbchristopher@gmail.com>
1 sibling, 2 replies; 7+ messages in thread
From: Jonathan Nalley @ 2008-09-17 14:23 UTC (permalink / raw)
To: dbchristopher <dbchristopher@gmail.com>; pgsql-admin
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?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: unable to backup database -- psql not up to date
@ 2008-09-17 15:44 Valentin Bogdanov <valiouk@yahoo.co.uk>
parent: Jonathan Nalley <jnalley@jnalley.com>
1 sibling, 0 replies; 7+ messages in thread
From: Valentin Bogdanov @ 2008-09-17 15:44 UTC (permalink / raw)
To: pgsql-admin
--- 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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: unable to backup database -- psql not up to date
@ 2008-09-17 18:38 Daniel Christopher <dbchristopher@gmail.com>
parent: Jonathan Nalley <jnalley@jnalley.com>
1 sibling, 1 reply; 7+ messages in thread
From: Daniel Christopher @ 2008-09-17 18:38 UTC (permalink / raw)
To: Jonathan Nalley <jnalley@jnalley.com>; pgsql-admin
> What OS are you running on?
>
> How did you perform this upgrade? In a packaged form like rpm? or
> did you compile from source?
>
>
I am running FreeBSD 6.1
I compiled from source, and followed the instructions in the
documentation about upgrading to a new major release (pg_dumpall,
shutdown, mv old version, install new version, restore)
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: unable to backup database -- psql not up to date
@ 2008-09-17 21:33 Tom Lane <tgl@sss.pgh.pa.us>
parent: Daniel Christopher <dbchristopher@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2008-09-17 21:33 UTC (permalink / raw)
To: Daniel Christopher <dbchristopher@gmail.com>; +Cc: Jonathan Nalley <jnalley@jnalley.com>; pgsql-admin
Daniel Christopher <dbchristopher@gmail.com> writes:
> I compiled from source, and followed the instructions in the
> documentation about upgrading to a new major release (pg_dumpall,
> shutdown, mv old version, install new version, restore)
Well, at that level of detail, it should've worked. So the problem is
somewhere in the details you left out ...
Maybe you have a PATH that contains an older PG version in some other
directory?
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: unable to backup database -- psql not up to date
@ 2008-09-17 21:41 Melissa Peterson <Melissa@gigacrete.com>
0 siblings, 0 replies; 7+ messages in thread
From: Melissa Peterson @ 2008-09-17 21:41 UTC (permalink / raw)
To: pgsql-admin; +Cc: dbchristopher@gmail.com
Just a thought, but did you compile from the ports? The PostgreSQL
client and server are separate ports on FreeBSD. If I recall correctly,
the updated client typically isn't handled as a dependency when the
server is updated, so you would likely have to handle them separately.
Mel Peterson
R&D Engineer
melissa@gigacrete.com
GigaCrete, Inc.
6775 Speedway Boulevard, Suite M-104
Las Vegas, NV 89115
Phone 702-643-6363
Fax 702-543-7010
www.gigacrete.com
B U I L D S T R O N G. B U I L D F O R W A R D.
This message and any attachments are solely for the intended recipient
and may contain confidential or privileged information. If you are not
the intended recipient, any disclosure, copying, use, or distribution of
the information included in this message and any attachments is strictly
prohibited. If you have received this communication in error, please
notify us by reply email and immediately and permanently delete this
message and any attachments.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Daniel
Christopher
Sent: Wednesday, September 17, 2008 11:39 AM
To: Jonathan Nalley; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unable to backup database -- psql not up to date
> What OS are you running on?
>
> How did you perform this upgrade? In a packaged form like rpm? or
> did you compile from source?
>
>
I am running FreeBSD 6.1
I compiled from source, and followed the instructions in the
documentation about upgrading to a new major release (pg_dumpall,
shutdown, mv old version, install new version, restore)
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2008-09-17 21:41 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-16 21:53 unable to backup database -- psql not up to date dbchristopher <dbchristopher@gmail.com>
2008-09-17 14:05 ` Lennin Caro <lennin.caro@yahoo.com>
2008-09-17 14:23 ` Jonathan Nalley <jnalley@jnalley.com>
2008-09-17 15:44 ` Valentin Bogdanov <valiouk@yahoo.co.uk>
2008-09-17 18:38 ` Daniel Christopher <dbchristopher@gmail.com>
2008-09-17 21:33 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-09-17 21:41 Re: unable to backup database -- psql not up to date Melissa Peterson <Melissa@gigacrete.com>
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