Migration Postgres issues

[pastel onyx]

Hey, everybody.

Every time I update my site, I get migration issues. For example:
“type \“enum_payload_jobs_log_task_slug\” already exists”

Or
“column \“knowledge_base_id\” referenced in foreign key constraint does not exist.”

Can you tell me how you solve or avoid these problems?

[severe onyx]

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

• Postgres - Migration workflows
• Migrations - When to run migrations - Postgres
• Postgres

Community-Help:

• How Can We Create Custom Field Types in Payload?
• TypeError: Cannot read properties of undefined-if(script.startsWith('migrate'))
• Initial Migration Not Happening With Postgres