On 16/01/2011 21:39, Steve Litt wrote:
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: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.Thanks Ray, My psql seems a lot different from others. Loook what happened: slitt@mydesk:~$ psql -U postgres -h localhost super Password for user postgres: psql: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres" slitt@mydesk:~$ psql -U postgres -h 127.0.0.1 super Password for user postgres: psql: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres" slitt@mydesk:~$ My postgresql.conf configures the port at 5433 instead of 5432, so I also tried this: slitt@mydesk:~$ psql -U postgres -h localhost -p 5433 super Password for user postgres: psql: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres" slitt@mydesk:~$
Well that's interesting - some instance of PostgreSQL is listening on port 5432, as well as 5433.
However, you're apparently supplying an incorrect password for user "postgres", as per the error message. Your psql is no different to anyone else's; that's a normal error message.
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
