Skip site navigation (1) Skip section navigation (2)

Re: resetting superuser password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: acuselton(at)lbl(dot)gov
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: resetting superuser password
Date: 2007-08-13 17:42:13
Message-ID: 28150.1187026933@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Andrew C. Uselton" <acuselton(at)lbl(dot)gov> writes:
>   We do not know the superuser (postgres) password to our database 
> cluster.  The auth configuration (pg_hba.conf) has the only auth method 
> set to:

> Type    db    user    method    param
> local   all      all      md5         sameuser

> I have root access to the machine, but I don't see how to reset the 
> superuser password. The thing I tried was to briefly replace the above 
> auth configuration with

> local   all      all      trust

> and then reset the password (after the required SIGHUP).  The password 
> update apparently succeeded, but when I put the md5 auth method back in 
> place I still did not have access.

At that level of detail, it should have worked, so you are omitting
something important.  Please show exactly what you did, what messages
you got, etc.

One point is that AFAIR, md5 auth method doesn't take a parameter,
so that "sameuser" is at best noise and might be treated as a syntax
error.  Do the failures you get suggest anything about incorrect
pg_hba.conf file?

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Lonni J FriedmanDate: 2007-08-13 19:49:49
Subject: Re: analyzing query results
Previous:From: Andrew C. UseltonDate: 2007-08-13 17:17:39
Subject: resetting superuser password

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group