also try using -i option along with other options.
else all seems to be fine
regards,
Rajesh.
--- Jaume Teixi <teixi@6tems.com> wrote:
> $ psql -d template1 -U postgres
> psql: Peer authentication failed for user 'postgres'
>
>
> $ psql -d template1 -U postgres -h localhost -p 5432
> psql: IDENT authentication failed for user
> 'postgres'
>
> $ grep -v ^# /etc/postgresql/pg_hba.conf | grep -i
> sameuser
> local all
> peer sameuser
> host all 127.0.0.1 255.255.255.0
> ident sameuser
>
> $ su - postgres -- psql template1
> Password:
> Welcome to psql, the PostgreSQL interactive
> terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute
> query
> \q to quit
>
> template1=# select postgres from pg_user;
> usename | usesysid | usecreatedb | usetrace |
> usesuper | usecatupd |
> passwd | valuntil
>
-------------+----------+-------------+----------+----------+-----------+----------+----------
> postgres | 31 | t | t | t
> | t |
> ******** |
>
>
> what I am missing in this case ?
>
> thanks!
>
> --
> Jaume Teixi
> CTO
> 6TEMS - Ducform, SA
> http://www.6tems.com
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/