-

Mon, 02 Oct 2023 18:18:19 +0200

adminsforum@hubzilla.org

｛Hans｝ wrote the following post Mon, 02 Oct 2023 18:18:19 +0200

Hubzilla on postgresql,

I know some are running Hubzilla using PostgreSQL rdmbs. I did think about it but was to lazy to even look at it. However...

It seems MariaDB might be bought by a capital investor and therefor we do not know where it will end. Therefor a few questions.

1. Is there a script to convert the current setup or a way to import all users and their posts?
2. Are updates also taking care of changes in the database and will those be installed?

Thanks all

Mon, 02 Oct 2023 20:49:34 +0200

Mario Vavti

mario@hub.somaton.com

@Beni Grind ~HB9HNT wrote an article about this a while ago: #^https://grindcore.ch/articles/navigium/migrate_hubzilla_to_postgres

The updates take care of both backends and both are officially supported.

Tue, 03 Oct 2023 18:18:57 +0200

Beni Grind ~HB9HNT

navigium@grindcore.ch

@｛Hans｝ the article is quite old and never was very precise. TL;DR is that you retry the migration and fix every pgloader error that comes up. Always drop the Postgres DB after fixing one problem and start over. Rinse and repeat until it goes through without errors.