Re: pg_restore creates public schema?

On 10/6/22 10:46, Christophe Pettus wrote:
> 
> 
>> On Oct 6, 2022, at 10:44, Ron <ronljohnsonjr@gmail.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.

-- 
Adrian Klaver
adrian.klaver@aklaver.com