robertmu commented on issue #1451: URL: https://github.com/apache/cloudberry/issues/1451#issuecomment-3680108638
> Hi [@robertmu](https://github.com/robertmu), > > I am able to create index while using cbcopy as I have the issue I was restoring the metadata first and on metadata I have faced the permission issues due to which it did not created the indexes but it is strange behavior I am using the super user for but still it was not authorize to create the index. Anyhow when I fixed the permission issue while restoring the metadata manually then cbcopy created the indexes. > > Thank you for your support. Glad to hear you've resolved the issue! Regarding your observation about superuser permissions: being a superuser doesn't mean you won't encounter permission-related failures. Here's why: When cbcopy restores metadata, it attempts to recreate objects with their original ownership and tablespace settings. Even if you're running as a superuser, the following scenarios can still cause failures: 1. Missing Roles If the source table's owner role doesn't exist in the destination database, the creation will fail with: "ERROR: role 'original_owner' does not exist" 2. Missing Tablespaces If the source objects use custom tablespaces that don't exist in the destination, the creation will fail with:"ERROR: tablespace 'custom_tablespace' does not exist" -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
