> 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.