Source and target are 13.2. Source dump command:
time pg_dump \
--verbose \
--dbname=boxscore \
--blobs \
--jobs=${JOBS} \
--format=directory \
--file=db.full.dump > ~/db.full.dump.log 2>&1
--
--verbose \
--dbname=boxscore \
--blobs \
--jobs=${JOBS} \
--format=directory \
--file=db.full.dump > ~/db.full.dump.log 2>&1
Restore excludes mat views, so two steps:
time pg_restore \
--list \
--format=directory \
db.full.dump | sed '/MATERIALIZED VIEW DATA/d' > restore.lst
--list \
--format=directory \
db.full.dump | sed '/MATERIALIZED VIEW DATA/d' > restore.lst
And then
time pg_restore \
--verbose \
--host=${HOST} \
--user=postgres \
--format=directory \
--use-list restore.lst \
--dbname=boxscore \
--jobs 16 \
db.full.dump > ~/restore.log 2>&1
--verbose \
--host=${HOST} \
--user=postgres \
--format=directory \
--use-list restore.lst \
--dbname=boxscore \
--jobs 16 \
db.full.dump > ~/restore.log 2>&1
After creation, none of my schemes or relations really have the right permissions, they seem totally absent. The same exact roles exist in source and target.
Am I missing something obvious here?
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx