Re: pg_restore creates public schema?

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?




-- 
Adrian Klaver
adrian.klaver@aklaver.com