What type of hardware are you using: VPS bought online
What YunoHost version are you running: 12.0.12
What app is this about: AppFlowy
I tried to install AppFlowy on a subdomain, but it failed - see logfile.
Apparently the failure is due to E: Package 'postgresql-server-dev-17' has no installation candidate
As I am not an IT expert I appreciate every help.
Thank you
Is there no solution to the problem of installing Appflowy?
Hi,
Could you check apt search postgresql-server-dev ?
Did you try reinstalling after april 1st ?
Thank you very much, will do this evening and respond accordingly
This is the result
postgresql-server-dev-15/stable 15.12-0+deb12u2 amd64
development files for PostgreSQL 15 server-side programming
postgresql-server-dev-all/stable 248 amd64
extension build tool for multiple PostgreSQL versions
I did try to re-install it today, it has the same error message
Okay then…
If version 15 can be installed, I can’t understand why the script stops running. It’s euther 15 or 17. Let’s gather more info but not much hope there…
Could you share today’s installation log and the output of sudo apt install postgresql-server-dev-15 build-essential libssl-dev zlib1g-dev libbz2-dev libreadline-dev libsqlite3-dev libncursesw5-dev xz-utils tk-dev libxml2-dev libxmlsec1-dev libffi-dev liblzma-dev libpq-dev --simulate ?
The log for the simulation is:
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
build-essential is already the newest version (12.9).
build-essential set to manually installed.
libssl-dev is already the newest version (3.0.15-1~deb12u1).
libssl-dev set to manually installed.
zlib1g-dev is already the newest version (1:1.2.13.dfsg-1).
zlib1g-dev set to manually installed.
xz-utils is already the newest version (5.4.1-1).
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
libpq-dev : Depends: libpq5 (= 15.12-0+deb12u2) but 16.3-1.pgdg110+1 is to be installed
E: Unable to correct problems, you have held broken packages.
The Yunohost log of the installation:: https://paste.yunohost.org/raw/afuxahamud
Did you install other version of postgresql-server-dev by modifying apt sources ?
@otm33
no, did not. at least I am not aware of
Could you check psql --version ?
and the output of sudo apt install postgresql-server-dev-15 --simulate ?
On debian 12, only postgresql-server-dev-15 is available in official repo:
psql (PostgreSQL) 16.3 (Debian 16.3-1.pgdg110+1)
=> Appflowy installation script ( postgresql-server-dev-15 | 17)…
Does not sound like an easy way to solve it without breaking other Yunohost applications?
No, it does not because if you did not install (PostgreSQL) 16.3 it means another app did…
Beyond my know-how, sorry…
@otm33
Thank you for all the efforts and time you spent on my problem. I really appreciate it.
Now I know what the problem is.
I am wondering if my problem could be a more general problem in Yunohost worth solving or if it is too particular
No, I don’t think so because (afaik…) you can run two versions of PSQL (with differents ports, folders) but I’ve never had to do this and when I try something new, I prefer try it on my own YNH-test lab 
…
We should find out which app is using PostgreSQL 16 to run a test.
I’m talking nonsense: this is psql version but not postgresql-server-dev-x version… Could you check and share the output of
ls /etc/postgresqlpg_lsclusters apt install postgresql-server-dev-15 ?ls /etc/postgresql ==> 15 16
pg_lsclusters ==>
Ver Cluster Port Status Owner Data directory Log file
15 main 5432 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
16 main 5433 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log
Please note that I used sudo -i
sudo -i apt install postgresql-server-dev-15 ==>
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
libpq-dev : Depends: libpq5 (= 15.12-0+deb12u2) but 16.3-1.pgdg110+1 is to be installed
E: Unable to correct problems, you have held broken packages.
I guess you tried yet sudo apt --fix-broken install --simulate?
The response is:
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.