From: | Frank Gard <frank(dot)von(dot)postgresql(dot)org(at)familie-gard(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_restore 12 "permission denied for schema" errors |
Date: | 2022-10-20 07:38:48 |
Message-ID: | 06b45af4-00de-7adb-5d88-35f95f0baced@familie-gard.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Tom,
Am 20.10.22 um 07:12 schrieb Tom Lane:
> Frank Gard<frank(dot)von(dot)postgresql(dot)org(at)familie-gard(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dominique Devienne | 2022-10-20 07:57:06 | Re: How to store "blobs" efficiently for small and large sizes, with random access |
Previous Message | Johannes Münch | 2022-10-20 06:46:06 | Re: PG RPMS for RHEL 9 on aarch64? |