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: 200205191159.57852.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novice
thiemo,

> 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

Responses

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-2014 The PostgreSQL Global Development Group