Sent with ProtonMail Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Friday, 5 June 2020 19:35, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Laura Smith n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx writes: > > > But doesn't the second half of my original post demonstrate that I tried that very thing ? I did try creating the database first, but pg_restore just complained even more ? > > There are two ways you can do this: > > 1. Create the new database by hand (with CREATE DATABASE) and tell > pg_restore to restore into it. In this case you don't say -C > to pg_restore, and your -d switch points at the DB to restore into. > > 2. Have pg_restore issue CREATE DATABASE. In this case you do use > the -C switch, and your -d switch has to point at some pre-existing > database that pg_restore can connect to for long enough to issue the > CREATE DATABASE. > > You can't mix-and-match these approaches. > > regards, tom lane > Thanks for the clarificaiton Tom. All working now !
