28 character limit for password on new Portal

Question

When creating a new Portal, the initial administrator password is limited to 28 characters. However, after the site is set up, there are no such restrictions when changing the password. Is there a specific reason for this initial limit? I've reproduced this in 11.1, 11.2, and 11.3.

TimoT · Answer

Hi @waterschapVallei_en_Veluwe

You're right - changing the Portal PSA password afterwards does not change the internal postgres database admin password. However, going to portaladmin > system > database > update admin account will update the database admin credentials.

I have confirmed this updates successfully by running select queries against the Portal postgres database. I've also confirmed updating these credentials post-install can exceed 28 characters.

waterschapVallei_en_Veluwe · Answer

I have heard that the internal PostGreSQL password does not actually change when you change the Portal password afterwards - hence why you are able to exceed the 28-character limit. Somebody better versed in the internals of Enterprise can probably give  a better answer.

TimoT · Answer

Thanks @JakeSkinner.

When I change the Portal PSA, I've also made it a habit to change this underlying portal postgres database admin password to match.

After the Portal site is setup, I'm able to exceed the initial 28 character limit for this database password too.