Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the default password for the user postgres.. - Mailing list pgsql-admin

From Oliver Elphick
Subject Re: What is the default password for the user postgres..
Date
Msg-id 200110152206.f9FM6vPo029996@linda.lfix.co.uk
Whole thread Raw
In response to What is the default password for the user postgres..  ("Moovarkku Mudhalvan" <mudhalvan@vasunas.com>)
List pgsql-admin
Tree view 
"Moovarkku Mudhalvan" wrote:
  >Hi Friends,
  >
  >    Greetings. What is the default password for the user postgres.. Let me
  >change the password.. If i change the password.. Does it make any problem in
  >my datas...

There is no password by default; create one with ALTER USER.

Passwords do not take effect unless pg_hba.conf is set up to use them.  If
it is, and you have not assigned a password to postgres, you will not be
able to connect as postgres.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "If ye love me, keep my commandments."       John 14:15

pgsql-admin by date:

Previous
From: Brett Schwarz
Date:
Subject: Re: Please help - tks
Next
From: Tom Lane
Date:
Subject: Re: psql \l problem