I understand that pg_restore needs to connect to a database before it can start the restore process, is there anyway pg_restore can use the "postgres" database to create another database?
I have the following command
pg_restore -h "192.168.1.212" -p 5432 -U mysuperusername -C -d bp bp.custom
when I run the command I get the following message
pg_restore: [archiver (db)] connection to database "bp" failed: FATAL: database "bp" does not exist
Is there anyway for pg_restore to create the "bp" database without me having to create it manually?