pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump etc. versions
3+ messages / 3 participants
[nested] [flat]
* pg_dump etc. versions
@ 2008-09-03 09:56 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
0 siblings, 1 reply; 3+ messages in thread
From: Jan-Peter Seifert @ 2008-09-03 09:56 UTC (permalink / raw)
To: pgsql-admin
Hello,
I'm wondering if there's a compatibility list of the tools supplied with PostgreSQL - e.g. psql seems to be very server version specific (only major or also minor versions?).
For pg_dump I'd say users should use the version of the target server if it's already installed, but is this also the case if the target server version is older? Am I completely wrong? Should I always use the pg_dump from the source server? When migrating from 8.1 to 8.2 I get several errors with commands regarding creating users and a lib that had been integrated into the core when restoring from the source server's pg_dump's dump. When using the target server's pg_dump for the dump I don't. But is then really everything okay? And pgAdmin comes with its own set of the PostgreSQL tools ...
http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html
What approach for pg_dump (and other tools) should be recommended?
Thank you very much,
Peter
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_dump etc. versions
@ 2008-09-04 13:43 Peter Eisentraut <peter_e@gmx.net>
parent: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Eisentraut @ 2008-09-04 13:43 UTC (permalink / raw)
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; +Cc: pgsql-admin
Jan-Peter Seifert wrote:
> I'm wondering if there's a compatibility list of the tools supplied with PostgreSQL - e.g. psql seems to be very server version specific (only major or also minor versions?).
> For pg_dump I'd say users should use the version of the target server if it's already installed, but is this also the case if the target server version is older? Am I completely wrong? Should I always use the pg_dump from the source server? When migrating from 8.1 to 8.2 I get several errors with commands regarding creating users and a lib that had been integrated into the core when restoring from the source server's pg_dump's dump. When using the target server's pg_dump for the dump I don't. But is then really everything okay? And pgAdmin comes with its own set of the PostgreSQL tools ...
I think the only thing that we really check is that pg_dump of a newer
version can dump databases from an older version server. All the other
tools probably only work (completely) with a server from the same major
release.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_dump etc. versions
@ 2008-09-08 10:05 Jan-Peter.Seifert@gmx.de
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 3+ messages in thread
From: Jan-Peter.Seifert@gmx.de @ 2008-09-08 10:05 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin
Hello Peter,
thank you very much for your quick reply again.
> Datum: Thu, 04 Sep 2008 16:43:42 +0300
> Von: Peter Eisentraut <peter_e@gmx.net>
> An: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
> CC: Postgres <pgsql-admin@postgresql.org>
> Betreff: Re: [ADMIN] pg_dump etc. versions
> I think the only thing that we really check is that pg_dump of a newer
> version can dump databases from an older version server. All the other
> tools probably only work (completely) with a server from the same major
> release.
http://www.postgresql.org/docs/8.3/static/release-8-3-3.html
Now I have an idea why I couldn't create and restore a dump with pgAdmin III v1.8.4 with one of our databases. In the older v1.6.3 the same dump could be restored. v1.8.4 came with the 8.3.0.842 version of pg_dump?
I guess the version restriction goes for pgAdmin III as well. If I remember correctly I got an error message on an v8.2 server and one of the possible reasons given by pgAdmin III was an feature that came with v8.3 - can't find the note I took at the moment though.
Thank you very much,
Peter
--
GMX Kostenlose Spiele: Einfach online spielen und Spaß haben mit Pastry Passion!
http://games.entertainment.gmx.net/de/entertainment/games/free/puzzle/6169196
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-09-08 10:05 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-03 09:56 pg_dump etc. versions Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2008-09-04 13:43 ` Peter Eisentraut <peter_e@gmx.net>
2008-09-08 10:05 ` Jan-Peter.Seifert@gmx.de
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