From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Ray Stell <stellr(at)cns(dot)vt(dot)edu>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: postgresql db account |
Date: | 2006-10-04 22:27:10 |
Message-ID: | 20061004222711.28687.qmail@web31804.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> What is the default pw for the postgresql db account?
> Is it a correct management practice to change this pw?
>
> template1=# select * from pg_user;
> usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
> ------------+----------+-------------+----------+-----------+----------+----------+-----------
> postgresql | 10 | t | t | t | ******** | |
My understanding is that the "postgres" account both OS and DB do not have a password.
On a *nix OS, postgres can only be su - from a privileged root account. This way it can not be
directly logged into. This is supposed to be more secure, since you only have to worry about your
root password being cracked.
Regards,
Richard Broersma Jr.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-10-04 22:38:04 | Re: pg_ctl -D? |
Previous Message | Ray Stell | 2006-10-04 21:18:00 | postgresql db account |