Hi Markus! Markus Schaber [2005-11-21 13:28 +0100]: > But I have a little problem: When connecting to remote servers via -h > -p -U options, I did not find any possibility to specify which client > version to use (I currently have all three versions of postgresql-client > installed, as we have 7.4, 8.0 and 8.1 servers). I always end up using > the 7.4 client. But the postgresql people recommend to use the > corresponding psql version.
Oh, right now it uses the latest version if you don't have any local clusters, or the version of your default cluster if you have local clusters. I agree, that should be improved. It's not that critical, since the client ABI is the same for 7.4, 8.0, and 8.1, you can use any version to connect to any server. > And I did not find any possibility to specify remote hosts via the > user_clusters mechanism, this seems to work for local clusters only. It would make sense to support this. My proposal: /e/p/user_clusters and ~/.postgresqlrc should keep their current format, but CLUSTER is extended: it is either a local cluster name, or can specify host:port, e. g. 8.1 db.my.net:5432 mydb in .postgresqlrc, or joe * 8.1 main * martin * 8.0 db.my.net:5432 mydb in user_clusters. Consequently, that would mean to extend the --cluster syntax in a similar fashion: psql --cluster 8.0/172.16.0.1:5432 What do you think about that? > The only way I found to work around this is to call the binaries in > /usr/lib/postgresql/X.Y/bin/ directly, which is cumbersome. Right. > Btw: Is it necessary to display 2 warning dialogs that complain about > the obscolence of postgresql 8.0 when upgrading postgresql-common? And, > notice, it is not complaining about the 7.4 server (which is actually > installed on my local machine), but about 8.0 which is not installed. You have postgresql-cliet-8.0 installed (I bet). I think the double dialog got fixed as a side effect of the changes in postgresql-common 34. Please file a separate bug if you still encounter this. Thanks! Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates?
signature.asc
Description: Digital signature
