Dump & restore in directory format and permissions are largely lost?
| От | Wells Oliver |
|---|---|
| Тема | Dump & restore in directory format and permissions are largely lost? |
| Дата | |
| Msg-id | CAOC+FBUk6FGOa0NGaFKX_jJTmOgN-xLTWFKm5MsdnDRqoQ9p-g@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Dump & restore in directory format and permissions are largely lost?
|
| Список | pgsql-admin |
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@gmail.com
wells.oliver@gmail.com
В списке pgsql-admin по дате отправления: