Re: Strange "permission denied" errors on pg_restore

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Strange "permission denied" errors on pg_restore
Date: 2024-06-29 04:31:01
Message-ID: 792db007dcc03570743afee23aa0da830207f0cf.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-06-29 05:04:22 Re: Strange "permission denied" errors on pg_restore
Previous Message Sabyasachi Mukherjee 2024-06-28 16:53:24 Re: Free disk space decreasing after running Vaccum Full