How do I add new users to PostgreSQL 9.1 on Mac OS X 10.6?
- by Cheng
I am unable to run psql with my normal Mac user account in Terminal session, although I can do it using the postgres service account). When I enter the command psql mydb and type my password, I get the following message:
WARNING: password file "/Users/beh/.pgpass" has group or world access; permissions should be u=rw (0600) or less
But I cannot find .pgpass.
How do I set up and add users to my PostgreSQL 9.1 database on Mac OS X 10.6.8?