[GENERAL] starting personal postmaster

[Stefan Karrmann]

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?

I tried:
$ mkdir ~/pgdata
$ initdb -D ~/pgdata
$ postmaster -D ~/pgdata

Please CC answers to me [EMAIL PROTECTED].

Thanks,
-- 
Stefan Karrmann

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] starting personal postmaster

[Peter Eisentraut]

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   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly