On 10/6/22 09:49, Tom Lane wrote:
Ron <ronljohnsonjr@xxxxxxxxx> writes:
pg_dump 9.6.24
You realize that that version's been out of support for a year?
Yes, which is why I'm dumping from an EOL cluster, and restoring to a
supported version.
Why does pg_restore explicitly create "public" even though public is
automatically created when the database is created?
We fixed that in v11 (see 5955d9341). Evidently the fix requires an
updated pg_dump more than pg_restore.
Ah.
However, I believe that only happens with -c, so why are you using both -c and -C?
Because the database might already exist on the target before doing the restore.
--
Angular momentum makes the world go 'round.
