> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general