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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Andre Schubert | 2001-05-22 07:11:18 | Postgres 7.0.3 Dying |
Previous Message | Peter Eisentraut | 2001-05-21 17:13:00 | Re: cannot connect using terminal nor pgaccess |