Resetting local Postgres account in windows

book

Article ID: 224990

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

I need to reset the local windows postgres account that is created as the super user during apm install. I am following this article: https://knowledge.broadcom.com/external/article?articleId=12881

My question is about the local account. Will reset the password in Postgres

Do I reset the local windows account or reset it in windows? Resetting in in windows prompts a message that says all data will be deleted.

Environment

Release : 10.7.0

Component : Introscope

Resolution

Please review the details here -

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/installing/apm-installation/install-and-configure-the-apm-database.html#concept.dita_a76880049931c2879d1a17908c088e72758b7c34_InstallaPostgreSQLAPMDatabase

APM Database on PostgreSQL User Accounts

Based on this information, these are two separate accounts.

You will need to change at both location.

One mentioned in the TechDoc that you referenced, and also at Windows user level.

Changing the password won't result in actual data loss as in deleted, but loss as in not accessible.  

Changing the password for the "postgres" user would involve updating the password for its Windows user account "postgres" and for the postgresql db administration.  As a precaution, the user may want to back up their postgressql db first before trying out the steps for their specific Postgresql version.