Re: postgres user account on OSX - Mailing list pgsql-general

From Dave Page
Subject Re: postgres user account on OSX
Date
Msg-id 937d27e10809110029red17fe2y31d7152ee99e5ba0@mail.gmail.com
Whole thread Raw
In response to Re: postgres user account on OSX  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-general
On Thu, Sep 11, 2008 at 3:53 AM, Shane Ambler <pgsql@sheeky.biz> wrote:
> Tom Lane wrote:
>>
>> "Darren Weber" <darren.weber.lists@gmail.com> writes:
>>>
>>> There is a postgres user account on my OSX system.  I'm not clear
>>> about how it was created.  I've installed a binary version of 8.3 in
>>> /Library/PostgreSQL/8.3/ and built another version from source into
>>> /usr/local/pgsql/.  When I login as root and then 'su - postgres' it
>>> takes me to the postgres account and the user directory is at
>>> /opt/local/var/db/postgresql83/.
>>
>>> Can someone explain how this user account was created?
>>
>> I'm guessing that binary package created it for you --- check its docs,
>> or look at the install script if you can.
>>
>
> Quite sure that the EDB binary installer sets /Library/PostgreSQL8 as the
> home path, matching the install location.

/Library/PostgreSQL/8.3 by default, but yes, that is essentially correct.

> The /opt/local/..... home path would indicate that you used macports or
> similar at some stage and the install from there would have created it.
>
> As the postgres user existed the EDB installer would have left it as is.

Correct.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Tommy Gildseth
Date:
Subject: Re: "Stuck" query
Next
From: "Chris Velevitch"
Date:
Subject: declare column update expression