Re: pg_restore creates public schema?

On 10/6/22 17:01, Adrian Klaver wrote:
> On 10/6/22 2:03 PM, Ron wrote:
>> On 10/6/22 14:35, Adrian Klaver wrote:
>>> On 10/6/22 09:46, Ron wrote:
>>>> On 10/6/22 10:20, Tom Lane wrote:
>
>>>>
>>>> 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.
>>>
>>> 1) So I assume that means Postgres 13.8 has not been installed in
>>> anticipation of the change over?
>>
>> It's certainly been installed on the *new* (RHEL8) server. Not the EOL
>> RHEL6 server, because of course the point is to get off of EOL software...
>
> And the RHEL8 server can't talk to the RHEL6 server?

Give me /some/ credit for thinking of that first...

--
Angular momentum makes the world go 'round.