Re: Can we get rid of repeated queries from pg_dump?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: depesz(at)depesz(dot)com
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Can we get rid of repeated queries from pg_dump?
Date: 2021-08-26 14:46:46
Message-ID: 56ad5982-44d7-7f05-2e86-747e26536eb4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 8/26/21 7:35 AM, hubert depesz lubaczewski wrote:
> On Thu, Aug 26, 2021 at 07:34:26AM -0700, Adrian Klaver wrote:
>> On 8/26/21 1:44 AM, hubert depesz lubaczewski wrote:
>>> Hi,
>>> I have following case: local pg_dump (v15) connecting to remote
>>> PostgreSQL (v12).
>> So you are using a dev version of pg_dump or is that a typo?
>
> Yes. I'm running pg_dump from my computer to (very) remote db server.

SSHing and dumping on the remote is out as a short term solution?

> Well, I guess it works, but with no output I can't judge how fast.
> Definitely doesn't seem to be going any faster.

Unknown slow, that didn't help.

>
> Best regards,
>
> depesz
>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-08-26 14:48:26 Re: Can we get rid of repeated queries from pg_dump?
Previous Message hubert depesz lubaczewski 2021-08-26 14:35:43 Re: Can we get rid of repeated queries from pg_dump?

Browse pgsql-hackers by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-08-26 14:48:26 Re: Can we get rid of repeated queries from pg_dump?
Previous Message hubert depesz lubaczewski 2021-08-26 14:35:43 Re: Can we get rid of repeated queries from pg_dump?