Re: postgres user account on OSX

Hi Shane,

I'm trying to untangle some postgresql issues on OSX. I'm now using a
macport installation for postgresql 8.3.4 and I'm using my own custom
Portfile to configure the installation (hardly changed from the main
Portfile, really). Anyhow, the macport install creates a lauchdeamon config
that uses this startup call below. When I test it directly, it's failing:

sudo su postgres -c "/opt/local/lib/postgresql83/bin/pg_ctl -D
${POSTGRESQL83DATA:=/opt/local/var/db/postgresql83/defaultdb} start -w -l
/opt/local/var/log/postgresql83/postgres.log -o \"-i -l\""

waiting for server to start...2008-10-13 19:50:21.734 pg_ctl[43992:617]
CFPreferences: user home directory at /Library/PostgreSQL/8.3 is
unavailable. User domains will be volatile.
............................................................could not start
server

Have you seen anything like this before? I have no idea what this means:
"CFPreferences: user home directory at /Library/PostgreSQL/8.3 is
unavailable"
It looks like a hangover from using a binary installer and I have no idea
how to get rid of that "CFPreference".

Any tips much appreciated ;-)

Thanks, Darren

On Fri, Sep 12, 2008 at 8:52 AM, Shane Ambler <pgsql(at)sheeky(dot)biz> wrote:

> Darren Weber wrote:
>
> If you want a GUI to alter the home location of the existing user
>>> account run NetInfo Manager which is in /Applications/Utilities
>>>
>>
>>
>> I have OSX Server. This user account doesn't appear in the usual System
>> Preferences > Accounts. I did find it eventually under Applications >
>> Server > Workgroup Manager, when I selected a "local" domain to administer.
>>
>>
> That would be a 10.5 machine.
>
> Seems Apple has dropped netinfo manager in 10.5 and replacing it with
> Directory and Directory Utility. (Data storage has changed too)
>
> Workgroup Manager is a OSX Server app that isn't a standard part of the
> client installs (but can be added by installing the server admin tools)
> and (pretty sure) it will only connect to an OSX Server to administer it
> - not useful for adjusting a client machine.
> You could call it a more user friendly form of netinfo manager (edits
> the same data)
>
>
>
> System Preferences > Accounts will only list accounts normally created
> within the Accounts Tab (I believe the criteria is userid's > 500) which
> makes it easy for the novice user as they don't get to see all the
> system accounts like mailman, nobody, postmaster and so on, just the
> ones they have manually created.
>
>
> --
>
> Shane Ambler
> pgSQL (at) Sheeky (dot) Biz
>
> Get Sheeky @ http://Sheeky.Biz
>