From: | "Danjel Jungersen" <danjel(at)jungersen(dot)dk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Login problem |
Date: | 2005-12-18 10:44:00 |
Message-ID: | 43A54B80.14983.556A85@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | stig erikson | 2005-12-18 11:44:01 | how do i add a number of days to now()? |
Previous Message | John DeSoi | 2005-12-18 03:51:55 | Re: Login problem |