:~$
```
Normal?
---
### Author:  [@blodarn](https://forum.yunohost.org/u/blodarn)
#### Post date: [November 2, 2024, 8:03pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/4 "2024-11-02T20:03:31Z")
> [@Aleks](#):
>
> sudo pg\_listclusters
It was :
```auto
$ sudo pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
11 main 5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
15 main 5433 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
```
I don’t have the right version apparently : postgresql-15
---
### Author:  [@Aleks](https://forum.yunohost.org/u/Aleks)
#### Post date: [November 2, 2024, 10:01pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/5 "2024-11-02T22:01:41Z")
Hmfokay so let’s look at : `sudo aptitude why postgresql-11`
---
### Author:  [@blodarn](https://forum.yunohost.org/u/blodarn)
#### Post date: [November 2, 2024, 10:07pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/6 "2024-11-02T22:07:33Z")
> [@Aleks](#):
>
> sudo aptitude why postgresql-11
```auto
sudo aptitude why postgresql-11
i joplin-ynh-deps Depends postgresql-client
i A postgresql-client-11 Provides postgresql-client
i A postgresql-client-11 Suggests postgresql-11
```
---
### Author:  [@Aleks](https://forum.yunohost.org/u/Aleks)
#### Post date: [November 2, 2024, 10:09pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/7 "2024-11-02T22:09:49Z")
Hmf okay, `postgresql-client-11 Provides postgresql-client` … but so does version 15 …
So let’s try to see what `apt remove postgresql-11 --dry-run` says, does it warn about important stuff that would get removed besides postgresql 11 ?
---
### Author:  [@blodarn](https://forum.yunohost.org/u/blodarn)
#### Post date: [November 2, 2024, 10:26pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/8 "2024-11-02T22:26:09Z")
> [@Aleks](#):
>
> apt remove postgresql-11 --dry-run
```auto
apt remove postgresql-11 --dry-run
NOTE: This is only a simulation!
apt needs root privileges for real execution.
Keep also in mind that locking is deactivated,
so don't depend on the relevance to the real current situation!
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
libicu63 libldap-2.4-2 libllvm7
Use 'apt autoremove' to remove them.
The following packages will be REMOVED:
postgresql-11
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
Remv postgresql-11 [11.18-0+deb10u1]
```
---
### Author:  [@Aleks](https://forum.yunohost.org/u/Aleks)
#### Post date: [November 2, 2024, 10:55pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/9 "2024-11-02T22:55:39Z")
Alrighty it should be fine to remove it then, using `sudo apt remove postgresql-11`
And then we should check with `sudo pg_lsclusters` that postgresql 15 now listens to port 5432
---
### Author:  [@blodarn](https://forum.yunohost.org/u/blodarn)
#### Post date: [November 2, 2024, 10:59pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/10 "2024-11-02T22:59:47Z")
> [@Aleks](#):
>
> sudo pg\_lsclusters
Executed : sudo apt remove postgresql-11
After :
```auto
sudo pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
11 main 5432 down,binaries_missing postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
15 main 5433 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
```
But instance Yunohost seems to be down now…
---
### Author:  [@Aleks](https://forum.yunohost.org/u/Aleks)
#### Post date: [November 2, 2024, 11:03pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/11 "2024-11-02T23:03:47Z")
hmmmoay so let’s try somthing else by changing the port in the config ? Using:
`sudo sed 's/5432/5499/g' -i /etc/postgresql/11/main/postgresql.conf`
and
`sudo sed 's/5433/5432/g' -i /etc/postgresql/15/main/postgresql.conf`
and then `sudo systemctl restart postgresql` and `sudo pg_lsclusters` to confirm the change ?
---
### Author:  [@blodarn](https://forum.yunohost.org/u/blodarn)
#### Post date: [November 2, 2024, 11:09pm UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/12 "2024-11-02T23:09:59Z")
> [@Aleks](#):
>
> sudo pg\_lsclusters
Back online!
I restarted Joplin service.
There is a new error regarding user joplin that doesn’t exist. It should be with my main user I guess.
Perhaps I should reinstall the app ?
Logs :
[https://paste.yunohost.org/qiqefirero](https://paste.yunohost.org/qiqefirero)
---
### Author:  [@blodarn](https://forum.yunohost.org/u/blodarn)
#### Post date: [November 3, 2024, 12:57am UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/13 "2024-11-03T00:57:04Z")
After re-installing Joplin, everything works !
Thank you @Aleks !
Complete solution :
1. Inspect : sudo pg\_lsclusters
```auto
Ver Cluster Port Status Owner Data directory Log file
11 main 5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
15 main 5433 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
```
1. sudo aptitude why postgresql-11
```auto
i joplin-ynh-deps Depends postgresql-client
i A postgresql-client-11 Provides postgresql-client
i A postgresql-client-11 Suggests postgresql-11
```
1. apt remove postgresql-11 --dry-run
```auto
apt remove postgresql-11 --dry-run
NOTE: This is only a simulation!
apt needs root privileges for real execution.
Keep also in mind that locking is deactivated,
so don't depend on the relevance to the real current situation!
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
libicu63 libldap-2.4-2 libllvm7
Use 'apt autoremove' to remove them.
The following packages will be REMOVED:
postgresql-11
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
Remv postgresql-11 [11.18-0+deb10u1]
```
1. Remove wrong version of postgresql : sudo apt remove postgresql-11
2. Inspect : sudo pg\_lsclusters
```auto
Ver Cluster Port Status Owner Data directory Log file
11 main 5432 down,binaries_missing postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
15 main 5433 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
```
1. If no more access to Yunohost instance, try :
2. sudo sed ‘s/5432/5499/g’ -i /etc/postgresql/11/main/postgresql.conf
3. sudo sed ‘s/5433/5432/g’ -i /etc/postgresql/15/main/postgresql.conf
4. sudo systemctl restart postgresql
5. sudo pg\_lsclusters
6. Yunohost instance should be back online
7. Reinstall Joplin
---
### Author:  [@system](https://forum.yunohost.org/u/system)
#### Post date: [November 18, 2024, 12:57am UTC](https://forum.yunohost.org/t/after-installing-joplin-error-postgres-version-not-supported/31741/14 "2024-11-18T00:57:46Z")
This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.