Re: pg_restore creates public schema?

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 10/6/22 10:20, Tom Lane wrote:
> Ron <ronljohnsonjr@xxxxxxxxx> writes:
> > 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.
> >       
> 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.