Thread: default password
** Reply Requested When Convenient ** What is the default password of the postgres user that gets created after an RPM install on RedHat 6.x? Mike Hammonds, CNE5, MCP-NT Fellon-McCord & Associates, Inc. Office: 502.214-6324 Fax: 502.426.8800 mhammonds@knowledgeinenergy.com
Attachment
> What is the default password of the postgres user that gets created after an RPM install on RedHat 6.x? no useable one, untill you set one using the 'root'
If I understand the question, then I'll have to say that there isn't one (to the best of my knowledge). When I installed I had to become "root" and add the "postgres" user and assign a password to the user. After that I made sure that the postmaster was running, "su-ed" to the postgres user, and then I ran "createuser" to add myself as a database "super-user" (gave myself the ability to create both databases and users). Hope this helps. Regards, Mike Hammonds wrote: > ** Reply Requested When Convenient ** > > What is the default password of the postgres user that gets created after an RPM install on RedHat 6.x? > > Mike Hammonds, CNE5, MCP-NT > Fellon-McCord & Associates, Inc. > Office: 502.214-6324 > Fax: 502.426.8800 > mhammonds@knowledgeinenergy.com > > ------------------------------------------------------------------------ > > Mike Hammonds.vcfName: Mike Hammonds.vcf > Type: Plain Text (text/plain) -- John Burski Chief IT Cook and Bottlewasher 911 Emergency Products, St. Cloud, MN (320) 656 0076
There is no password for that user. If you want to do stuff
as that user do this as a regular use
$ su
$password: <--- enter root password
# su - postgres
$ <--- here you are postgres now
The alternative is to add a password for that user while
you are root but it is not a good idea.
Yet another alternative is compile the package from the
source; whoever, except root, runs initdb becomes
postgres super user and you will have complete control
over how the package is installed etc etc.
The administrator documentation is quite complete and takes
you by hand in compiling and installing.
On Mon, Dec 11, 2000 at 12:53:18PM -0500, Mike Hammonds wrote:
> ** Reply Requested When Convenient **
>
> What is the default password of the postgres user that gets created after an RPM install on RedHat 6.x?
>
> Mike Hammonds, CNE5, MCP-NT
> Fellon-McCord & Associates, Inc.
> Office: 502.214-6324
> Fax: 502.426.8800
> mhammonds@knowledgeinenergy.com
>
> BEGIN:VCARD
> VERSION:2.1
> X-GWTYPE:USER
> FN:Mike Hammonds
> TEL;WORK:x7389
> ORG:;IS
> TEL;PREF;FAX:426-8800
> EMAIL;WORK;PREF;NGW:Mike.Hammonds@knowledgeinenergy.com
> N:Hammonds;Mike
> TITLE:IS MAnager
> X-GWUSERID:mhammonds
> END:VCARD
>
If you are root it shouldn't ask for a password....the user must be postgres though
-----Original Message-----
From: Mike Hammonds [mailto:mhammonds@knowledgeinenergy.com]
Sent: Monday, December 11, 2000 9:53 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] default password
** Reply Requested When Convenient **
What is the default password of the postgres user that gets created after an RPM install on RedHat 6.x?
Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office: 502.214-6324
Fax: 502.426.8800
mhammonds@knowledgeinenergy.com
The password (on my 6.1 system) is set to !! in the /etc/shadow file. This means you can't logon or su (from a normal user account) to the postgres user without first changing the password by running "passwd postgres" as root. Pat -----Original Message----- From: Etienne De Kerckhove [mailto:E3@moderngroove.com] Sent: Monday, December 11, 2000 12:28 PM To: 'pgsql-novice@postgresql.org' Subject: RE: [NOVICE] default password If you are root it shouldn't ask for a password....the user must be postgres though -----Original Message----- From: Mike Hammonds [ mailto:mhammonds@knowledgeinenergy.com <mailto:mhammonds@knowledgeinenergy.com> ] Sent: Monday, December 11, 2000 9:53 AM To: pgsql-novice@postgresql.org Subject: [NOVICE] default password ** Reply Requested When Convenient ** What is the default password of the postgres user that gets created after an RPM install on RedHat 6.x? Mike Hammonds, CNE5, MCP-NT Fellon-McCord & Associates, Inc. Office: 502.214-6324 Fax: 502.426.8800 mhammonds@knowledgeinenergy.com