Delay materialized view refresh during pg_restore
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 |
This comment has been minimized.
This comment has been minimized.
Thanks |
This comment has been minimized.
This comment has been minimized.
thx ! |
This comment has been minimized.
This comment has been minimized.
Good,Thanks! |
This comment has been minimized.
This comment has been minimized.
muchos grassy-ass amigo. which is spanish for you're awesome |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
Excelent