pgcopydb icon indicating copy to clipboard operation
pgcopydb copied to clipboard

Clone fails on existing schema

Open sagar-git-hub opened this issue 1 year ago • 0 comments

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

sagar-git-hub avatar Mar 22 '24 11:03 sagar-git-hub