Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange "permission denied" errors on pg_restore - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Strange "permission denied" errors on pg_restore
Date
Msg-id CANzqJaAVrQyJ_4ASm0PkmUQ7+U8PHKMTU4NAGFzM0w4FN5tDrQ@mail.gmail.com
Whole thread Raw
In response to Re: Strange "permission denied" errors on pg_restore  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Strange "permission denied" errors on pg_restore
List pgsql-admin
Tree view
On Sat, Jun 29, 2024 at 12:31 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2024-06-28 at 09:34 -0400, Ron Johnson wrote:
> pg_restore: error: COPY failed for table "batch_rp4_y2022m08": ERROR:  permission denied for schema tapschema

- Was the database you restored into totally empty?

- What was the exact "pg_restore" command line?

pg_restore -v --clean --create -Fd -j6 --dbname=postgres tap &> tap_restore.log
 
- What was the exact command line to take the dump?

declare -i Threads=$((`nproc`*3/4))
declare -i Zlvl=6
DB=tap
pg_dump -j ${Threads} -Z${ZLvl} -v -C -Fd --file=$DB $DB 2> ${DB}_pgdump.log

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Strange "permission denied" errors on pg_restore
Next
From: Laurenz Albe
Date:
Subject: Re: Strange "permission denied" errors on pg_restore