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

From Alban Hertroys
Subject Re: pg_restore creates public schema?
Date
Msg-id C0A08AE7-306E-4999-B12C-4D9B8A52AD88@gmail.com
Whole thread Raw
In response to Re: pg_restore creates public schema?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: pg_restore creates public schema?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
> On 6 Oct 2022, at 22:52, Ron <ronljohnsonjr@gmail.com> wrote:
>
> On 10/6/22 12: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?
>
> I thought of that, too.  Unfortunately, the ssh version in RHEL 8.6 is sufficiently old that "three way" ssh (person
atHostA wanting to transfer a file from Server1 to Server2) requires that port 22 be open from Server1 to Server2. 

Bit of a wild idea, I haven’t used SSH tunnels in years, so a bit fuzzy on the details:

Can you create an SSH tunnel to the new machine from the VM, then pipe that to an SSH connection from a machine that
doeshave enough space to dump? 

And then vice versa to the new machine to restore? (Unless access to that one is easier of course)

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.




pgsql-general by date:

Previous
From: Kouber Saparev
Date:
Subject: Re: Cannot convert partitioned table to a view
Next
From: Tom Lane
Date:
Subject: Re: Cannot convert partitioned table to a view