Hello.
I would like to run 2
instances of postgresql with 2 different data-directories: dir-a en
dir-b.
Looking trough the archives I
came to the next setup:
I created this 2 different
directories and 2 users each with a different PGDATA(dir-a and dir-b) in their
.profile
Using this 2 users i did
twice initdb and createdb xyz with the first user.
in postgresql.conf of the
second directory I changed the port to 5433 and also entered this port
in /etc/services and started the second
postmaster, ps -f shows it is
running.
If I now want to create the
same database xyz in the second directory using the second
user,
the database is already
there!
What am I
missing?
Many
thanks
Henk
Sander