public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Albert Gostick <[email protected]>
Cc: [email protected]
Subject: Re: Implications of resetting Postgres service in Windows
Date: Tue, 01 Sep 2020 13:56:16 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Albert Gostick <[email protected]> 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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Implications of resetting Postgres service in Windows
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox