Thread: default password

default password

From
"Mike Hammonds"
Date:
** 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

Re: default password

From
"J. Roeleveld"
Date:
> 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'



Re: default password

From
John Burski
Date:
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




Re: default password

From
newsreader@mediaone.net
Date:
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
>


RE: default password

From
Etienne De Kerckhove
Date:

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

RE: default password

From
patrick.wolf@Aerojet.com (WOLF, PATRICK)
Date:
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