Re: Scriptable way to validate a pg_dump restore ?

Поиск
Список
Период
Сортировка
От Shaheed Haque
Тема Re: Scriptable way to validate a pg_dump restore ?
Дата
Msg-id CAHAc2jedUotr6ge45daYpd0p2rRFMb4W2XjNGO1usq4oT5qSeA@mail.gmail.com
обсуждение исходный текст
Ответ на Scriptable way to validate a pg_dump restore ?  (Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>)
Список pgsql-general
I'd also like to know how to do this. The current approaches seem, afaict, to involve making on both end of the connection. Even given the inherently racy nature of the issue, that seems unwieldy to me. 

https://www.postgresql.org/message-id/CAHAc2jdAHvp7tFZBP37awcth%3DT3h5WXCN9KjZOvuTNJaAAC_hg%40mail.gmail.com

On Mon, 29 Jan 2024, 14:12 Laura Smith, <n5d9xq3ti233xiyif2vp@protonmail.ch> wrote:
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 or whatever.

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

Thanks !

Laura


В списке pgsql-general по дате отправления:

Предыдущее
От: Laura Smith
Дата:
Сообщение: Scriptable way to validate a pg_dump restore ?
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Scriptable way to validate a pg_dump restore ?