> On Jun 5, 2020, at 11:20, Laura Smith <n5d9xq3ti233xiyif...@protonmail.ch>
> wrote:
> sudo -u postgres pg_restore -v -C -d foobar 4_foobar_pgdump_Fc
You need to connect to a database that already exists (such as "postgres"); it
then creates the database you are restoring and switches to it. The relevant
manual line is:
"When (-C / --create) is used, the database named with -d is used only
to issue the initial DROP DATABASE and CREATE DATABASE commands. All data is
restored into the database name that appears in the archive."
--
-- Christophe Pettus
x...@thebuild.com
