Thanks. I wasn't sure that I should do that since I didn't change those permissions since I hadn't done anything with it. There is a new user who is taking over admin of this machine, so I'll have to ask if the did anything to affect this.

Barry

On Feb 16, 2006, at 11:30 AM, Jeff Frost wrote:

On Thu, 16 Feb 2006, Barry Moore wrote:

So with my minimal system admin skills I'm guessing that '/ tmp/.s.PGSQL.5432' is lock file where the system puts a lock on port 5432 for postmaster to listen, but the pg_ctl and postmaster commands can't create that file because /tmp is writeable only by root (drwxr-xr-x 11 root root 4096 Feb 16 11:06 tmp). Of course I can't start the postmaster as root, so I'm a bit perplexed as to what to do, and why I never had this problem before.

You need to change the permissions on /tmp. I'd be curious to know how it got this way. Has anyone done chmods on /tmp? It should be 1777/drwxrwxrwt, so a chmod 1777 /tmp should fix it for you.


--
Jeff Frost, Owner       <[EMAIL PROTECTED]>
Frost Consulting, LLC   http://www.frostconsultingllc.com/
Phone: 650-780-7908     FAX: 650-649-1954


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

              http://www.postgresql.org/docs/faq

Reply via email to