Cluster DNS registration errors

Use some PS commands:
to force register A records:
Get-ClusterResource | ? resourcetype -like 'Network Name' | Update-ClusterNetworkNameResource
Get-ClusterResource -Name "Cluster Name" | Update-ClusterNetworkNameResource
 
 To force register PTR records - restart instance!
Set PTR registration setting to all instances
Get-ClusterResource | where-object {$_.ResourceType.name -eq "Network Name"} | Set-
ClusterParameter -Name PublishPTRRecords -Value 1
 
 Check PTR registration settings:
Get-ClusterResource | where-object {$_.ResourceType.name -eq "Network Name"} | get-
ClusterParameter
 
Get-ClusterResource -Name "Cluster Name" | get-ClusterParameter

add Authenticated Users to full access into re

Recover/reset PostgreSQL password (Windows)

1) edit pg_hba.conf to change all local connections from md5 to trust.

# IPv4 local connections:
host    all             all      127.0.0.1/32            trust
# IPv6 local connections:
host    all             all      ::1/128                 trust 2) restart PostgreSQL service

 3) connect to PosgreSQL using any tool:

psql -U postgres

4) change password

postgres=# ALTER USER postgres WITH PASSWORD 'new_password';
5) restore pg_hba.conf and restart PostgreSQL service