Using many pg_dump in pgAdmin (aka Re : Re : pg_dump: ALTER SEQUENCE ... OWNED in 8.1)

Hi,

Just to clarify what I mean.
I am quite happy (or should I say: not too unhappy) to juggle with different version of pg_dump in my scripts.
If that's the way it has to be, that's the way it has to be.
See point A, below.

But to me pgAdmin is a tool that must be easy to use.
Hence, as it seems the rule of pg_dump usage is "if I connect to 8.1 server, I must use pg_dump 8.1; if I connect to a 8.2 server, I must use a 8.2 server; ...". There should be an option for doing that automatically: I should not need to switch from a pg_dump to another when I switch servers.

So what I have in mind is:
- default installation: use pgAdmin pg_dump
- activate multi-pg_dump mode: give a directory where there's a tree with a directory for each server version used. And each directory contains the matching (to the directory name) pg_dump version.

This way, the standard install is the same.
But if I need to connect to different servers with different versions, I don't need to keep switching from one pg_dump to another all the time: pgAdmin will do it for me.
I understand that's quite a lot of work to be done, but on a user perspective, that's the painless of doing it ... well, at least on my humble opinion, but I assume other users might have other views on the subject.

Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----

>>> May be that's a pg_dump issue: it should be compatible with the
>>> server it connects to, and not to its own version ?
>
>> What do you mean?

>Shipping every version of pg_dump, libpq & supporting DLL's back to v7.3
>by the sound of it!

** Point A **
Nope, just that pg_dump should generate code compatible with the server it connects too.
I was told once on the PG list that pg_dump aim is to be able to backup and restore, with the newer version of the tool, that does not work on an older server.

___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com