On 16/01/2011 20:56, Steve Litt wrote:
Thanks Dmitriy,
It turns out the solution I used was to su to postgres in Linux, and then run
the command psql without arguments, at which time I could have my way with any
object.
More in my responses to you...
On Sunday 16 January 2011 06:21:28 Dmitriy Igrishin wrote:
Hey Steve,
2011/1/16 Steve Litt<slitt@xxxxxxxxxxxxxxxxxxx>
Hi all,
I've somehow messed up something.
psql super
psql's synopsis is
psql [option...] [dbname [username]]
Thus, the call "psql super" connects psql to a database
"super" but since username unspecified it is connected
with current Unix user (which is returned by whois(1)).
So, you should call psql like that
psql super super
slitt@mydesk:~$ psql super super
psql: FATAL: Ident authentication failed for user "super"
slitt@mydesk:~$ psql postgres postgres
psql: FATAL: Ident authentication failed for user "postgres"
slitt@mydesk:~$
If you have configured PG to listen on a TCP/IP port (5432 by default),
you can also do:
psql -U postgres -h localhost super
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
