Re: pg_restore creates public schema? - Mailing list pgsql-general

From Ron
Subject Re: pg_restore creates public schema?
Date
Msg-id 31774754-424d-3637-8861-f7b61c106a69@gmail.com
Whole thread Raw
In response to Re: pg_restore creates public schema?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore creates public schema?
Re: pg_restore creates public schema?
List pgsql-general
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.


--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore creates public schema?
Next
From: Christophe Pettus
Date:
Subject: Re: pg_restore creates public schema?