Re: Login problem

On 17 Dec 2005 at 22:51, John DeSoi wrote:

>
> On Dec 17, 2005, at 11:10 AM, Danjel Jungersen wrote:
>
> > Is there anywhere I can see what databases that are created, and
> > which users are created?
Below are instructions on how to login without a password, and a
point in the direction on how to change it, but I keep getting:
psql: FATAL: User "me" does not exist.

After some tries I got pass the database does not exist ;-)

Is there a user that is allways there, or can I see a list somewhere
?
The "postmaster" is mentioned, so I have tried that "root" and
"Postmaster", no luck...

TIA
Danjel

> > Is there anyway to see the users passwords, or to "reset" them ?
>
>
> Modify your pg_hba.conf file to trust local connections. Then you can
> login with psql without a password. From there you can use the ALTER
> USER command to reset passwords. Don't forget to reverse your
> pg_hba.conf changes when you are done.
>
> http://www.postgresql.org/docs/8.0/interactive/client-
> authentication.html#AUTH-PG-HBA-CONF
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster