Hi, Martin, Martin Pitt wrote:
> 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. Okay, that explains that I always get the 7.4 clients. > 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. I know, but there may be problems with \ commands in psql, as well as pg_dump / pg_restore not knowing about changed internal structures. I remember having read about those potential problems, but cannot rember where I had seen it at the moment. > 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, Yes, that would be an elegant solution. We should make shure that the host:port is IPv6 kompatible (which tends to give a different meaning to ":"). > 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? Looks great, and keeps the ability to "spontaneously" connect to databases not defined in the config files. I'd vote for it. [duplicated warning dialog] > 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. Yes, I have all three clients installed (as I wrote in the first paragraph of my submission), but (had) only 7.4 server. The double dialog got fixed with postgresql-common V34, but now the dialog told me to install "postgresql-plpgsql.so and postgresql-client-plpgsql.so" - I already submitted bug #340470 for this. Btw, it looks as 8.0 was obsoleted, but thankfully not 7.4. I guess the reason is that 8.0 was in debian for a very short time (and thus having a small user base), whereas 7.4 is part of the last stable release. Do you have any pointer to a discussion of this issue? Should we migrate our 7.4 databases to 8.1, skipping 8.0? Thanks a lot, Markus
signature.asc
Description: OpenPGP digital signature