How do I add new users to PostgreSQL 9.1 on Mac OS X 10.6?

Posted by Cheng on Super User See other posts from Super User or by Cheng
Published on 2012-09-07T21:41:43Z Indexed on 2012/09/13 21:40 UTC
Read the original article Hit count: 273

Filed under:

osx-snow-leopard

|

user-accounts

|

postgresql

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?

© Super User or respective owner

Related posts about osx-snow-leopard

Macports Apache not starting at Mac osx snow leopard boot

as seen on Server Fault - Search for 'Server Fault'
Macports Apache2 not starting at Mac Osx snow leopard boot. I've done the launchctl load command, the symlinks point to my /opt/local//etc/LaunchDaemeons/org.macports.apache2/org.macports.apache2.plist, but it never starts. I can start it manually, works fine after that. Just wont load on startup… >>> More
Unable to enable FTP access of Mac OSX Snow Leopard

as seen on Super User - Search for 'Super User'
When I try to enable the FTP service in the preferences (File Sharing-Options-Share Files and Folders Using FTP) the check box enables and then disables again. The console is giving me the message : 16/04/2010 12:14:20 com.apple.coreservicesd[51] sh: launchctl: command not found This indicates… >>> More
Macports Apache not starting at Mac osx snow leopard boot

as seen on Super User - Search for 'Super User'
Macports Apache2 not starting at Mac Osx snow leopard boot. I've done the launchctl load command, the symlinks point to my /opt/local//etc/LaunchDaemeons/org.macports.apache2/org.macports.apache2.plist, but it never starts. I can start it manually, works fine after that. Just wont load on startup… >>> More
osx snow leopard freezes

as seen on Super User - Search for 'Super User'
Hi I got this error: Timexxxx In 'CFPasteboardCopyData', file /SourceCache/CF/CF-550.13/AppServices.subproj/CFPasteboard.c, line 1951, during lock, spin lock 0x15457a0c8 has value 0xf0000000, which is neither locked nor unlocked. The memory has been smashed. My Mac freezes except the mouse and… >>> More
OSX Snow Leopard hangs after login

as seen on Super User - Search for 'Super User'
After restoring from backup following filesystem corruption my user account hangs after login (After entering my password the login window disappears and all I get is the background and a mouse pointer, no spinning wheel of death etc ..) I can login as a different user and then logout and login as… >>> More

Related posts about user-accounts

Prevent Windows 7 User Accounts from accessing files in other User Accounts

as seen on Super User - Search for 'Super User'
I'm trying to set up another User Account on my Windows 7 Professional laptop for use by another person. I do not want that person to have access to any of the files in my User Account on the same machine. This machine has a single hard disk formatted with NTFS. User accounts data is stored in the… >>> More
JPA entities -- org.hibernate.TypeMismatchException

as seen on Stack Overflow - Search for 'Stack Overflow'
Environment: JDK 1.6, JEE5 Hibernate Core 3.3.1.GA, Hibernate Annotations 3.4.0.GA DB:Informix Used reverse engineering to create my persistence entities from db schema [NB:This is a schema in work i cannot change] Getting exception when selecting list of basic_auth_accounts org.hibernate.TypeMismatchException:… >>> More
List of Hidden / Virtual Windows User Accounts

as seen on Super User - Search for 'Super User'
I’m trying to find a way to get a comprehensive list of user accounts on a Windows 7 system, including hidden ones. The User Accounts dialog (>control userpasswords2) only shows the normal user accounts, and even the Local User and Groups editor only shows normal user accounts and standard hidden/disabled… >>> More
Creating Limited User Accounts on Ubuntu Server

as seen on Server Fault - Search for 'Server Fault'
Using Ubuntu server, I need to create some user accounts that have the following limitations: (1) User may only view and manipulate files in their home directory. (2) User may only execute commands related to rsync and sftp. I want users to be able to backup files using rsync, and I want them to… >>> More
Active Directory using Samba/Open LDAP for user accounts

as seen on Server Fault - Search for 'Server Fault'
I know this is the wrong way round... but Is it possible to use AD in front of Samba for our PC clients, so that the user accounts are in Samba/Open LDAP. Managing our fleet of Windows PC's is becoming more and more difficult with just Samba v3 - until Samba v4 comes along, it would be great if… >>> More