On Fri, 13 Dec 2024, Adrian Klaver wrote:
Alright, from here:
https://www.postgresql.org/docs/current/app-pgdump.html
"-c
--clean
Output commands to DROP all the dumped database objects prior to
outputting the commands for creating them. This option is useful when the
restore is to overwrite an existing database. If any of the objects do not
exist in the destination database, ignorable error messages will be reported
during restore, unless --if-exists is also specified.
This option is ignored when emitting an archive (non-text) output file.
For the archive formats, you can specify the option when you call pg_restore.
"
This means when you run the script with:
psql -d bustrac -f bustrac-2024-12-12.sql
it will clean out the current corrupted objects and replace them with those
in the backup file.
Adrian,
That's what I thought since I wrote the script based on reading pgdump a
long time ago.
Thanks for confirming! I'll fix my carelessness now.
Carpe weekend,
Rich