Re: running postgresql

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@myemma.com
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