https://nicolaslang.fr/articles/migrer-la-bdd-nextcloud-de-mysql-vers-postgres

gzip -d ARCHIVE_dump_bdd.gz

préparation MYSQL
DROP DATABASE pailleccambouis;
CREATE DATABASE pailleccambouis;
GRANT ALL PRIVILEGES ON *.* TO 'nextcloud' WITH GRANT OPTION;
source /home/roms/ARCHIVE_dump_bdd;


drop table oc_bbb_restrictions;
drop table oc_bbb_room_shares;
drop table oc_bbb_rooms;
drop table oc_mail_accounts;
drop table oc_mail_aliases;
drop table oc_mail_attachments;
drop table oc_mail_classifiers;
drop table oc_mail_coll_addresses;
drop table oc_mail_mailboxes;
drop table oc_mail_messages;
drop table oc_mail_recipients;

mysql -u nextcloud -p pailleccambouis

modif config.php avec localhost + dbuser nextcloud + dbpass Ckoideja

sudo -u www-data ./console-7.4 db:convert-mysql-charset
sudo -u www-data ./console-7.4 db:add-missing-columns
sudo -u www-data ./console-7.4 db:add-missing-indices
sudo -u www-data ./console-7.4 db:convert-filecache-bigint
sudo -u www-data ./console-7.4 maintenance:mimetype:update-db
sudo -u www-data ./console-7.4 maintenance:mimetype:update-js

préparation PGSQL
vim /etc/postgresql/11/main/pg_hba.conf 
local	all		nextcloud				peer
CREATE USER nextcloud;
ALTER USER nextcloud WITH PASSWORD 'Ckoideja';

DROP DATABASE nextcloud;
CREATE DATABASE nextcloud;

ALTER DATABASE nextcloud OWNER TO nextcloud;
GRANT ALL PRIVILEGES ON DATABASE nextcloud TO nextcloud;


adduser nextcloud -disabled-login --disabled-password --home /opt/nuage --no-create-home --shell /bin/false --system
adduser nextcloud postgres

adduser nextcloud www-data
sudo -u www-data ./console-7.4 db:convert-type --all-apps pgsql nextcloud localhost nextcloud
certaines tables ne sont pas convertis donc perdus. Dire OK.



unlink nextcloud
sudo -u www-data ln -s /opt/source/nextcloud22/nextcloud/ nextcloud
sudo -u www-data ./console-7.4 upgrade
service php7.4-fpm reload


sudo -u www-data ./console-7.4 db:add-missing-columns
sudo -u www-data ./console-7.4 db:add-missing-indices
sudo -u www-data ./console-7.4 db:add-missing-primary-keys


migration:

    autoriser site_pec_nuage a se connecter dans /etc/passwd
    lancer un rsync depuis la vm vers ligatures dans un /tmp (ou tester un fichier dans le /data)
    comparer les fichiers de conf
    sudo -u php_pec_nuage ./console upgrade
    test de la v26
    update en v27