Latest quarterly FreeBSD package upgrade broke my Nextcloud 😮‍💨

[larvitz@mastodon.bsd.cafe]

Latest quarterly FreeBSD package upgrade broke my Nextcloud ‍

Post mortem: The new version of php85-pdo_pgsql is now compiled against PostgreSQL 18, not 17. So pkg upgrade removed postgresql17-server, leaving Nextcloud dysfunctional without a database.

Solution:
- Reinstalled postgresql17-server
- Dumped the db with pg_dump
- Installed postgresql18-server & php85-pdo_pgsql
- Copied over pg_hba.conf & postgresql.conf
- Created empty db/user in PG18
- Imported the db dump
- Ran occ maintenance:data-fingerprint

Restarted php-fpm & nginx

All fine again. But that was unpleasant

#SysAdmin #SelfHosted #FreeBSD #Nextcloud #Postgresql

[db_geek@norden.social]

@Larvitz
Sounds a little bit like Arch Linux.

Package of new PostgreSQL major version is stable?
So just replace package of installed PostgreSQL major version with new major version.
Database migration to new major version?
That's on you, user.
After that I learned something about IgnorePkg settings.

That's why I liked the slot mechanism of Gentoo, where such problems could be avoided.

[larvitz@mastodon.bsd.cafe]

@db_geek Yeah that wasn't ideal. But I could solve it in approx. 20 minutes via dump+restore. The php-pdo package now is linked to postgres18..

But that could have been avoided by using the FreeBSD Ports system (/usr/ports) where you have control about the dependencies of software. Not using ports was a trade-off, that I was aware which consequences it implies and I accepted that.

[freezr@friendica.myportal.social]

@Larvitz

I don't really get it what you stated.
A OS that is supposedly to be tailored more toward server side rather than desktop site shouldn't break stuff... ‍️

[t0maz@floss.social]

@freezr @Larvitz I wouldn’t say it broke it. When new DB server is required as dependency then pkg manager shows that previous server will be removed. This is signal for admin to dump/transfer data to new server. It seems that this time user overlooked what pkg manager said it will do.
Not sure how it is on other systems but on FreeBSD the package manger is not automagically transfer databases between servers when there is a major DB server update.