Forgotten "Admin" password

[Gokiwi64]

How do I reset the Admin password ? - I have tried several suggested ways but they all fail with the same message

postgres=# use zabbix;
ERROR: syntax error at or near "use"
LINE 1: use zabbix;


There is obviously no "use" option but cannot find from anywhere what the equivalent is.

Can someone help please ?

Regards

[markfree]

Please, check if this discussion helps you out.
https://stackoverflow.com/questions/...-in-postgresql

[Gokiwi64]

Hi - Thanks for the fast response - I have now decided to scrap Linux completely and use a Windows based O/S and NMS