Re: postgres user account on OSX

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: "Shane Ambler" <pgsql(at)sheeky(dot)biz>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Darren Weber" <darren(dot)weber(dot)lists(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgres user account on OSX
Date: 2008-09-11 07:29:56
Message-ID: 937d27e10809110029red17fe2y31d7152ee99e5ba0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 11, 2008 at 3:53 AM, Shane Ambler <pgsql(at)sheeky(dot)biz> wrote:
> Tom Lane wrote:
>>
>> "Darren Weber" <darren(dot)weber(dot)lists(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Velevitch 2008-09-11 07:35:34 declare column update expression
Previous Message Tommy Gildseth 2008-09-11 06:49:22 Re: "Stuck" query