Re: starting personal postmaster

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