Postgres Pro
Downloads
Home   >   mailing lists

Dump & restore in directory format and permissions are largely lost? - Mailing list pgsql-admin

From Wells Oliver
Subject Dump & restore in directory format and permissions are largely lost?
Date
Msg-id CAOC+FBUk6FGOa0NGaFKX_jJTmOgN-xLTWFKm5MsdnDRqoQ9p-g@mail.gmail.com
Whole thread Raw
Responses Re: Dump & restore in directory format and permissions are largely lost?
List pgsql-admin
Tree view
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?


--

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: vacuumdb idle processes
Next
From: "David G. Johnston"
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?