Problem with postgresql configuration on Fedora 18

[Michael Cronenworth]

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