Thread: Problem starting the server with Mac OSX

Problem starting the server with Mac OSX

From
Myshkin LeVine
Date:
Hi,
    I have a problem starting the server on Mac OSX 10.3.9. I compiled
v8.2.5 from source. The compilation, regression testing, and
installation all went smoothly with no errors. I installed PostgreSQL
in the default location and created a new user account named postgres.
I ran initdb which ended successfully. When I try to start the server I
get this error message: 'FATAL:  could not open lock file
"/tmp/.s.PGSQL.5432.lock": Permission denied' I have checked the
mailing-list archives and I see others have had the same problem, but
no solution for my case. The file ".s.PGSQL.5432.lock" does not exist
already in the /tmp directory. The server will start however in
single-user mode using the --single switch to the postgres command,
giving me this: "PostgreSQL stand-alone backend 8.2.5
backend>" Can anyone tell me what I'm doing wrong, or how to fix this?
                Sincerely,
                            Myshkin LeVine


Re: Problem starting the server with Mac OSX

From
"Scott Marlowe"
Date:
On 11/2/07, Myshkin LeVine <myshlev@verizon.net> wrote:
> Hi,
>         I have a problem starting the server on Mac OSX 10.3.9. I compiled
> v8.2.5 from source. The compilation, regression testing, and
> installation all went smoothly with no errors. I installed PostgreSQL
> in the default location and created a new user account named postgres.
> I ran initdb which ended successfully. When I try to start the server I
> get this error message: 'FATAL:  could not open lock file
> "/tmp/.s.PGSQL.5432.lock": Permission denied' I have checked the
> mailing-list archives and I see others have had the same problem, but
> no solution for my case. The file ".s.PGSQL.5432.lock" does not exist
> already in the /tmp directory. The server will start however in
> single-user mode using the --single switch to the postgres command,
> giving me this: "PostgreSQL stand-alone backend 8.2.5
> backend>" Can anyone tell me what I'm doing wrong, or how to fix this?

What's the permissions on .tmp?

Re: Problem starting the server with Mac OSX

From
Myshkin LeVine
Date:
    That was the problem, the permissions on /tmp were 0700 with my user
acct. as owner and staff as group. I changed the permissions to 0777
and now the server will start up okay.

    Thank you for your help Scott.


On Nov 02, 2007, at 10:05 PM, Scott Marlowe wrote:

> On 11/2/07, Myshkin LeVine <myshlev@verizon.net> wrote:
>> Hi,
>>         I have a problem starting the server on Mac OSX 10.3.9. I
>> compiled
>> v8.2.5 from source. The compilation, regression testing, and
>> installation all went smoothly with no errors. I installed PostgreSQL
>> in the default location and created a new user account named postgres.
>> I ran initdb which ended successfully. When I try to start the server
>> I
>> get this error message: 'FATAL:  could not open lock file
>> "/tmp/.s.PGSQL.5432.lock": Permission denied' I have checked the
>> mailing-list archives and I see others have had the same problem, but
>> no solution for my case. The file ".s.PGSQL.5432.lock" does not exist
>> already in the /tmp directory. The server will start however in
>> single-user mode using the --single switch to the postgres command,
>> giving me this: "PostgreSQL stand-alone backend 8.2.5
>> backend>" Can anyone tell me what I'm doing wrong, or how to fix this?
>
> What's the permissions on .tmp?
>


Re: Problem starting the server with Mac OSX

From
Myshkin LeVine
Date:
Hi Mathias,
            Actually, I did change the /tmp permissions to 1777 after I sent the
last post, but thank you for confirming that that was the right thing
to do. As far as folder ownership, I am not running Mac OSX Server, I
am running the client version and I am the only user. I installed
PostgreSQL to act as a database for just one program, GNU Backgammon.
Is root/wheel the correct owner/group for my system as well, or am I
okay just leaving it as my-user-id/staff?
                        Myshkin


On Nov 03, 2007, at 8:49 AM, Mathias Seiler wrote:

> Consider changing the Permissions to 1777, not 0777. This prevents
> other processes deleting files which weren't created by them.
>
> By the way: The default in Mac OS X Server is 1777 (or drwxrwxrwt) and
> the folder belongs to root:wheel.
>
> Go here for further details:
> http://developer.apple.com/DOCUMENTATION/Darwin/Reference/ManPages/
> man8/sticky.8.html#//apple_ref/doc/man/8/sticky
>
>
> On 03/11/2007, Myshkin LeVine <myshlev@verizon.net> wrote:
>> acct. as owner and staff as group. I changed the permissions to 0777
>> and now the server will start up okay.
>>
>>         Thank you for your help Scott.
>>
>>
>> On Nov 02, 2007, at 10:05 PM, Scott Marlowe wrote:
>>
>> > On 11/2/07, Myshkin LeVine <myshlev@verizon.net> wrote:
>> >> Hi,
>> >>         I have a problem starting the server on Mac OSX 10.3.9. I
>> >> compiled
>> >> v8.2.5 from source. The compilation, regression testing, and
>> >> installation all went smoothly with no errors. I installed
>> PostgreSQL
>> >> in the default location and created a new user account named
>> postgres.
>> >> I ran initdb which ended successfully. When I try to start the
>> server
>> >> I
>> >> get this error message: 'FATAL:  could not open lock file
>> >> "/tmp/.s.PGSQL.5432.lock": Permission denied' I have checked the
>> >> mailing-list archives and I see others have had the same problem,
>> but
>> >> no solution for my case. The file ".s.PGSQL.5432.lock" does not
>> exist
>> >> already in the /tmp directory. The server will start however in
>> >> single-user mode using the --single switch to the postgres command,
>> >> giving me this: "PostgreSQL stand-alone backend 8.2.5
>> >> backend>" Can anyone tell me what I'm doing wrong, or how to fix
>> this?
>> >
>> > What's the permissions on .tmp?
>> >
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>>                http://archives.postgresql.org/