From: Edward W. Rouse <erouse@comsquared.com>
To: pgsql-sql@postgresql.org
Subject: lost password
Date: Tue, 17 Nov 2009 16:20:54 -0500
Message-ID: <00b501ca67cb$d8efd9e0$8acf8da0$@com> (raw)
I have a database that has a "process" user. I need to move the database to
an additional server. When I restore it gave me a "user not found" error. So
I am trying to recreate this user, but no one knows what the password is
supposed to be. The processes connecting to it have encrypted versions of
the password. And what I can find in the database uses md5. Is there some
way to find out or copy over the users password? Trying to find every
process that uses this login will be very time consuming and we are
guaranteed to miss some and generate a lot of frustration and confusion as
processes that always worked cease. Not to mention that some stuff may be
failing for a while before someone catches it.
I was thinking of just taking the md5 from pg_authid:rolpassword and using
it to update the new server. Will this work? Or is there another way to
retrieve a forgotten password?
Edward W. Rouse
Comsquared System, Inc.
770-734-5301
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: erouse@comsquared.com
Subject: Re: lost password
In-Reply-To: <00b501ca67cb$d8efd9e0$8acf8da0$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox