Re: pg_restore creates public schema?

On 10/6/22 1:54 PM, Ron wrote:
> On 10/6/22 14:32, Adrian Klaver wrote:
>> On 10/6/22 10:46, Christophe Pettus wrote:
>>>
>>>
>>>> On Oct 6, 2022, at 10:44, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>>>> Sadly, that VM doesn't have nearly enough disk space to hold the
>>>> backup folder.
>>>
>>> Use file mode, and stream the output via scp/ssh to a different machine?
>>>
>>
>> Or Plan B:
>>
>> 1) Use pg_dump 9.6.24 on existing(going EOL) server
>>
>> 2) Set up a 9.6.24 instance somewhere you have control.
>>
>> 3) pg_restore to it.
>>
>> 4) Then use pg_dump 13.8 on the new instance.
>
> While that would certainly work, it's a heck of a lot of extra effort
> for large one-time operations.
>

1) It could be scripted.

2) Nothing to stop you from splitting into schema only dump for the 9.6
--> 9.6 --> 13 restore of schema.

3) Then data only dump restored directly to 13.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com