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