Skip site navigation (1) Skip section navigation (2)

Re: cannot connect using terminal nor pgaccess

From: Dronamraju Rajesh <drajesh80(at)yahoo(dot)com>
To: Jaume Teixi <teixi(at)6tems(dot)com>, psql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: cannot connect using terminal nor pgaccess
Date: 2001-05-22 06:50:12
Message-ID: 20010522065012.4338.qmail@web9601.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
also try using -i option along with other options.
else all seems to be fine

regards,
Rajesh.

--- Jaume Teixi <teixi(at)6tems(dot)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(at)postgresql(dot)org)


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

In response to

pgsql-admin by date

Next:From: Andre SchubertDate: 2001-05-22 07:11:18
Subject: Postgres 7.0.3 Dying
Previous:From: Peter EisentrautDate: 2001-05-21 17:13:00
Subject: Re: cannot connect using terminal nor pgaccess

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group