Forum

The migration failed, and it crashed my database!!

My database is broken too!!!!! Your platform has no capability at all, damn it, it's really trash.

Project ID: 6a04ce779638a008a2b536b7 Service ID: 6a04ce779638a008a2b536de (PostgreSQL) Environment ID: 6a04ce77e5ed304c1d850b8d

Issue:

• PostgreSQL service copied from another project
• Fails to start with error: Permission denied on /var/lib/postgresql/data/global/pg_control
• The data volume contains important data that must be preserved
• Need to fix permission issues so PostgreSQL can start

Error log: postgres: could not find the database system Expected to find it in the directory "/var/lib/postgresql/data" but could not open file "/var/lib/postgresql/data/global/pg_control": Permission denied

I have fixed the issue. Your platform has too many bugs.

Hello, we are very sorry that the migration feature has caused these issues for you.

After investigation, the issue was that file ownership was not correctly preserved when copying data volumes during the migration, causing PostgreSQL to fail to start due to lack of permission to read the data files. At the same time, the migration process also affected the stability of the Redis instance in the source project, which should not have happened.

We have created an internal ticket to track the fix and will ensure that:

• Original file permissions are preserved when copying data volumes.
• The source service is not affected when a migration fails.

Thank you for your feedback, and we are glad that you have already restored your service on your own. Please feel free to reach out if you have any other questions.