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

Re: Forgotten the master password of db

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: thiemo <thiemo(at)gmx(dot)ch>, pgNovice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Forgotten the master password of db
Date: 2002-05-19 18:59:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

> unfortunately I have forgotten the mpassword of the master user of a db. 
> Is there a way to retrieve it using the user who owns the db template1?

No, you can't retrieve it.  You can change it, though, as the postgres user:
ALTER USER the_user WITH PASSWORD 'new_password';

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology 	josh(at)agliodbs(dot)com
    and data management solutions 	(415) 565-7293
   for law firms, small businesses 	 fax 621-2533
    and non-profit organizations. 	San Francisco

In response to


pgsql-novice by date

Next:From: Ron JohnsonDate: 2002-05-19 20:10:30
Subject: Re: Is a randomized default value primary key possible?
Previous:From: thiemoDate: 2002-05-19 18:03:09
Subject: Re: Forgotten the master password of db

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