Re: starting personal postmaster - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: starting personal postmaster
Date
Msg-id Pine.LNX.4.30.0104271717270.758-100000@peter.localdomain
Whole thread Raw
In response to starting personal postmaster  (Stefan Karrmann <sk@mathematik.uni-ulm.de>)
List pgsql-general
Stefan Karrmann writes:

> How can I start a personal postmaster, e.g. the postmaster should
> manage a database cluster in ~/pgdata/.
>
> I'm using the Debian package of postgresql (7.0.3) and it want's to create
> a socket at /var/run/postgres/.s.PORT.sock (or something similiar).
> As I am not user postgres I dont have the permission to do this.
> This seems to be the only problem to start postgres on an user account.
> Is this Debian specific? Are there methods to avoid this?

Yes.  Uninstall the package, install from source.

Alternative 1: Change the permissions on /var/run/postgres.

Alternative 2: Use the postmaster -k option, but your client programs are
not going to see that.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: SQL Where LIKE - Range it!
Next
From: Jelle Ouwerkerk
Date:
Subject: rotating log files