1) Performed full install (10.4.8 MacBook Pro)
2) Created "movies" db using GUI under default 'postgres' userId with all default values. Shows up in Query Tool GUI.
3) Issued "PostgreQUL Terminal" AppleScript
4) Issues "psql" commmand. Response <<my comments>>
Last login: Thu Apr 5 09:25:30 on ttyp1
Welcome to Darwin!
users-computer:~ user$ export PATH=/Library/PostgreSQL8/bin:$PATH;export MANPATH=/Library/PostgreSQL8/share/man:$MANPATH
users-computer:~ user$ psql -d movies
psql: FATAL: role "user" does not exist
users-computer:~ user$ su -l postgres
Password:<<default blank>>
users-computer:~ user$ psql -d movies
psql: FATAL: role "user" does not exist
users-computer:~ user$
Did I miss something in the setup?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1) Performed full install (10.4.8 MacBook Pro)
2) Created "movies" db using GUI under default 'postgres' userId with all default values. Shows up in Query Tool GUI.
3) Issued "PostgreQUL Terminal" AppleScript
4) Issues "psql" commmand. Response <<my comments>>
Last login: Thu Apr 5 09:25:30 on ttyp1
Welcome to Darwin!
users-computer:~ user$ export PATH=/Library/PostgreSQL8/bin:$PATH;export MANPATH=/Library/PostgreSQL8/share/man:$MANPATH
users-computer:~ user$ psql -d movies
psql: FATAL: role "user" does not exist
users-computer:~ user$ su -l postgres
Password:<<default blank>>
users-computer:~ user$ psql -d movies
psql: FATAL: role "user" does not exist
users-computer:~ user$
Did I miss something in the setup?
Work! Thanks for your quick reply!
You don't have a user for yourself, which is the user the default is attempting to use at the command line.
You can use psql -U postgres movies to login as postgres user, or you can create a user for your user name and use it. Either should work.