Re: postgresql db account

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
>