Scriptable way to validate a pg_dump restore ?

Поиск
Список
Период
Сортировка
От Laura Smith
Тема Scriptable way to validate a pg_dump restore ?
Дата
Msg-id kvT0Fu6tCy1S4kBbdka9EPDXqE4fV45KEfNB8zV5Kk82XzJ2cnhDDm60k_0KHm5MqzqdjoilVIvk76R_WjnHJYbLKDpaPdfMMJVPnebTQjA=@protonmail.ch
обсуждение исходный текст
Ответы Re: Scriptable way to validate a pg_dump restore ?
Re: Scriptable way to validate a pg_dump restore ?
Re: Scriptable way to validate a pg_dump restore ?
Список 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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Query performance in 9.6.24 vs 14.10
Следующее
От: Shaheed Haque
Дата:
Сообщение: Re: Scriptable way to validate a pg_dump restore ?