Re: Scriptable way to validate a pg_dump restore ? - Mailing list pgsql-general

From Shaheed Haque
Subject Re: Scriptable way to validate a pg_dump restore ?
Date
Msg-id CAHAc2jefssD1twugPeGJUnnonYMwhTNEbH=PMerh1sX6MtBwqw@mail.gmail.com
Whole thread Raw
In response to Scriptable way to validate a pg_dump restore ?  (Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>)
List pgsql-general


On Mon, 29 Jan 2024, 23:57 Adrian Klaver, <adrian.klaver@aklaver.com> wrote:
On 1/29/24 09:28, Shaheed Haque wrote:


>
> Right, for me, state, not just record count is what I'm interested in
> (for the initial full table copy part of replication). So, given the
> explanation about the possible per-table window, is there some property
> of the table that could be used to confirm that a table has made it across?
>
> I guess there is such a thing since the following incremental syncing
> would presumably need it. I had hoped the LSN was this thing, but
> confirmation would be great.

The OP was referring to the pg_dump/pg_restore cycle, you seem to be
referring to logical replication. Is that correct?

Yes. But I was under the impression that the initial copy of logical replication was the same? 


>
> Thanks, Shaheed
>
>
>      >
>      > Thanks !
>      >
>      > Laura
>      >
>      >
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>

--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Scriptable way to validate a pg_dump restore ?
Next
From: Bob Jolliffe
Date:
Subject: Re: Query performance in 9.6.24 vs 14.10