Re: pg_restore creates public schema?

On 10/6/22 10:20, Tom Lane wrote:

Ron <ronljohnsonjr@gmail.com> writes:

On 10/6/22 09:49, Tom Lane wrote:

Ron <ronljohnsonjr@gmail.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.