Re: cannot connect using terminal nor pgaccess

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/