Thomas Kellerer <thomas(at)kellerer(dot)eu> writes:
> There was a left over pipe symbol in the script that we didn't see:
> pg_dump --table=l10n --table=l10n_value --clean ${db_stag} |
> psql --single-transaction --dbname=${db_prod} --file=${backup_stag}
> So pg_dump pipes a script with DROP statement into psql, which then
> runs essentially the same script again which was created in a previous step (also with --clean)
Hm, but if psql is restoring into a different database than pg_dump
is dumping from, I don't see how they'd interact?
regards, tom lane