Re: pg_restore 12 "permission denied for schema" errors - Mailing list pgsql-general

From Frank Gard
Subject Re: pg_restore 12 "permission denied for schema" errors
Date
Msg-id 06b45af4-00de-7adb-5d88-35f95f0baced@familie-gard.de
Whole thread Raw
In response to Re: pg_restore 12 "permission denied for schema" errors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

Hi Tom, Am 20.10.22 um 07:12 schrieb Tom Lane:

Frank Gard <frank.von.postgresql.org@familie-gard.de> writes:
Am 20.10.22 um 02:58 schrieb Ron:
pg_restore -v --create --clean --jobs=`nproc` -Fd --dbname=template1 $DB
What database do you want to restore your data into? As far as I know your pg_restore command would import the data into template1, right?
No --- my ears went up about that too, but he's using --create.
So template1 is just the springboard for the initial connection
in which CREATE DATABASE will be issued.
you're right, of course. Overseen that detail. I've to learn to read more carefully before answering. Sorry.

Frank.

pgsql-general by date:

Previous
From: Johannes Münch
Date:
Subject: Re: PG RPMS for RHEL 9 on aarch64?
Next
From: Dominique Devienne
Date:
Subject: Re: How to store "blobs" efficiently for small and large sizes, with random access