Thread: Cluster in users home

Cluster in users home

From
Russell Shaw
Date:
Hi,
I just installed pgsql on debian. Can i have initdb create
the database cluster in my home directory and have it all
owned by russell instead of postgres?


Re: Cluster in users home

From
Bruno Wolff III
Date:
On Mon, Jan 12, 2004 at 13:14:20 +1100,
  Russell Shaw <rjshaw@iprimus.com.au> wrote:
> Hi,
> I just installed pgsql on debian. Can i have initdb create
> the database cluster in my home directory and have it all
> owned by russell instead of postgres?

This should work. You will need to run the postmaster under that same ID.
You probably need to worry about how you are going to have the postmaster
started when the machine reboots.