Search Postgresql Archives

Re: postgres user account on OSX

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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@xxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux