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!
Das Executable ist aber da:
Ich muss in als User "admin" von Hand starten:
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:
Was muss ich tun, damit bei einem Neustart des Synology der Postgres-Server wieder automatisch startet?
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.
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
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
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.