Hi, I am trying to install multiple PostgresSQL servers in my computer. I am running Kubuntu 6.06 LTS and I am trying to install PostgreSQL-7.4 and PostgreSQL-8.1 at the same time.
I've already changed the port configuration in /etc/postgres/7.4/main/postgresql.conf to 4432 and I am able to execute the psql of both versions in /usr/lib/postgres/[version]/bin/psql, but I want to create different users for the different versions like postgres81 will allways connect to PostgreSQL-8.1 and postgres74 will allways connecet to PostgresSQL-74.
I believe that I need to change the configuration in /etc/postgres-common/user_clusters and use pg_wrapper, but I don't know how to do that.
Can anyone help me?
Thanks,
Komyg
I've already changed the port configuration in /etc/postgres/7.4/main/postgresql.conf to 4432 and I am able to execute the psql of both versions in /usr/lib/postgres/[version]/bin/psql, but I want to create different users for the different versions like postgres81 will allways connect to PostgreSQL-8.1 and postgres74 will allways connecet to PostgresSQL-74.
I believe that I need to change the configuration in /etc/postgres-common/user_clusters and use pg_wrapper, but I don't know how to do that.
Can anyone help me?
Thanks,
Komyg
