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