j-Serie Postgres startet nicht nach Neustart

Alle Geräte der Einsteiger j-Serie (Junior). Geräte für Privatanwender bis hin zu kleinen Firmen.
Status
Für weitere Antworten geschlossen.

zorro

Benutzer
Mitglied seit
06. Jul 2008
Beiträge
21
Punkte für Reaktionen
0
Punkte
0
Hallo,

seit einiger Zeit habe ich das Problem, dass die Postgress-Datenbank nicht mit dem Systemstart hochfährt. Auch der manuelle Start mit dem Startup-Script funktioniert nicht!
Rich (BBCode):
bash-3.2# /usr/syno/etc/rc.d/S20pgsql.sh restart
server stopped
sh: cannot create /dev/null: Permission denied
fgets failure: Success
The program "postgres" is needed by pg_ctl but was not found in the
same directory as "/usr/syno/pgsql/bin/pg_ctl".
Check your installation.
Das Executable ist aber da:
Rich (BBCode):
bash-3.2# ll /usr/syno/pgsql/bin/
drwxr-xr-x    2 root     root         1024 Apr  3  2009 .
drwxr-xr-x    5 root     root         1024 Apr  3  2009 ..
-rwxr-xr-x    1 root     root        43796 Mar 25  2009 createdb
-rwxr-xr-x    1 root     root        45524 Mar 25  2009 createuser
-rwxr-xr-x    1 root     root        43228 Mar 25  2009 dropdb
-rwxr-xr-x    1 root     root        43228 Mar 25  2009 dropuser
-rwxr-xr-x    1 root     root       124763 Mar 25  2009 initdb
-rwxr-xr-x    1 root     root       101974 Mar 25  2009 pg_ctl
-rwxr-xr-x    1 root     root       208644 Mar 25  2009 pg_dump
-rwxr-xr-x    1 root     root        59816 Mar 25  2009 pg_dumpall
-rwxr-xr-x    1 root     root        98484 Mar 25  2009 pg_restore
-rwxr-xr-x    1 root     root      3153476 Mar 25  2009 postgres
lrwxrwxrwx    1 root     root            8 Apr  3  2009 postmaster -> postgres
-rwxr-xr-x    1 root     root       206180 Mar 25  2009 psql
-rwxr-xr-x    1 root     root        29248 Mar 25  2009 vacuumdb
Ich muss in als User "admin" von Hand starten:
Rich (BBCode):
Maya> /usr/syno/pgsql/bin/postgres -D /volume1/@database/pgsql --config_file=/usr/syno/pgsql/etc/postgresql.conf --hba_file=/usr/syno/pgsql/etc/pg_hba.conf &
Maya> LOG:  could not create unrecognized address family 10 socket: Address family not supported by protocol
Die Neustarts von der Synology DS106j haben bislang immer problemlos funktioniert. Im /var/log/message-File finde ich folgende Einträge, die das Fehlen des Dienstes/Datenbank beschreiben:
Rich (BBCode):
Aug 29 09:33:46 synoindexd: pgsql.c (133) Failed to re-connect to (null), user: admin, db:mediaserver. (could not connect to server: N
o such file or directory ^IIs the server running locally and accepting ^Iconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? )
Aug 29 09:33:46 synoindexd: database.c (79) Failed to connect to database
Aug 29 09:33:46 synoindexd: database.c (1201) Failed to exec [VACUUM FULL ANALYZE].
Aug 29 09:33:46 synoindexd: synoindexd.c (383) vaccuum mediaserver failed.
Aug 29 09:33:46 synoindexd: pgsql.c (133) Failed to re-connect to (null), user: admin, db:photo. (could not connect to server: No such
 file or directory ^IIs the server running locally and accepting ^Iconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? )
Aug 29 09:33:46 synoindexd: database.c (158) Failed to connect to database
Aug 29 09:33:46 synoindexd: database.c (1220) Failed to exec [VACUUM FULL ANALYZE].
Aug 29 09:33:46 synoindexd: synoindexd.c (386) vaccuum photodb failed.
Aug 29 09:33:55 dms: _ReloadSetting(98) Buffer size [] is a wrong value and consider default buffer size: 8192
Aug 29 09:34:07 mt-daapd[1170]: pgsql.c (133) Failed to re-connect to (null), user: admin, db:mediaserver. (could not connect to serve
r: No such file or directory ^IIs the server running locally and accepting ^Iconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? )
Aug 29 09:34:07 mt-daapd[1170]: database.c (648) Failed to connect to database
Aug 29 09:34:07 mt-daapd[1170]: db-gdbm.c:db_init(555): Can not open database!!
Aug 29 09:34:07 mt-daapd[1170]: pgsql.c (133) Failed to re-connect to (null), user: admin, db:mediaserver. (could not connect to serve
r: No such file or directory ^IIs the server running locally and accepting ^Iconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? )
Aug 29 09:34:07 mt-daapd[1170]: database.c (648) Failed to connect to database
Aug 29 09:34:07 mt-daapd[1170]: SYNO_scan_playlist(412): MediaInfoDBOpen(MEDIA_TABLE_PLAYLIST, "*") failed!!
Aug 29 09:35:35 synoindexd: pgsql.c (133) Failed to re-connect to (null), user: admin, db:photo. (could not connect to server: No such
 file or directory ^IIs the server running locally and accepting ^Iconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? )
Aug 29 09:35:35 synoindexd: database.c (158) Failed to connect to database
Aug 29 09:35:35 synoindexd: database.c (1975) Failed to exec [Update photo_image set updated = '0'].
Aug 29 09:35:35 synoindexd: photo_index.c (893) Failed to set updated to 0 for all rows.
Aug 29 09:35:35 synoindexd: pgsql.c (133) Failed to re-connect to (null), user: admin, db:photo. (could not connect to server: No such file or directory ^IIs the server running locally and accepting ^Iconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? )
Aug 29 09:35:35 synoindexd: database.c (158) Failed to connect to database
Aug 29 09:35:35 synoindexd: database.c (1220) Failed to exec [VACUUM FULL ANALYZE].
Aug 29 09:35:35 synoindexd: pgsql.c (133) Failed to re-connect to (null), user: admin, db:photo. (could not connect to server: No such file or directory ^IIs the server running locally and accepting ^Iconnections on Unix domain socket "/tmp/.s.PGSQL.5432"? )
Aug 29 09:35:35 synoindexd: database.c (158) Failed to connect to database
Aug 29 09:35:35 synoindexd: photo_share.c (119) Failed to exec [Update photo_share set updated = '0'].
Aug 29 09:35:35 synoindexd: photo_share.c (808) Failed to set updated to 0 for all rows.
Was muss ich tun, damit bei einem Neustart des Synology der Postgres-Server wieder automatisch startet?
 
Status
Für weitere Antworten geschlossen.
 

Kaffeautomat

Wenn du das Forum hilfreich findest oder uns unterstützen möchtest, dann gib uns doch einfach einen Kaffee aus.

Als Dankeschön schalten wir deinen Account werbefrei.

:coffee:

Hier gehts zum Kaffeeautomat