Re: PostgreSQL 10.20 crashes / Antivirus - Mailing list pgsql-general

On 4/21/22 02:13, Thomas, Richard wrote:
> Adrian (all),
> 
> Thanks for your suggestions. Running the equivalent pg_dump commands at the command line instead of in a script works
fineand generates no errors/warnings/McAfee messages in the Windows Event Viewer or on stdout/stderr. (Most days the
backupscript itself completes running multiple pg_dump without problem). 
 

For the time being a possible solution would be to insert a time out 
between iterations of:

$pgdumpCmd = "C:\Program Files\PostgreSQL\10\bin\pg_dump.exe"
         $pgdumpArgs = @("-b", "-v",
             "-F", "c",
             "-d", $dbName,
             "-h", "localhost",
             "-p", "6488",
             "-U", " backup_su",
             "-f", $backupFile)
         cmd /c $pgdumpCmd $pgdumpArgs 2`>`&1 | Out-File $pgdumpLogFile

> 
> Richard
> 



-- 
Adrian Klaver
adrian.klaver@aklaver.com