I have PostgreSQL 9.4 and 9.5 on the same host with Ubuntu 14.04. My problems are:
- When I run
service postgresql start|stop, both versions start/stop. But I want to control which one to do.
- When I use
psqlto connect to PostgreSQL, it always connects to 9.4. But I want to control which server to do. I know I can connect by different port, 5432 for 9.4 and 5433 for 9.5. But I want to connect by peer auth, that is via Unix socket.
I managed to find these clues for above two questions separately but haven't resolved my problems:
- I find a command
pg_ctlclustermay do the work but I don't know how to specify correct parameters, say, cluster-name. How could I figure it out? Or you have some other way?
- Unix socket can be configured by
unix_socket_directories = '/var/run/postgresql'. But both versions have the same config dir, within which there're subdirs
9.4-main.pg_stat_tmp 9.4-main.pid 9.5-main.pg_stat_tmp 9.5-main.pidfor different versions. When I do
psql -h /var/run/postgresql, it just connects to the old 9.4 version.
Could anyone help? Thanks!