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,
[EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
