PostgreSQL 10.20 crashes / Antivirus

2022-04-06 Thread Thomas, Richard
I've been having problems with several PostgreSQL crashes over the last month (originally with 10.16, then more recently with 10.20, all on a Windows Server 2012R2 platform), always with a low level permissions error: "server process (PID 5664) was terminated by exception 0xC022" (This NT err

RE: PostgreSQL 10.20 crashes / Antivirus

2022-04-06 Thread Thomas, Richard
Ah... no - the AV is still allowed to run riot in the folder where the dump file is written to. Do you think that could be the issue? Richard -Original Message- From: Adrian Klaver Sent: 06 April 2022 15:42 To: Thomas, Richard ; pgsql-general@lists.postgresql.org Subject: Re

RE: PostgreSQL 10.20 crashes / Antivirus

2022-04-19 Thread Thomas, Richard
A request for further suggestions for how to fix/diagnose this PG crash (having just got back from holiday I discover that PG is still crashing even though I have changed the pgdump target output location to a folder excluded from the McAfee Antivirus scanning - but thanks for the suggestion Adr

RE: PostgreSQL 10.20 crashes / Antivirus

2022-04-20 Thread Thomas, Richard
onnect to server: Connection refused (0x274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 6488? could not connect to server: Connection refused (0x274D/10061) Is the server running on host &

RE: PostgreSQL 10.20 crashes / Antivirus

2022-04-20 Thread Thomas, Richard
Adrian Klaver wrote: > On 4/20/22 01:06, Thomas, Richard wrote: > > The command used in a PowerShell script (run with Windows task scheduler) > to dump each database should evaluate to: > > > > "C:\Program Files\PostgreSQL\10\bin\pg_dump.exe" -b -v -F c -d $

RE: PostgreSQL 10.20 crashes / Antivirus

2022-04-21 Thread Thomas, Richard
or a cloud-based PaaS.) Richard > > Adrian Klaver wrote: > >> On 4/20/22 01:06, Thomas, Richard wrote: > > >>> - pg_dump.exe executable is not excluded from McAfee on-access > >>> scanning (although as recommended postgres.exe is) > >> > >

10.22 Windows binaries download? (zip "invalid" on Enterprisedb)

2022-09-21 Thread Thomas, Richard
I'm trying to download the Windows x64 binaries only for PostgreSQL 10.22 in order to perform a minor upgrade. However, the download (postgresql-10.22-1-windows-x64-binaries.zip) from my usual go-to place: (https://www.enterprisedb.com/download-postgresql-binaries) gives me a file that Windows

RE: 10.22 Windows binaries download? (zip "invalid" on Enterprisedb)

2022-09-21 Thread Thomas, Richard
Thanks very much - 7-zip (from https://www.7-zip.org/) was just the job to unpack the archive where Windows "Extract all" failed. Richard > -Original Message- > From: Erik Wienhold > Sent: 21 September 2022 14:44 > To: Thomas, Richard ; pgsql- > gene...@lists