Re: Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6

From: Basil Bourque <basil(dot)list(at)me(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6
Date: 2011-10-25 19:31:16
Message-ID: C31024C7-9390-4827-A42E-9F0FBD063139@me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> By default the postgres user's group is 'daemon' on my Mac. This is probably true for you as well. Change occurrences of 'postgres:postgres' in your chown commands to 'postgres:daemon'.

For what it's worth, here's the user groups and permissions I see on my Mac. I used the installer from EnterpriseDB.com for my Snow Leopard MacBook.

Typing the 'id' command-line tool:
id postgres

Renders this:
uid=502(postgres) gid=1(daemon) groups=1(daemon),403(com.apple.sharepoint.group.2),61(localaccounts),12(everyone),402(com.apple.sharepoint.group.1)

So, "daemon" is the primary group, along with 4 other groups.

/Library/PostgreSQL
+--------------+-----------------+
| system | Read & Write |
+--------------+-----------------+
| admin | Read only |
+--------------+-----------------+
| everyone | Read only |
+--------------+-----------------+

/Library/PostgreSQL/9.0
/Library/PostgreSQL/9.1
/Library/PostgreSQL/9.1/bin
/Library/PostgreSQL/9.1/lib
/Library/PostgreSQL/9.1/pgAdmin3.app
+--------------+-----------------+
| system | Read & Write |
+--------------+-----------------+
| daemon | Read only |
+--------------+-----------------+
| everyone | Read only |
+--------------+-----------------+

/Library/PostgreSQL/9.1/data
+--------------+-----------------+
| postgres | Read & Write |
+--------------+-----------------+
| everyone | No Access |
+--------------+-----------------+

--Basil Bourque

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2011-10-25 19:32:47 Saving score of 3 players into a table
Previous Message Tom Lane 2011-10-25 16:38:39 Re: strange java query behaviour