Hello,
I'm setting up a second instance on a server. The instance versions are 8.3.5 (original instance) and 9.1.3 (the new instance I'm attempting to set up).
I believe I have followed the steps in setting up a second instance faithfully. The new instance starts up, but I'm seeing that when I list the 9.1.3 databases, the 8.3.5 databases are shown.
As the _pgsql user I run '/usr/local/postgresql/pgsql-9.1.3/bin/psql -l' and I get a listing of databases from the 8.3.5 instance (with the 'Access privileges' column added).
I believe this can't be right and I think I've done something wrong.
The settings I've used for the 9.1.3 instance are:
The configuration during compile used was:
./configure --prefix=/usr/local/postgresql/pgsql-9.1.3
(For 8.3.5 I used the default prefix, /usr/local/pgsql)
In /usr/local/postgresql/pgsql-9.1.3/data/postgresql.conf
port = 5433
(The 8.3.5 port is the default, 5432)