Search Postgresql Archives

Re: pg_restore creates public schema?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/7/22 15:31, Alban Hertroys wrote:
On 6 Oct 2022, at 22:52, Ron <ronljohnsonjr@xxxxxxxxx> wrote:

On 10/6/22 12:46, Christophe Pettus wrote:
On Oct 6, 2022, at 10:44, Ron <ronljohnsonjr@xxxxxxxxx> 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 at HostA 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 does have enough space to dump?

Interesting.  (It's above my ssh expertise, though.)

--
Angular momentum makes the world go 'round.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux