On 05/15/2013 06:49 AM, Roger wrote:
> Why is psql attempting login as my Fedora username? 

The psql tool defaults to using the local user for authentication if
none is specified. You should be aware that PostgreSQL is not like MySQL
in regards to authentication. Throw out anything you know about MySQL.

If you need to login with an alternate user you can specify it several ways.

psql userdb user
or
psql -U user userdb

If you need to use passwords you must switch your pg_hba.conf to use
"md5" for the connections that your software will use. For example, if
you needed IPv4 to connect to the database:

psql -h localhost userdb user

You will be prompted for a password.

Michael
-- 
users mailing list
users@lists.fedoraproject.org
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org

Reply via email to