From: | Albert Gostick <amgostick(at)navdata(dot)ca> |
---|---|
To: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Implications of resetting Postgres service in Windows |
Date: | 2020-09-01 17:23:33 |
Message-ID: | 1a9e822d9817f26ad376c8cd39f85c88@navdata.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-09-01 17:56:16 | Re: Implications of resetting Postgres service in Windows |
Previous Message | psql-contact | 2020-08-28 12:02:53 | [SOLVED] Re: can't create table on new db/schema/user |