postgres 17.4-1 terminates automatically
bug
### Is this a new Bug?
- [x] I checked that the bug hasn't been reported before
### Package Name
postgresql
### Package Version
17.4-1
### Device Model
DS1515
### Device Architecture
ARMv7
### Firmware Version
DSM 7.1.1-42962 Update 9
### What happened?
I noticed gitea was offline. But it is postgres that fails to start.
Everytime I manually run the app from the package centre it stops after a second.
It says it is manually stopped, but I didn't do it.
I see no start or stop events in the package log so I don't know where to start debugging it.
I did have a powerfailure yesterday so maybe it is related?
### Reproduction steps
1. I don't know it
2.
3.
...
### Install Log
```log
2026/04/14 20:17:00 upgrade postgresql 11.16-3 Begin start-stop-status stop
waiting for server to shut down.... done
server stopped
2026/04/14 20:17:01 upgrade postgresql 11.16-3 End start-stop-status stop ret=[0]
2026/04/14 20:17:01 upgrade postgresql 11.16-3 Begin preupgrade
2026/04/14 20:17:01 Begin initialize_variables
2026/04/14 20:17:01 End initialize_variables
2026/04/14 20:17:01 ===> Step preupgrade. STATUS=UPGRADE USER=postgresql GROUP= SHARE_PATH=
2026/04/14 20:17:01 upgrade postgresql 11.16-3 End preupgrade ret=[0]
2026/04/14 20:17:01 upgrade postgresql 11.16-3 Begin preuninst
2026/04/14 20:17:01 Begin reload_inst_variables
2026/04/14 20:17:01 End reload_inst_variables
2026/04/14 20:17:01 Begin initialize_variables
2026/04/14 20:17:01 End initialize_variables
2026/04/14 20:17:01 ===> Step preuninst. STATUS=UPGRADE USER= GROUP= SHARE_PATH=
2026/04/14 20:17:01 Begin service_preuninst
2026/04/14 20:17:01 End service_preuninst
2026/04/14 20:17:01 upgrade postgresql 11.16-3 End preuninst ret=[0]
2026/04/14 20:17:02 upgrade postgresql 11.16-3 Begin /bin/rm -rf /volume3/@appstore/postgresql
2026/04/14 20:17:02 upgrade postgresql 11.16-3 End /bin/rm -rf /volume3/@appstore/postgresql ret=[0]
2026/04/14 20:17:02 upgrade postgresql 11.16-3 Begin /bin/rm -rf /volume3/@apptemp/postgresql
2026/04/14 20:17:02 upgrade postgresql 11.16-3 End /bin/rm -rf /volume3/@apptemp/postgresql ret=[0]
2026/04/14 20:17:02 upgrade postgresql 11.16-3 Begin postuninst
2026/04/14 20:17:02 Begin reload_inst_variables
2026/04/14 20:17:03 End reload_inst_variables
2026/04/14 20:17:03 Begin initialize_variables
2026/04/14 20:17:03 End initialize_variables
2026/04/14 20:17:03 ===> Step postuninst. STATUS=UPGRADE USER= GROUP= SHARE_PATH=
2026/04/14 20:17:03 upgrade postgresql 11.16-3 End postuninst ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin preinst
2026/04/14 20:17:03 Begin initialize_variables
2026/04/14 20:17:03 End initialize_variables
2026/04/14 20:17:03 ===> Step preinst. STATUS=UPGRADE USER=postgresql GROUP= SHARE_PATH=
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End preinst ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/mkdir -p /volume3/@appstore/postgresql -m 755
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/mkdir -p /volume3/@appstore/postgresql -m 755 ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/rm -rf /volume3/@appstore/postgresql
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/rm -rf /volume3/@appstore/postgresql ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/package /volume3/@appstore/postgresql
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/package /volume3/@appstore/postgresql ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/rm -rf /var/packages/postgresql
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/rm -rf /var/packages/postgresql ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/mkdir -p /var/packages/postgresql -m 755
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/mkdir -p /var/packages/postgresql -m 755 ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/touch /var/packages/postgresql/installing
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/touch /var/packages/postgresql/installing ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/INFO /var/packages/postgresql/INFO
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/INFO /var/packages/postgresql/INFO ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/rm -rf /var/packages/postgresql/scripts
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/rm -rf /var/packages/postgresql/scripts ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/scripts /var/packages/postgresql/scripts
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/scripts /var/packages/postgresql/scripts ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/rm -rf /var/packages/postgresql/WIZARD_UIFILES
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/rm -rf /var/packages/postgresql/WIZARD_UIFILES ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/WIZARD_UIFILES /var/packages/postgresql/WIZARD_UIFILES
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/WIZARD_UIFILES /var/packages/postgresql/WIZARD_UIFILES ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/rm -rf /var/packages/postgresql/conf
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/rm -rf /var/packages/postgresql/conf ret=[0]
2026/04/14 20:17:03 upgrade postgresql 17.4-1 Begin /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/conf /var/packages/postgresql/conf
2026/04/14 20:17:03 upgrade postgresql 17.4-1 End /bin/mv -f /volume3/@tmp/synopkg/install.RwuR8e/conf /var/packages/postgresql/conf ret=[0]
2026/04/14 20:17:07 upgrade postgresql 17.4-1 Begin postinst
2026/04/14 20:17:07 Begin initialize_variables
2026/04/14 20:17:07 End initialize_variables
2026/04/14 20:17:07 ===> Step postinst. STATUS=UPGRADE USER=postgresql GROUP= SHARE_PATH=
2026/04/14 20:17:07 Begin save_wizard_variables
2026/04/14 20:17:07 End save_wizard_variables
2026/04/14 20:17:07 Begin syno_sync_var_folder
2026/04/14 20:17:07 End syno_sync_var_folder
2026/04/14 20:17:07 Begin service_postinst
2026/04/14 20:17:07 /volume3/@appstore/postgresql/bin/initdb: error while loading shared libraries: /var/packages/postgresql/target/lib/libicudata.so.77: internal error
2026/04/14 20:17:07 sed: can't read /volume3/@appdata/postgresql/data/postgresql.conf: Permission denied
2026/04/14 20:17:07 sed: can't read /volume3/@appdata/postgresql/data/postgresql.conf: Permission denied
2026/04/14 20:17:07 sed: can't read /volume3/@appdata/postgresql/data/postgresql.conf: Permission denied
2026/04/14 20:17:07 pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/04/14 20:17:07 psql: error: connection to server on socket "/volume3/@appdata/postgresql/.s.PGSQL.5433" failed: No such file or directory
2026/04/14 20:17:07 Is the server running locally and accepting connections on that socket?
2026/04/14 20:17:07 psql: error: connection to server on socket "/volume3/@appdata/postgresql/.s.PGSQL.5433" failed: No such file or directory
2026/04/14 20:17:07 Is the server running locally and accepting connections on that socket?
2026/04/14 20:17:07 sed: can't read /volume3/@appdata/postgresql/data/pg_hba.conf: Permission denied
2026/04/14 20:17:07 pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/04/14 20:17:07 End service_postinst
/var/packages/postgresql/scripts/installer: line 166: /volume3/@appdata/postgresql/postgresql.log: Permission denied
2026/04/14 20:17:07 upgrade postgresql 17.4-1 End postinst ret=[0]
2026/04/14 20:17:07 upgrade postgresql 17.4-1 Begin postupgrade
2026/04/14 20:17:07 Begin initialize_variables
2026/04/14 20:17:07 End initialize_variables
2026/04/14 20:17:07 ===> Step postupgrade. STATUS=UPGRADE USER=postgresql GROUP= SHARE_PATH=
2026/04/14 20:17:07 Begin syno_sync_var_folder
2026/04/14 20:17:07 End syno_sync_var_folder
2026/04/14 20:17:07 upgrade postgresql 17.4-1 End postupgrade ret=[0]
2026/04/14 20:17:08 upgrade postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/04/14 20:17:08 upgrade postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/02 07:05:49 (system) trigger postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 07:05:50 (system) trigger postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/02 07:34:25 (system) trigger postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 07:34:26 (system) trigger postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/02 07:37:20 (system) trigger postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 07:37:20 (system) trigger postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/02 08:36:34 start postgresql 17.4-1 Begin start-stop-status stop
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 08:36:34 start postgresql 17.4-1 End start-stop-status stop ret=[0]
2026/05/02 08:36:37 start postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 08:36:37 start postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/02 08:36:51 start postgresql 17.4-1 Begin start-stop-status stop
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 08:36:51 start postgresql 17.4-1 End start-stop-status stop ret=[0]
2026/05/02 08:36:54 start postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 08:36:54 start postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/02 08:41:34 start postgresql 17.4-1 Begin start-stop-status stop
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 08:41:34 start postgresql 17.4-1 End start-stop-status stop ret=[0]
2026/05/02 08:41:36 start postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/02 08:41:36 start postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/03 14:02:31 start postgresql 17.4-1 Begin start-stop-status stop
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/03 14:02:31 start postgresql 17.4-1 End start-stop-status stop ret=[0]
2026/05/03 14:02:34 start postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/03 14:02:34 start postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/03 14:15:56 start postgresql 17.4-1 Begin start-stop-status stop
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/03 14:15:56 start postgresql 17.4-1 End start-stop-status stop ret=[0]
2026/05/03 14:15:59 start postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/03 14:15:59 start postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/03 14:26:57 start postgresql 17.4-1 Begin start-stop-status stop
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/03 14:26:57 start postgresql 17.4-1 End start-stop-status stop ret=[0]
2026/05/03 14:27:00 start postgresql 17.4-1 Begin start-stop-status start
pg_ctl: could not open PID file "/volume3/@appdata/postgresql/data/postmaster.pid": Permission denied
2026/05/03 14:27:00 start postgresql 17.4-1 End start-stop-status start ret=[0]
```
### Service Log
```log
2026-04-14 20:17:00.845 CEST [12323] LOG: received fast shutdown request
2026-04-14 20:17:00.934 CEST [12323] LOG: aborting any active transactions
2026-04-14 20:17:00.934 CEST [6306] FATAL: terminating connection due to administrator command
2026-04-14 20:17:00.934 CEST [29584] FATAL: terminating connection due to administrator command
2026-04-14 20:17:00.936 CEST [12323] LOG: background worker "logical replication launcher" (PID 15419) exited with exit code 1
2026-04-14 20:17:00.938 CEST [15414] LOG: shutting down
2026-04-14 20:17:01.282 CEST [12323] LOG: database system is shut down
```
### Other Logs
```log
#sudo tail /var/log/synopkg.log
2026/05/03 14:26:57 Release usr-local-linker for postgresql when 0x0008 (done)
2026/05/03 14:26:59 start postgresql: stop version 17.4-1 successfully, result 0
2026/05/03 14:26:59 start postgresql: begin to start version 17.4-1
2026/05/03 14:26:59 Acquire usr-local-linker for postgresql when 0x0008 (ready)
2026/05/03 14:26:59 Acquire usr-local-linker for postgresql when 0x0008 (done)
2026/05/03 14:26:59 Acquire port-config for postgresql when 0x0008 (ready)
2026/05/03 14:26:59 Acquire port-config for postgresql when 0x0008 (done)
2026/05/03 14:27:00 start postgresql 17.4-1 Begin start-stop-status start
2026/05/03 14:27:00 start postgresql 17.4-1 End start-stop-status start ret=[0]
2026/05/03 14:27:02 start postgresql: start version 17.4-1 successfully, result 0
```
关闭于 2026-05-17 39 条评论