Migration to Postgresql (YunoHost package)
HI all,
I'm trying to help updating the
Hubzilla YunoHost package. Because of the way YunoHost quality standards are designed the choice between postgresql and mysql during install has to be removed. The present maintainer of the package has chosen postgresql and is
currently working on having the database migration made during one of the next YunoHost package upgrades.
As it seems to be more difficult than expected, I'm trying to give a hand, but my knowledge in databases is very limited. I'm somehow getting closer, and if I'm not wrong, I'm nearly there, thanks to the migration tool available in the Hubzilla repo. Actually, I'm trying to use
the SQL file to do it.
Unfortunately the file is most certainly outdated, it is 9 years old, and when I try to use it I get those errors:
Warning: ERROR: relation "public.conv" does not exist
Warning: LINE 1: ...'public.conv_id_seq', COALESCE(MAX(id), 1) ) FROM public.con...
Warning: ^
Warning: ERROR: relation "public.fcontact" does not exist
Warning: LINE 1: ...lic.fcontact_id_seq', COALESCE(MAX(id), 1) ) FROM public.fco...
Warning: ^
Warning: ERROR: relation "public.ffinder" does not exist
Warning: LINE 1: ...blic.ffinder_id_seq', COALESCE(MAX(id), 1) ) FROM public.ffi...
Warning: ^
Warning: ERROR: relation "public.fserver" does not exist
Warning: LINE 1: ...blic.fserver_id_seq', COALESCE(MAX(id), 1) ) FROM public.fse...
Warning: ^
Warning: ERROR: relation "public.fsuggest" does not exist
Warning: LINE 1: ...lic.fsuggest_id_seq', COALESCE(MAX(id), 1) ) FROM public.fsu...
Warning: ^
Warning: ERROR: relation "public.group_member" does not exist
Warning: LINE 1: ...group_member_id_seq', COALESCE(MAX(id), 1) ) FROM public.gro...
Warning: ^
Warning: ERROR: relation "public.groups" does not exist
Warning: LINE 1: ...ublic.groups_id_seq', COALESCE(MAX(id), 1) ) FROM public.gro...
Warning: ^
Warning: ERROR: relation "public.mail" does not exist
Warning: LINE 1: ...'public.mail_id_seq', COALESCE(MAX(id), 1) ) FROM public.mai...
Warning: ^
Warning: ERROR: relation "public.manage" does not exist
Warning: LINE 1: ...ublic.manage_id_seq', COALESCE(MAX(id), 1) ) FROM public.man...
Warning: ^
Warning: ERROR: column "id" does not exist
Warning: LINE 1: ...ECT SETVAL('public.register_id_seq', COALESCE(MAX(id), 1) ) ...
Warning: ^
Warning: ERROR: relation "public.spam" does not exist
Warning: LINE 1: ...'public.spam_id_seq', COALESCE(MAX(id), 1) ) FROM public.spa...
Like I said, I know about zip when it comes to databases, so I was wondering if anyone would feel confident enough to help me here. Best scenario would be to have the migration related files in the Hubzilla repo updated, but any help would be more than welcome.
P.S.: Here are the repo and branch I'm currently working on :
#^https://github.com/dragondaddy/hubzilla_ynh/tree/fixdbmigration
