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@xxxxxxxxxxx