Re: pg_restore creates public schema?

On 10/6/22 10:20, Tom Lane wrote:
> Ron<ronljohnsonjr(at)gmail(dot)com> writes:
>> 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.
> But why are you using the dead version's pg_dump? You could use
> the supported version of that.

Because installing new software on production servers requires hurdles
(Service Now change ticket approved by the application support manager,
Delivery Service Manager, Engineering Change Board, and a one week lead time
before installing during the Saturday night maintenance window) that I'm not
willing to jump through just to take an /ad hoc/ database backup.

--
Angular momentum makes the world go 'round.