Thread: Wiki Antivirus question (+ editor request)
On the wiki page:
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.
On 3/23/22 04:39, Thomas, Richard wrote: > I would need editor access to the wiki, my username is rThomasAtkins) Editor access granted Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
[Joe] - thanks for giving me edit permissions on the Wiki Page. However, before editing the page I need to find out if "postgresql.exe" is indeed a typo/legacy issue and it should read"postgres.exe" - maybe I need to email on one of the other PostgreSQL lists to raise such a question? I've not used thePG email lists before, so grateful for pointers! Richard P.S. my original query copied here... 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 byPostgreSQL 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 downit refers to "postgres.exe" (which I can see as running multiple processes on our server). Am I right in presuming thisis either a typo (or has changed in earlier/later versions of PostgreSQL)? Grateful for feedback as I have to get ourCorporate 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 impossibleto restore the database from an AWS volume snapshot (PostgreSQL would never be able to successfully start up unlesswe 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 accessrights"). -----Original Message----- From: Joe Conway <mail@joeconway.com> Sent: 23 March 2022 19:42 To: Thomas, Richard <Richard.Thomas@atkinsglobal.com>; pgsql-www@postgresql.org Subject: Re: Wiki Antivirus question (+ editor request) On 3/23/22 04:39, Thomas, Richard wrote: > I would need editor access to the wiki, my username is rThomasAtkins) Editor access granted Joe At Atkins - member of the SNC-Lavalin Group, we work flexible hours around the world. Although I have sent this email ata 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/orsubject to copyright or other rights. Any unauthorized viewing, disclosure, retransmission, dissemination, or otheruse of or reliance on this message or anything contained therein is strictly prohibited and may be unlawful. If youbelieve you may have received this message in error, kindly inform the sender by return email and delete this messagefrom your system. Thank you.
Hi, On Mon, Mar 28, 2022 at 09:45:24AM +0000, Thomas, Richard wrote: > > However, before editing the page I need to find out if "postgresql.exe" is > indeed a typo/legacy issue and it should read "postgres.exe" - maybe I need > to email on one of the other PostgreSQL lists to raise such a question? I've > not used the PG email lists before, so grateful for pointers! I don't think it's necessary, it's likely a typo as we have always generated postgres[.exe]. Just in case I checked on a Windows vm I have around and confirmed that I only see a postgres.exe, so +1 for changing it on the wiki.