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

From Laura Smith
Subject Scriptable way to validate a pg_dump restore ?
Date
Msg-id kvT0Fu6tCy1S4kBbdka9EPDXqE4fV45KEfNB8zV5Kk82XzJ2cnhDDm60k_0KHm5MqzqdjoilVIvk76R_WjnHJYbLKDpaPdfMMJVPnebTQjA=@protonmail.ch
Whole thread Raw
Responses Re: Scriptable way to validate a pg_dump restore ?  (Shaheed Haque <shaheedhaque@gmail.com>)
Re: Scriptable way to validate a pg_dump restore ?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Re: Scriptable way to validate a pg_dump restore ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi

Let's say I've got a scenario where I'm doing a pg_dump replication rather than online streaming, e.g. due to air-gap
orwhatever. 

Is there a scriptable way to validate the restore ?  e.g. using doing something clever with ctid or something to ensure
boththe schema and all its rows were restored to the same point at which the dump was taken ? 

Thanks !

Laura



pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Query performance in 9.6.24 vs 14.10
Next
From: Shaheed Haque
Date:
Subject: Re: Scriptable way to validate a pg_dump restore ?