select type of database

[vasyakrg]

it would be great to add a choice of database type

1. postgres
2. mysql-server
3. mariadb-server

[enoch85]

The first VM ran MySQL, then we changed to MariaDB and had a lot of issues, so we decided to change to PostgreSQL, and since then everything has worked very well. It's very fast and avoids errors that MariaDB and MySQL have.

We will not change or give that as an option. PostgreSQL is the best DB in our opinion, and if you want to convert it yourself, you are free to do so.

[thejohnha]

@enoch85 quick question for you: I have an instance that is running mariadb - it was set up with a earlier version of the vm scripts. Do you think there is a way I can migrate my instance to the new version with PostgreSQL? Ideally I'd like to start from scratch and create a brand new instance and then migrate everything over. I've done this before, but it was always from mariadb to mariadb, and not from mariadb to PostgreSQL...

[vasyakrg]

@enoch85 quick question for you: I have an instance that is running mariadb - it was set up with a earlier version of the vm scripts. Do you think there is a way I can migrate my instance to the new version with PostgreSQL? Ideally I'd like to start from scratch and create a brand new instance and then migrate everything over. I've done this before, but it was always from mariadb to mariadb, and not from mariadb to PostgreSQL...

I would not advise moving from an existing base between MariaDB and PostgresSQL

[enoch85]

I would not advise moving from an existing base between MariaDB and PostgresSQL

Why?

It's as simple as creating a new DB, and let the Nextcloud occ command do it's job. Read more here: https://www.techandme.se/we-migrated-to-postgresql/ It's been working without a hitch since I deployed it.

[thejohnha]

It's as simple as creating a new DB, and let the Nextcloud occ command do it's job. Read more here: https://www.techandme.se/we-migrated-to-postgresql/ It's been working without a hitch since I deployed it.

Sweet - thanks for that! I forgot about that blog post - I'll give it a shot :-)

[enoch85]

@thejohnha Remember, backups backups backups. :)

[thejohnha]

@thejohnha Remember, backups backups backups. :)

👍👍👍😃