On Nov 5, 2007, at 12:36 PM, Charles wrote:
I am running Gutsy (Ubuntu 7.10) and new to Postgresql. I followed the
direction at https://help.ubuntu.com/community/PostgreSQL. I executed
the following commands:
sudo -u postgres createuser -D -A -P myuser
sudo -u postgres createdb -O myuser mydb
dagon@DagonUX32:~$ psql mydb
and received the following error message:
psql: FATAL: role "dagon" does not exist.
Apparently Postgresql gets confused with my login name. Is this a
Postgresql problem or a Gutsy problem?
How do I establish a "role" that will let me setup different
databases?
Is the name of the db user you created really myuser? If so you need
to specify the user to connect as to psql, otherwise it defaults to
your current system username:
psql -U myuser mydb
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
