On 4/20/22 10:23 AM, Thomas, Richard wrote:
> 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 $dbName
>>> -h localhost -p 6488 -U backup_su -f $backupFile 2`>`&1 | Out-File
>>> $pgdumpLogFile
>>
Should have asked earlier:
Have you tried doing the pg_dumps as independent actions manually for
each database instead of iterating over a list of databases in a script?
--
Adrian Klaver
adrian.klaver@aklaver.com