public inbox for [email protected]  

help / color / mirror / Atom feed

Implications of resetting Postgres service in Windows
2+ messages / 2 participants
[nested] [flat]

* Implications of resetting Postgres service in Windows
@ 2020-09-01 17:23 Albert Gostick <[email protected]>
  2020-09-01 17:56 ` Re: Implications of resetting Postgres service in Windows Tom Lane <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Albert Gostick @ 2020-09-01 17:23 UTC (permalink / raw)
  To: [email protected]

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). 

Any suggestions would be appreciated!  I just want to update the
passwords as per higher management but not knock out the server! 

Thanks.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Implications of resetting Postgres service in Windows
  2020-09-01 17:23 Implications of resetting Postgres service in Windows Albert Gostick <[email protected]>
@ 2020-09-01 17:56 ` Tom Lane <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2020-09-01 17:56 UTC (permalink / raw)
  To: Albert Gostick <[email protected]>; +Cc: [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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2020-09-01 17:56 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-09-01 17:23 Implications of resetting Postgres service in Windows Albert Gostick <[email protected]>
2020-09-01 17:56 ` Tom Lane <[email protected]>

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