pgcopydb
pgcopydb copied to clipboard
Clone fails on existing schema
Hi Team,
I am creating my target DB in AWS Hyperscalar in cloud foundry. My source DB is also in CF provided by AWS Hyperscalar. When creating target DB, it creates some default functions and schema 'public'. I tried to do a clone using command
pgcopydb clone --no-owner --no-acl
I get the error saying schema 'public' already exists. I then tried with command
pgcopydb clone --no-owner --no-acl --drop-if-exists
It sill fails saying the user does not have sufficient permission to drop the schema. But, as I said, the schema is created by default by hyperscalars during DB creation . Can you please help. I have attached logs for reference phy_logical_log.txt