Package: postgresql-common Version: 23 Hi Martin,
for the user postgres and switching between clusters I use: psql -p 5432 for my Oldcluster (7.4/5) psql -p 5433 for my Newcluster(8.0) And it works nicely. I appreciate the architecture you made for this very much. However, createlang -p 5433 plpgsql -d NewCluster uses the old version (7.4) of createlang (possibly including its default paths). Since we are upgrading very complex systems, it might be a good idea to implement some automated environment change for the postgres user to maintain both clusters with their dedicated tools. It does brake in all kind of interesting ways when one uses the postgis extension library as postgres on the new cluster: so, in that case one cannot use the old tools on the new cluster. (but that is not an official package yet, so I won't report that as a bug). I realise it conflicts with your architecture that has a default environment for each user (including postgres) however maybe at least postgres should not have a default in this and specify which path they need for a specific cluster... so pg_wrapper could detect that the user is postgres and find out (based on the cluster type) or ask which environment to use. If I missed a feature of pg_wrapper II am sorry to have reported this as a bug... High regards, Floris Sluiter
