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
Larvitz
npub1ue…qjlwv
2026-04-14 10:36:45 UTC
Author Public Key
npub1ueuurfmw4jgtz5uf3sxwcxdxvz8yx8a7yldnu5cyfwmlt55qz5tslqjlwvSeen on
wss://relay.momostr.pinkPublished at
2026-04-14 10:36:45 UTCEvent JSON
{
"id": "36be1e7c3ab0fb146c082264ddba87e15990bd539fca926a0badada68eef35f2",
"pubkey": "e679c1a76eac90b153898c0cec19a6608e431fbe27db3e53044bb7f5d2801517",
"created_at": 1776163005,
"kind": 1,
"tags": [
[
"t",
"sysadmin"
],
[
"t",
"nextcloud"
],
[
"t",
"freebsd"
],
[
"t",
"postgresql"
],
[
"t",
"selfhosted"
],
[
"proxy",
"https://mastodon.bsd.cafe/@Larvitz/116402618715683169",
"web"
],
[
"proxy",
"https://mastodon.bsd.cafe/users/Larvitz/statuses/116402618715683169",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.bsd.cafe/users/Larvitz/statuses/116402618715683169",
"pink.momostr"
],
[
"-"
]
],
"content": "Latest quarterly FreeBSD package upgrade broke my Nextcloud 😮💨\n\nPost 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.\n\nSolution:\n- Reinstalled postgresql17-server\n- Dumped the db with pg_dump\n- Installed postgresql18-server \u0026 php85-pdo_pgsql\n- Copied over pg_hba.conf \u0026 postgresql.conf\n- Created empty db/user in PG18\n- Imported the db dump\n- Ran occ maintenance:data-fingerprint\n\nRestarted php-fpm \u0026 nginx\n\nAll fine again. But that was unpleasant 🙂\n\n#SysAdmin #SelfHosted #FreeBSD #Nextcloud #Postgresql",
"sig": "bde5df4e0df1fc14455d8b9d8dfad27a1c076d85611baaf75d3c7af49a50f3a41f0bf7a63cae7c0cfa622f8eb1f19b012449da6669f254fb1cf5f8aa975680af"
}