Re: proposal: possibility to read dumped table's name from file

From: Erik Rijkers <er(at)xs4all(dot)nl>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>, Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Surafel Temesgen <surafel3000(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: possibility to read dumped table's name from file
Date: 2022-09-12 14:18:41
Message-ID: 13a277d9-9066-1aff-1c1c-50a96eef3419@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Op 12-09-2022 om 16:00 schreef Erik Rijkers:
> Op 12-09-2022 om 09:58 schreef Daniel Gustafsson:
>>> On 9 Sep 2022, at 11:00, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>>>
>>>> On Sep 9, 2022, at 5:53 PM, John Naylor
>>>> <john(dot)naylor(at)enterprisedb(dot)com> wrote:
>
>>>> [v4-0001-Add-include-exclude-filtering-via-file-in-pg_dump.patch]
>
> I noticed that pg_restore --filter cannot, or at last not always, be
> used with the same filter-file that was used to produce a dump with
> pg_dump --filter.
>
> Is that as designed?  It seems a bit counterintuitive.  It'd be nice if
> that could be fixed.  Admittedly, the 'same' problem in pg_restore -t,
> also less than ideal.
>
> (A messy bashdemo below)

I hope the issue is still clear, even though in the bash I sent, I
messed up the dumpfile name (i.e., in the bash that I sent the pg_dump
creates another dump name than what is given to pg_restore. They should
use the same dumpname, obviously)

>
> thanks,
>
> Erik Rijkers

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ronan Dunklau 2022-09-12 14:41:16 Re: Fix gin index cost estimation
Previous Message Jelte Fennema 2022-09-12 14:16:56 Re: [EXTERNAL] Re: Support load balancing in libpq