# Synapse & postgresql

**URL:** https://forum.yunohost.org/t/synapse-postgresql/21532
**Category:** Support
**Tags:** french
**Created:** [October 2, 2022, 7:37pm UTC](https://forum.yunohost.org/t/synapse-postgresql/21532 "2022-10-02T19:37:06Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Bachy](https://forum.yunohost.org/user_avatar/forum.yunohost.org/bachy/32/30_2.png) [@Bachy](https://forum.yunohost.org/u/Bachy)
#### Post date: [October 3, 2022, 9:33am UTC](https://forum.yunohost.org/t/synapse-postgresql/21532/2 "2022-10-03T09:33:35Z")

</div>

bon j’avance,  
va savoir pourquoi postgresql était configuré pour écouter le port 5433

```auto
netstat -nltp | grep postgres
tcp 0 0 127.0.0.1:5433 0.0.0.0:* LISTEN 13665/postgres      
tcp6 0 0 ::1:5433 :::* LISTEN 13665/postgres      

```

donc j’ai changé la config en éditant le fichier suivant

```auto
grep -r "5433" /etc/
/etc/postgresql/13/main/postgresql.conf:port = 5433 # (change requires restart)

```

par contre mon cluster ne démarre pas au démarrage du service postgresql, je dois encore résoudre ça

```auto
# je demarre le service postgres
$ yunohost service start postgresql
Success! Service 'postgresql' started

# raté
$ yunohost service status postgresql
configuration: unknown
description: Stores app data (SQL database)
last_state_change: 1970-01-01 02:00:00
start_on_boot: enabled
status: dead

# le cluster est down
$ pg_lsclusters 
Ver Cluster Port Status Owner Data directory Log file
13 main 5432 down postgres /var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log

# je redémarre le cluster
$ pg_ctlcluster 13 main restart

# il est up
$ pg_lsclusters 
Ver Cluster Port Status Owner Data directory Log file
13 main 5432 online postgres /var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log

# le service est active
$ yunohost service status postgresql
configuration: unknown
description: Stores app data (SQL database)
last_state_change: 2022-10-03 11:14:44
start_on_boot: enabled
status: running

# synapse fonctionne

```

---

_[View the full topic](https://forum.yunohost.org/t/synapse-postgresql/21532)._