[00:34:06]
<DJ Chase (fae/faer)> there were definately some syntax errors there, but i'm not sure if there's an extra step to it or something because the live page still has the issue
[05:47:04]
<Yunohost Git/Infra notifications> [issues] WARNING: unknown issues action: locked
[12:34:25]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-zones: Revert split named config into small zones ([b863ed12](https://github.com/YunoHost/dynette/commit/b863ed125278eca8c8d0b8a0916d3b84daaa8f09))
[12:36:50]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-zones: Split named config into small zones This reverts commit b863ed125278eca8c8d0b8a0916d3b84daaa8f09. ([363669e6](https://github.com/YunoHost/dynette/commit/363669e63bc699e58b855ac7f2f57ae38d184cec))
[12:36:54]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: Revert split named config into small zones ([b863ed12](https://github.com/YunoHost/dynette/commit/b863ed125278eca8c8d0b8a0916d3b84daaa8f09))
[12:36:57]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: Revert split named config into small zones ([dc72e338](https://github.com/YunoHost/dynette/commit/dc72e3388de40c2def92d1c473f3bd3b6140540c))
[12:37:03]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: fix dynette after adding a column ([798dccfb](https://github.com/YunoHost/dynette/commit/798dccfbb9d68a667f5214b3387824b9bd354717))
[12:37:54]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: dnstap_monitor: doesnt remove the socket at startup time ([5ee2cd11](https://github.com/YunoHost/dynette/commit/5ee2cd11f136710ab7fff3df9b61a35532536076))
[13:22:54]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: use a flag file for systemd.path notif ([ddc39107](https://github.com/YunoHost/dynette/commit/ddc39107430743e4278d17e09ec2cb96c119efca))
[13:33:02]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: ruff format ([f4865945](https://github.com/YunoHost/dynette/commit/f4865945944d3c8c7caa0813a3984f6e0e400a38))
[14:32:16]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: Fix pytests ([8d091c67](https://github.com/YunoHost/dynette/commit/8d091c675c2ecf6593d40c9aa401971079b3018b))
[18:19:24]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: fix dynette password in db ([3cbb7fa5](https://github.com/YunoHost/dynette/commit/3cbb7fa58ceb3e24c5d1de7e70f8a9dc784935cf))
[18:19:24]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: dnstap_monitor: accept systemd unix sockets ([3aad03aa](https://github.com/YunoHost/dynette/commit/3aad03aa9fc3edda2c0ae58a2e0872645e41c8ba))
[19:06:58]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: Fix client password setting ([53e7be02](https://github.com/YunoHost/dynette/commit/53e7be02921125b82483e82e5f5b6c724cb82e97))
[19:06:58]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: ruff format ([05692af5](https://github.com/YunoHost/dynette/commit/05692af5b46551dacc4b009f2e81d8c7999f3720))
[19:06:59]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: regen_named_conf: allow running manually ([36feb3a6](https://github.com/YunoHost/dynette/commit/36feb3a6fc4f8a525e9bc2f35f3028361c3024a5))
[20:40:22]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: migrate_old_db: fix modified args ([29badbfb](https://github.com/YunoHost/dynette/commit/29badbfba5276a256e109e9a2f77048fad0fac83))
[20:58:22]
<rodinux> hello, can someone tell me if it is safe add a repository for postgresql-15 on a current stable yunohost without breaking anything ?
[20:58:25]
<orhtej2> > <@rodinux:matrix.org> hello, can someone tell me if it is safe add a repository for postgresql-15 on a current stable yunohost without breaking anything ?
15 is shipped with bookworm already
[20:58:25]
<rodinux> yes but my problem is with the package postgresql-15-pgvector not in the debian repo, it breaks the backup for upgrading discourse : https://github.com/YunoHost-Apps/discourse_ynh/issues/375
[21:11:31]
<rodinux> Or I could try build it ? not sure to understand how to do it well...
[21:11:32]
<rodinux> a solution is force the upgrade without backing up first, but I am a little scarred...
[21:11:32]
<DJ Chase (fae/faer)> why not backup first?
[21:14:16]
<rodinux> it breaks
```
2026-02-13 12:34:09,688: DEBUG - + sudo --login --user=postgres pg_dump discourse
2026-02-13 12:34:10,537: WARNING - pg_dump: error: Dumping the contents of table "ai_document_fragments_embeddings" failed: PQgetResult() failed.
2026-02-13 12:34:10,538: WARNING - pg_dump: detail: Error message from server: ERROR: could not access file "$libdir/vector": No such file or directory
2026-02-13 12:34:10,539: WARNING - pg_dump: detail: Command was: COPY public.ai_document_fragments_embeddings (rag_document_fragment_id, model_id, model_version, strategy_id, strategy_version, digest, embeddings, created_at, updated_at) TO stdout;
2026-02-13 12:34:10,545: DEBUG - + ynh_exit_properly
```
[21:18:14]
<rodinux> another solution is to backup the vm first ( It's on a proxmox ), try upgrade discourse without backup and pray it works or restore, but if I could do a backup of the db first it could be better...
[21:25:34]
<rodinux> I have a cron to backup the BDDs daily and I can confirm the pg_dump for discourse is not working with the same error
```
pg_dump: error: Dumping the contents of table "ai_document_fragments_embeddings" failed: PQgetResult() failed.
pg_dump: detail: Error message from server: ERROR: could not access file "$libdir/vector": No such file or directory
pg_dump: detail: Command was: COPY public.ai_document_fragments_embeddings (rag_document_fragment_id, model_id, model_version, strategy_id, strategy_version, digest, embeddings, created_at, updated_at) TO stdout;
[21:30:41]
<rodinux> Perhaps a better solution is to build the `pgvector` ?
[21:52:03]
<rodinux> I think I need install `postgresql-server-dev-15` and `make`
I need specify the path to pg_config ?? `export PG_CONFIG=/usr/lib/postgresql/15/bin/pg_config`
Something like this ?
```
cd /tmp
git clone --branch v0.8.2 https://github.com/pgvector/pgvector.git
cd pgvector
export PG_CONFIG=/usr/lib/postgresql/15/bin/pg_config
make
sudo --preserve-env=PG_CONFIG make install
[21:52:06]
<rodinux> Does I need be on a shell with the app ??
[21:52:08]
<miro5001> What psql versions are on your server?
[21:52:09]
<rodinux> ```
root@yuno:~# ls /usr/lib/postgresql/
13 15
[21:52:10]
<rodinux> ```
root@yuno:~# pg_config --version
PostgreSQL 15.16 (Debian 15.16-0+deb12u1)
[21:52:10]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-refactoring: client: remove verify=false that was only there for debugging ([0b4063c1](https://github.com/YunoHost/dynette/commit/0b4063c1f9f65eb69ab20994ab455a3958df21d5))
[21:52:10]
<rodinux> 2 apps using postgresql, nextcloud and discourse
[21:52:11]
<Yunohost Git/Infra notifications> [dynette] Salamandar deleted branch fpu-refactoring
[21:52:11]
<Yunohost Git/Infra notifications> [dynette] Salamandar merged [pull request #27](https://github.com/YunoHost/dynette/pull/27): Revamping of Dynette
[21:52:12]
<orhtej2> are you migrating to trixie or something?
[21:52:12]
<orhtej2> so installing `postgresql-15-pgvector` should just work (TM)
[21:52:12]
<orhtej2> rodinux: interestingly [discourse provisions pgvector from apt](https://github.com/YunoHost-Apps/discourse_ynh/blob/80071cd67103f95b5438b4a49689e25ff05725cd/manifest.toml#L145) already and the repo *is* added
[21:52:13]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to enh-include: [enh] Avoid to generate tons of lines to grant permissions ([cf35f09e](https://github.com/YunoHost/dynette/commit/cf35f09e173086328c4b4ef50ef30fa52301e5dd))
[21:52:13]
<orhtej2> because Trixie ships `postgresql-17-pgvector` from their main deb source
[21:52:13]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to statistics: Add statistics scripts ([cd463e71](https://github.com/YunoHost/dynette/commit/cd463e71ee5f16f10a58f78ea574d2d8f8fdc356))
[21:52:49]
<rodinux> No I just try upgrade from 3.5.2~ynh1
[21:52:50]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to fpu-zones: Split named config into small zones This reverts commit b863ed125278eca8c8d0b8a0916d3b84daaa8f09. ([f1d08ad4](https://github.com/YunoHost/dynette/commit/f1d08ad405ce7d9443d07d34c26c497c617dfd96))
[21:53:35]
<rodinux> I see here this commit https://github.com/YunoHost-Apps/discourse_ynh/commit/08c8bf5c8bc28f74fb85afb66ed0cc07b49310dd#diff-06ac558c9cfca9e31a9a235f18d98e6d0c3bfee8bee0088108a29f2c60b318e3
[21:54:25]
<rodinux> ```
root@yuno:~# apt search postgresql-pgvector
Sorting... Done
Full Text Search... Done
root@yuno:~# apt search postgresql-15-pgvector
Sorting... Done
Full Text Search... Don
[21:57:12]
<orhtej2> do you have postgresql-dpdg or whatever it is called in sources.list?
[21:57:59]
<rodinux> no
[22:00:18]
<rodinux> but indeed in `/etc/yunohost/apps/discourse/manifest.toml` I see
```
[resources.apt.extras.postgresql]
repo = "deb https://apt.postgresql.org/pub/repos/apt __YNH_DEBIAN_VERSION__-pgdg main 15"
key = "https://www.postgresql.org/media/keys/ACCC4CF8.asc"
packages = [
"postgresql-15-pgvector",
]
[22:04:55]
<rodinux> but is missing on `ynh-deps`
```
root@yuno:~# dpkg -l | grep deps
ii collabora-ynh-deps 25.04.8.2~ynh4 all Fake package for collabora (YunoHost app) dependencies
ii dolibarr-ynh-deps 22.0.4~ynh6 all Fake package for dolibarr (YunoHost app) dependencies
ii my-webapp--2-ynh-deps 1.0~ynh21 all Fake package for my_webapp__2 (YunoHost app) dependencies
ii my-webapp-ynh-deps 1.0~ynh21 all Fake package for my_webapp (YunoHost app) dependencies
ii nextcloud-ynh-deps 31.0.9~ynh2 all Fake package for nextcloud (YunoHost app) dependencies
ii phpmyadmin-ynh-deps 5.2.3~ynh1 all Fake package for phpmyadmin (YunoHost app) dependencies
ii roundcube-ynh-deps 1.6.13~ynh1 all Fake package for roundcube (YunoHost app) dependencies
[22:16:18]
<orhtej2> I mean does `collabora-ynh-deps` depend on it?
[22:16:21]
<orhtej2> check the output of `apt-cache depends collabora-ynh-deps`, is `pgvector` there?
[22:18:41]
<rodinux> no, I don't think so, the extra_repository_dependencies for collabora was to add `contrib` and `non-free-firmware`... now with next release it will no more necessary...
[22:18:50]
<rodinux> I said that because when you add in the manifest.toml a ressource extra it may add a package `app-ynh-deps`, isn't it ?
[22:18:53]
<rodinux> ```
apt-cache depends collabora-ynh-deps
collabora-ynh-deps
Depends: hunspell-de-de
Depends: hunspell-en-gb
Depends: hunspell-fr
Depends: hunspell
Depends: libfontconfig1-dev
libfontconfig-dev
Depends: ttf-mscorefonts-installer
Depends: coolwsd
Depends: code-brand
[22:19:21]
<orhtej2> nice, wtf?
[22:19:28]
<orhtej2> as in it should depend on stuff?
[22:19:33]
<orhtej2> unless you're way behind the current release?
[22:28:06]
<rodinux> yes for collabora, I can upgrade it now...
[22:28:15]
<rodinux> also for nextcloud on postgresql branch, I am waiting before upgrading to 32...
[22:40:09]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to main: ruff format ([5f9d61e9](https://github.com/YunoHost/dynette/commit/5f9d61e9caa3f309a17a3941ddaad32499d7affe))
[22:40:10]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to statistics: Add statistics utility ([62169a3c](https://github.com/YunoHost/dynette/commit/62169a3ccc65773890b33146b2e96c24d62c293d))
[22:50:48]
<Yunohost Git/Infra notifications> [dynette] Salamandar pushed to statistics: Add statistics utility ([95061dd0](https://github.com/YunoHost/dynette/commit/95061dd06800df711a160a5c1efb17f569b54663))
[22:50:49]
<rodinux> Well, I found a the log (old one) of last upgrade of discourse https://paste.yunohost.org/raw/irarasugex
[23:04:41]
<rodinux> it seems the upgrade have installed the package `postgresql-15-pgvector` ???
[23:05:09]
<miro5001> "hey discourse, use psql 15"
"hell no, I am used to the old 13"
[23:14:28]
<rodinux> here is using 15
```
root@yuno:~# yunohost app shell discourse
/var/www/discourse /root
/root
discourse@yuno:~/discourse$ psql -V
psql (PostgreSQL) 15.16 (Debian 15.16-0+deb12u1)