471,066 Members | 1,254 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

postgres start error

Im getting this error when trying to start postgres:

FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock":
Permission denied

im running under an unprivileged user, and have set up pgsql in a
different place on my hard drive then the normal one. The user does not
have rights to /tmp, how can i set this up so the tmp file are written
into a place where the permissions are ok?

Alex
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
1 2741
Alexander Cohen <al**@toomuchspace.com> writes:
Im getting this error when trying to start postgres:
FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock":
Permission denied im running under an unprivileged user, and have set up pgsql in a
different place on my hard drive then the normal one. The user does not
have rights to /tmp, how can i set this up so the tmp file are written
into a place where the permissions are ok?


My recommendation is to fix the brain-dead permissions on /tmp.
*All* Unix programs expect to be able to write in /tmp ... you are
eventually going to decide that that wasn't a good idea, so why not
now?

It is possible to relocate the socket (in recent PG releases) but it's a
pretty serious pain in the neck, since both the postmaster and the
clients have to be told about the nondefault location. See
unix_socket_directory on the postmaster side. I forget how you tell the
clients about it, but the libpq documentation will tell you. (It's also
possible to configure this at build time in pg_config_manual.h, which
would be a better answer if you're really intent on doing it.)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Lynn.Tilby | last post: by
reply views Thread by phil campaigne | last post: by
13 posts views Thread by Nagib Abi Fadel | last post: by
6 posts views Thread by Prabu Subroto | last post: by
reply views Thread by Egyd Csaba | last post: by
3 posts views Thread by Josh Close | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.