I've seen this before with Win10. 1.- Go to Windows ControlPanel-UserAccounts-ManageAnotherAccount, select postgres and re-enter the Postgres User password, save and close. 2.- Start Windows Services (if running as a service) right click on Postgres Service-Properties-LogOn then enter the same password click Ok 3.- Restart Postgres Service With every new update of Win10, it tends to changes some of the folders permissions, including postgres. Very annoying but common. Good luck On 02/14/2018 07:35 AM, Adrian Klaver wrote: > On 02/13/2018 12:07 PM, Dale Seaburg wrote: >> Server: Windows 10 Pro system >> Postgresql: 8.4.5 installed several months ago and working correctly, >> until recently > > Should have mentioned earlier, version 8.4 went EOL about three and half > years ago: > > https://www.postgresql.org/support/versioning/ > > Probably should look at upgrading to a newer version sooner rather then > later. > > >> >> On Feb 9, 2018 about 7 PM pg_log file recorded: >> >> 2018-02-09 15:04:23 CST LOG: unexpected EOF on client connection >> 2018-02-09 19:12:41 CST LOG: received fast shutdown request >> 2018-02-09 19:12:41 CST LOG: aborting any active transactions >> 2018-02-09 19:12:41 CST LOG: autovacuum launcher shutting down >> 2018-02-09 19:12:41 CST LOG: shutting down >> 2018-02-09 19:12:43 CST LOG: database system is shut down >> >> On Feb 12, 2018 about 2 PM after computer was restarted, pg_log file >> recorded: >> >> 2018-02-12 14:17:31 CST LOG: could not open configuration file >> "C:/WINDOWS/system32/ConfigDir/pg_hba.conf": No such file or directory >> 2018-02-12 14:17:31 CST FATAL: could not load pg_hba.conf >> >> The log event on Friday, appears to have recorded a forced shutdown - >> Windows 10 update install, maybe? No one at business to record what >> may have happened. >> >> On Monday afternoon, postgres service refused to Start as indicated in >> that day's log event. >> >> Any ideas as to what might have happened, or caused this anomaly? It's >> almost as if some Environment Variables were missing, or scrambled. I >> don't think Postgresql uses the Windows Registry, in place of EV's, >> does it? >> >> Dale Seaburg >> >> >> > >
Attachment:
signature.asc
Description: OpenPGP digital signature
