Re: pg_restore creates public schema?

Adrian Klaver <adrian.klaver@aklaver.com>

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Ron <ronljohnsonjr@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2022-10-08T15:02:28Z
Lists: pgsql-general
On 10/7/22 20:14, Ron wrote:
> On 10/7/22 15:31, Alban Hertroys wrote:

>> 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.)

An example using psql:

https://fedingo.com/how-to-connect-to-postgresql-server-via-ssh-tunnel/


-- 
Adrian Klaver
adrian.klaver@aklaver.com