Re: Alternate locations of DB's

The problem is that you can't share the same port for different instance of
postmaster.
Start postmaster with the option -p can help. so,

$ nohup postmaster -i -p 5432 -D /home/user/database &
$ nohup postmaster -i -p 5433 -D /home/user1/database &
$ nohup postmaster -i -p 5434 -D /home/user2/database &

should work. At least work for my linux machine.

And connect to the instances using psql as:

$ psql -p {port_no}

Kiyo

""Brian C. Doyle"" <brian(at)jbbent(dot)com> wrote in message
news:5(dot)0(dot)0(dot)25(dot)2(dot)20001025075020(dot)01c5cd00(at)pop(dot)mindspring(dot)com(dot)(dot)(dot)
> Hello all,
>
> How do I get Postgresql to use independantly seperate db
> locations. Currently I have them under /home/user/database and as long
as
> i get postmaster to run with that same location I am fine but I want to
have
> /home/user/database
> /home/user1/database
> /home/userr2/database
> ect...
>
> But I can only get one instance of the postmaster running at a time .
How
> do i change that if i can!
>
>