Dump & restore in directory format and permissions are largely lost?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Restore excludes mat views, so two steps:

time pg_restore \
        --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

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?


--

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux