| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Shaheed Haque <shaheedhaque(at)gmail(dot)com> |
| Cc: | Laura Smith <n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch>, postgre <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Scriptable way to validate a pg_dump restore ? |
| Date: | 2024-01-29 18:27:02 |
| Message-ID: | ce54a2b0-dbbc-4915-b5d6-63839092d399@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/29/24 10:12, Shaheed Haque wrote:
>
> Yes. But I was under the impression that the initial copy of logical
> replication was the same?
>
Are you taking about the copy_data option to WITH?
If so yes and no.
Yes as it uses COPY to transfer the data.
No as what COPY transfers can be affected by WHERE clauses on the
publisher. Also if you have cascading publishers/subscriptions the
'original' data maybe upstream of the publisher you are comparing to.
Finally logical replication is generally not static so there is the
issue of determining a point in time for the check.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laura Smith | 2024-01-29 19:20:35 | Re: Scriptable way to validate a pg_dump restore ? |
| Previous Message | Bob Jolliffe | 2024-01-29 18:21:05 | Re: Query performance in 9.6.24 vs 14.10 |