Delay materialized view refresh during pg_restore

delay_pg_restore_matviews

pg_dump database -Fc backup.dump
pg_restore -l backup.dump | sed '/MATERIALIZED VIEW DATA/d' > restore.lst
pg_restore -L restore.lst -d database backup.dump

pg_restore -l backup.dump | grep 'MATERIALIZED VIEW DATA' > refresh.lst
pg_restore -L refresh.lst -d database backup.dump

Excelent

Thanks 👍

thx !

Good，Thanks！

muchos grassy-ass amigo. which is spanish for you're awesome