From: Tom Lane <tgl@sss.pgh.pa.us>
To: Albert Gostick <amgostick@navdata.ca>
cc: pgsql-novice@lists.postgresql.org
Subject: Re: Implications of resetting Postgres service in Windows
In-reply-to: <1a9e822d9817f26ad376c8cd39f85c88@navdata.ca>
References: <1a9e822d9817f26ad376c8cd39f85c88@navdata.ca>
Comments: In-reply-to Albert Gostick <amgostick@navdata.ca>
	message dated "Tue, 01 Sep 2020 13:23:33 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <141593.1598982976.1@sss.pgh.pa.us>
Date: Tue, 01 Sep 2020 13:56:16 -0400
Message-ID: <141594.1598982976@sss.pgh.pa.us>
Precedence: bulk

Albert Gostick <amgostick@navdata.ca> writes:
> We have Postgres 9.4 installed on Win2012.  It was installed by an
> outside contractor years ago. 
> I was asked to review and change all the passwords used in Postgres
> (along with another product) and noticed that on this server, the
> postgres service "postgresql-x64-9.4" runs under the "Network Service"
> account and it has a password associated with it. 
> I sort of think I can guess the password used by the developer, but I
> cannot be sure. 

> If I change this password, what are the implications: 
> a) nothing - the password is only used to secure the service running 
> or 
> b) the password also needs to be changed somehow within the database
> (using pgAdmin I assume - although I have not found a screen there to
> change the superuser password). 

(a) is correct; whatever password the operating system account may have
is irrelevant to, indeed not known to, the Postgres server.

You will need to be sure that the server can still be started
successfully, of course.

(It is of course possible that the previous admin used the same password
inside the database as for the OS account, but that would be a chance
coincidence from our standpoint.)

			regards, tom lane