Timeline for Migrating a Craft 4 instance from MySQL to PostgreSQL
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 6, 2023 at 19:19 | comment | added | Dominik Krulak |
A note to add to my comment above is that I migrated using Docker command because databases live in Docker containers. So I run something like $ docker run --rm -it dimitri/pgloader:latest pgloader mysql://myuser@myhost/dbname pgsql://pguser@pghost/dbname. After I just renamed schema name to public. I quote your comment in your question: column names would all be lowercased, some critical type conversions and search index updates would be missing. Could that be?
|
|
| Feb 6, 2023 at 19:07 | comment | added | Dominik Krulak |
@BradBell what else could it be? I get the same php error like @Rich D. but with different stack trace start. An Error occurred while handling another error: yii\base\UnknownPropertyException: Setting unknown property: craft\models\Info::schemaversion in /app/vendor/yiisoft/yii2/base/Component.php:209 Stack trace: #0 /app/vendor/yiisoft/yii2/BaseYii.php(558): yii\base\Component->__set() #1 /app/vendor/yiisoft/yii2/base/BaseObject.php(107): yii\BaseYii::configure()
|
|
| Dec 16, 2022 at 2:25 | comment | added | Brad Bell♦ | No worries - glad you're all sorted! | |
| Dec 15, 2022 at 22:40 | vote | accept | Rich D. | ||
| Dec 15, 2022 at 22:39 | comment | added | Rich D. |
Thanks Brad! That sorted it, silly me - I'd commented out the DB_SCHEMA env var. Wrt to setting the unknown property 'schemaVersion', that related to the lowercase conversion when using the pgloader from to in it's rawest form. Reverted to your answer in a similar q which resolved it, using a command file as the input - thanks for your help!
|
|
| Dec 15, 2022 at 22:16 | history | answered | Brad Bell♦ | CC BY-SA 4.0 |