Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: Strange "permission denied" errors on pg_restore
Date
Msg-id 792db007dcc03570743afee23aa0da830207f0cf.camel@cybertec.at
Whole thread Raw
In response to Strange "permission denied" errors on pg_restore  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Strange "permission denied" errors on pg_restore
List pgsql-admin
Tree view 
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?

- What was the exact command line to take the dump?

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Sabyasachi Mukherjee
Date:
Subject: Re: Free disk space decreasing after running Vaccum Full
Next
From: Ron Johnson
Date:
Subject: Re: Strange "permission denied" errors on pg_restore