On 10/6/22 09:49, Tom Lane wrote:
> Ron <ronljohnsonjr(at)gmail(dot)com> 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.