I thought a fun thing to do would be to switch my main VPS to for more frequent updates (compared to ubuntu). (I run , a custom site, and some other simpler stuff) So far, I've started using , and also have been learning that migrating from mysql/mariadb to may have been too ambitious an idea.


Migrating a site to from mysql/mariadb

1. Run migrations to create db structure
2. Remove single quotes from the database (and newlines/control characters, because why not). This allows mysqldump files to be imported into postgresql.
3. mysqldump --compatible=postgres --no-create-info --skip-add-locks $DB | psql $DB
4. Fix increments `ALTER sequence song_id_seq RESTART 12345;` (current versions of laravel use old-fashioned postgres increments)

Sign in to participate in the conversation
Librem Social

Librem Social is an opt-in public network. Messages are shared under Creative Commons BY-SA 4.0 license terms. Policy.

Stay safe. Please abide by our code of conduct.

(Source code)

image/svg+xml Librem Chat image/svg+xml