Richard Broersma Jr wrote:
>> 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 depends, of course, on how the postgres account was created....
> This is supposed to be more secure, since you only have to worry about your
> root password being cracked.
>
> Regards,
>
> Richard Broersma Jr.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
