On the wiki page:
https://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#Antivirus_software
it warns that: “If you have any antivirus software installed, you must exclude the data directories that are to be used by PostgreSQL and must exclude postgresql.exe process”
However, there is no file “postgresql.exe in the “9.6 or 10” PostgreSQL Windows distribution. Two paragraphs further down it refers to “postgres.exe” (which I can see as running multiple processes on our server). Am I right in presuming this is either a typo (or has changed in earlier/later versions of PostgreSQL)? Grateful for feedback as I have to get our Corporate IT to make any changes to the (McAfee) Antivirus.
This does still seem to be a requirement as before I got the antivirus removed from the pgdata folder, it was proving impossible to restore the database from an AWS volume snapshot (PostgreSQL would never be able to successfully start up unless we reset the WAL). The PostgreSQL crash I got last week (with 10.20) was a low level permissions error:
"server process (PID 5664) was terminated by exception 0xC0000022"
(This NT error translates as "Access Denied: A process has requested access to an object but has not been granted those access rights").
(If this wiki page does indeed need to be corrected I am happy to do it, but I would need editor access to the wiki, my username is rThomasAtkins)
Richard Thomas
At Atkins - member of the SNC-Lavalin Group, we work flexible hours around the world. Although I have sent this email at a time convenient for me, I don't expect you to respond until it works for you.
NOTICE – This email message and any attachments may contain information or material that is confidential, privileged, and/or subject to copyright or other rights. Any unauthorized viewing, disclosure, retransmission, dissemination, or other use of or reliance on this message or anything contained therein is strictly prohibited and may be unlawful. If you believe you may have received this message in error, kindly inform the sender by return email and delete this message from your system. Thank you.