Search Postgresql Archives

Re: Why can't I change a password <SOLVED>

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux