[Bug] Cannot rpm install into a specified directory

### Apache Cloudberry version

cloudberry-db-1.6.0-1.el8.x86_64.rpm

### What happened

I want to inistall Cloudberry-db into a specified directory, etc, /home/gpadmin/. But it will prompt error as below.
```
[root@gp7cdw gpadmin]# rpm -ivh cloudberry-db-1.6.0-1.el8.x86_64.rpm --prefix=/home/gpadmin/
warning: cloudberry-db-1.6.0-1.el8.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID accad176: NOKEY
error: unpacking of archive failed on file /home/gpadmin;680f301b: cpio: File from package already exists as a directory in system
error: cloudberry-db-1.6.0-1.el8.x86_64: install failed
```

### What you think should happen instead

_No response_

### How to reproduce

Just using command line as :
rpm -ivh cloudberry-db-1.6.0-1.el8.x86_64.rpm --prefix=/home/gpadmin/

### Operating System

Rocky Linux 8.10

### Anything else

_No response_

### Are you willing to submit PR?

- [x] Yes, I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).

Start by reproducing the reported `rpm -ivh cloudberry-db-1.6.0-1.el8.x86_64.rpm --prefix=/home/gpadmin/` command on Rocky Linux 8.10, then inspect the RPM package metadata and installation paths. Done means the package installs into a specified directory without the reported cpio conflict, with regression coverage for the command's behavior.

Written by the indexing model from the issue text.