Backup wiederherstellen
-
@andré-koschnik sagte in Backup wiederherstellen:
muss ich das beheben?wenn ja wie?
@thomas-braun sagte in Backup wiederherstellen:
@andré-koschnik sagte in Backup wiederherstellen:
die sind aber nach einem neustart wieder weg oder?
Sollte...
Odersudo umount /opt/iobroker/backups@andré-koschnik sagte in Backup wiederherstellen:
wieso gibt es keinen port der auf 5432 hört?
ich komme mit dem PG admin von anderen rechnern an die db
und kann ich das backfile der postgres per pg admin einspielen.
Das SQL Script was sich darin verbirgt kann ich nicht im PG admin ausführen.das hat doch nichts mit iobroker zu tun!
oder? -
nein sorry,
dachte nur weil die backup node für die postges DB nicht funktioniert
-
@andré-koschnik sagte in Backup wiederherstellen:
weil die backup node für die postges DB nicht funktioniert
???
was hat das mit Backitup zu tun?
-
in der ssh konsole kann ich mich verbinden
sudo psql --host=localhost --port=5432 --username=iobroker --password --dbname=anko_iobroker_v1 Password: psql (13.12 (Debian 13.12-1.pgdg120+1)) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off) Type "help" for help. anko_iobroker_v1=# \qwieso mach es backitup nicht
-
egal ihr hab mir schon weitergeholfen.
vielen dank dafür. -
@andré-koschnik sagte in Backup wiederherstellen:
wieso mach es backitup nicht
ist das so?
wie sieht denn ein debug-log vom mount-Versuch von backitup aus?
-
wie gesagt... bin ein mausschubser.
hätte gedacht wenn ich das per ssh kann sollte der adapter das auch können
-
@andré-koschnik sagte in Backup wiederherstellen:
bin ein mausschubser.
und ein Fotograf!
der Fehler steht da, aber aus Bildern kann ich nicht zitieren.
Außerdrm ist das nicht das debug-log von backitup
https://forum.iobroker.net/topic/51555/hinweise-für-gute-forenbeiträge/1
-
backitup.0 2023-11-09 13:54:13.412 error [pgsql] Is the server running on that host and accepting TCP/IP connections? backitup.0 2023-11-09 13:54:13.407 error [pgsql] pg_dump: error: connection to database "anko_iobroker_v1" failed: connection to server at "192.168.100.104", port 5432 failed: Connection refused backitup.0 2023-11-09 13:53:56.020 error [pgsql] postgresql Restore not completed backitup.0 2023-11-09 13:53:56.015 error [pgsql] Error: EPERM: operation not permitted, utime '/opt/iobroker/backups/pgsql_restore_backupiobroker.sql' -
@andré-koschnik sagte in Backup wiederherstellen:
backitup.0 2023-11-09 13:54:13.412 error [pgsql] Is the server running on that host and accepting TCP/IP connections? backitup.0 2023-11-09 13:54:13.407 error [pgsql] pg_dump: error: connection to database "anko_iobroker_v1" failed: connection to server at "192.168.100.104", port 5432 failed: Connection refused backitup.0 2023-11-09 13:53:56.020 error [pgsql] postgresql Restore not completed backitup.0 2023-11-09 13:53:56.015 error [pgsql] Error: EPERM: operation not permitted, utime '/opt/iobroker/backups/pgsql_restore_backupiobroker.sql'da ist kein debug-log!
https://forum.iobroker.net/topic/51555/hinweise-für-gute-forenbeiträge/1
LESEN!
-
@homoran sagte in Backup wiederherstellen:
connection to server at "192.168.100.104", port 5432 failed: Connection refused
was ist das für eine IP?
-
@andré-koschnik sagte in Backup wiederherstellen:
EPERM: operation not permitted
Dem user 'iobroker' fehlen die Mittel / die Rechte dazu.
Mit
sudo psqlbulldoozerst du da mit root durch die Gegend. -
@homoran
das ist der localhost.hab auch mal mit der ip versucht. weil sol komme ich auch von extern
-
@andré-koschnik sagte in Backup wiederherstellen:
das ist der localhost.
localhost ist 127.0.0.1
also: wo kommt diese IP her?
-
im pg admin habe ich den user zum db owner gemacht.
was brauch er noch -
backitup.0 2023-11-09 14:05:26.207 debug [pgsql] postgresql Restore completed successfully backitup.0 2023-11-09 14:05:26.197 error [pgsql] Is the server running on that host and accepting TCP/IP connections? backitup.0 2023-11-09 14:05:26.195 error [pgsql] pg_dump: error: connection to database "anko_iobroker_v1" failed: connection to server at "192.168.100.104", port 5432 failed: Connection refused backitup.0 2023-11-09 14:05:21.988 debug [pgsql] Start postgresql Restore ... backitup.0 2023-11-09 14:05:12.557 error Error: Command failed: sudo mount -t cifs -o username=iobroker,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777 //192.168.100.2/share/ioBrokerbackupDir /opt/iobroker/backupsmount error(16): Device or resource busyRefer to the mount.cifs(8) manual page (e.g. man mount.cifs) and kernel log messages (dmesg) backitup.0 2023-11-09 14:05:12.498 debug cifs-mount command: "sudo mount -t cifs -o username=iobroker,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777 //192.168.100.2share/ioBrokerbackupDir /opt/iobroker/backups" backitup.0 2023-11-09 14:05:12.498 debug first mount attempt with smb option failed. try next mount attempt without smb option ... backitup.0 2023-11-09 14:05:12.464 debug Backup list be read ... backitup.0 2023-11-09 14:05:12.451 debug cifs-mount command: "sudo mount -t cifs -o username=iobroker,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=1.0 //192.168.100.2share/ioBrokerbackupDir /opt/iobroker/backups" backitup.0 2023-11-09 14:05:12.450 debug noserverino option: false backitup.0 2023-11-09 14:05:02.502 error [pgsql] postgresql Restore not completed backitup.0 2023-11-09 14:05:02.499 error [pgsql] Error: EPERM: operation not permitted, utime '/opt/iobroker/backups/pgsql_restore_backupiobroker.sql' backitup.0 2023-11-09 14:04:58.928 debug [pgsql] Start postgresql Restore ... backitup.0 2023-11-09 14:04:48.623 debug mount successfully completed backitup.0 2023-11-09 14:04:48.096 debug Backup list be read ... backitup.0 2023-11-09 14:04:48.085 debug cifs-mount command: "sudo mount -t cifs -o username=iobroker,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=1.0 //192.168.100.2share/ioBrokerbackupDir /opt/iobroker/backups" backitup.0 2023-11-09 14:04:48.084 debug noserverino option: false backitup.0 2023-11-09 14:04:44.139 debug The local storage check was completed successfully. On the host "iobroker" are currently 231995 MB free space available! backitup.0 2023-11-09 14:04:25.778 debug detect last backup file: iobroker_2023_10_30-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.777 debug detect backup file 29 from NAS: iobroker_2023_10_30-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.777 debug detect backup file 28 from NAS: iobroker_2023_10_23-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.776 debug detect backup file 27 from NAS: iobroker_2023_10_16-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.776 debug detect backup file 26 from NAS: iobroker_2023_10_09-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.775 debug detect backup file 25 from NAS: iobroker_2023_10_02-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.775 debug detect backup file 24 from NAS: iobroker_2023_09_25-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.775 debug detect backup file 23 from NAS: iobroker_2023_09_18-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.775 debug detect backup file 22 from NAS: iobroker_2023_09_11-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.774 debug detect backup file 21 from NAS: iobroker_2023_09_04-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.774 debug detect backup file 20 from NAS: iobroker_2023_08_28-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.774 debug detect backup file 19 from NAS: iobroker_2023_08_21-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.774 debug detect backup file 18 from NAS: iobroker_2023_08_14-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.773 debug detect backup file 17 from NAS: iobroker_2023_08_07-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.773 debug detect backup file 16 from NAS: iobroker_2023_07_31-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.773 debug detect backup file 15 from NAS: iobroker_2023_07_24-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.773 debug detect backup file 14 from NAS: iobroker_2023_07_17-06_17_58_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.772 debug detect backup file 13 from NAS: iobroker_2023_07_10-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.772 debug detect backup file 12 from NAS: iobroker_2023_07_03-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.772 debug detect backup file 11 from NAS: iobroker_2023_06_26-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.771 debug detect backup file 10 from NAS: iobroker_2023_06_19-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.770 debug detect backup file 9 from NAS: iobroker_2023_06_12-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.770 debug detect backup file 8 from NAS: iobroker_2023_06_05-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.770 debug detect backup file 7 from NAS: iobroker_2023_05_29-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.770 debug detect backup file 6 from NAS: iobroker_2023_05_26-13_56_02_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.769 debug detect backup file 5 from NAS: iobroker_2023_05_22-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.769 debug detect backup file 4 from NAS: iobroker_2023_05_15-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.768 debug detect backup file 3 from NAS: iobroker_2023_05_08-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.767 debug detect backup file 2 from NAS: iobroker_2023_05_01-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:25.766 debug detect backup file 1 from NAS: iobroker_2023_04_24-17_29_54_backupiobroker.tar.gz backitup.0 2023-11-09 14:04:23.736 debug mount successfully completed backitup.0 2023-11-09 14:04:23.037 debug cifs-mount command: "sudo mount -t cifs -o username=iobroker,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=1.0 //192.168.100.2share/ioBrokerbackupDir /opt/iobroker/backups" backitup.0 2023-11-09 14:04:23.036 debug noserverino option: false backitup.0 2023-11-09 14:04:22.937 info [iobroker] backup will be activated at 02:40 every 1 day(s) backitup.0 2023-11-09 14:04:22.909 debug Backitup has recognized a linux system backitup.0 2023-11-09 14:04:22.849 info starting. Version 2.8.7 in /opt/iobroker/node_modules/iobroker.backitup, node: v18.18.2, js-controller: 5.0.12 backitup.0 2023-11-09 14:04:22.314 debug Plugin sentry Initialize Plugin (enabled=true) backitup.0 2023-11-09 14:04:22.161 debug States connected to redis: 127.0.0.1:9000 backitup.0 2023-11-09 14:04:22.075 debug States create User PubSub Client backitup.0 2023-11-09 14:04:22.073 debug States create System PubSub Client backitup.0 2023-11-09 14:04:22.047 debug Redis States: Use Redis connection: 127.0.0.1:9000 backitup.0 2023-11-09 14:04:21.651 debug Objects connected to redis: 127.0.0.1:9001 backitup.0 2023-11-09 14:04:21.448 debug Objects client initialize lua scripts backitup.0 2023-11-09 14:04:21.318 debug Objects create User PubSub Client backitup.0 2023-11-09 14:04:21.316 debug Objects create System PubSub Client backitup.0 2023-11-09 14:04:21.261 debug Objects client ready ... initialize now backitup.0 2023-11-09 14:04:21.189 debug Redis Objects: Use Redis connection: 127.0.0.1:9001 backitup.0 2023-11-09 14:04:17.000 info terminating backitup.0 2023-11-09 14:04:16.497 info Terminated (ADAPTER_REQUESTED_TERMINATION): Without reason backitup.0 2023-11-09 14:04:16.494 info terminating backitup.0 2023-11-09 14:04:16.490 info cleaned everything up... backitup.0 2023-11-09 14:04:16.486 info Got terminate signal TERMINATE_YOURSELFMOD-EDIT: Code-tags korrigiert!
-
@andré-koschnik sagte in Backup wiederherstellen:
and: "sudo mount -t cifs -o username=iobroker,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=1.0 //192.168.100.2share/ioBrokerbackupDir /opt/iobroker/backups"
was ist denn das für eine Konfiguration?
-
so besser
backitup.0 2023-11-09 14:21:43.083 debug umount successfully completed backitup.0 2023-11-09 14:21:42.042 debug [pgsql] postgresql Restore completed successfully backitup.0 2023-11-09 14:21:42.005 error [pgsql] Is the server running on that host and accepting TCP/IP connections? backitup.0 2023-11-09 14:21:42.004 error [pgsql] pg_dump: error: connection to database "anko_iobroker_v1" failed: connection to server at "192.168.100.104", port 5432 failed: Connection refused backitup.0 2023-11-09 14:21:41.033 debug mount activ... umount in 2 Seconds!! backitup.0 2023-11-09 14:21:38.406 debug [pgsql] Start postgresql Restore ... backitup.0 2023-11-09 14:21:33.875 debug detect last backup file: iobroker_2023_10_30-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.872 debug detect backup file 29 from NAS: iobroker_2023_10_30-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.871 debug detect backup file 28 from NAS: iobroker_2023_10_23-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.870 debug detect backup file 27 from NAS: iobroker_2023_10_16-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.870 debug detect backup file 26 from NAS: iobroker_2023_10_09-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.869 debug detect backup file 25 from NAS: iobroker_2023_10_02-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.868 debug detect backup file 24 from NAS: iobroker_2023_09_25-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.868 debug detect backup file 23 from NAS: iobroker_2023_09_18-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.867 debug detect backup file 22 from NAS: iobroker_2023_09_11-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.866 debug detect backup file 21 from NAS: iobroker_2023_09_04-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.864 debug detect backup file 20 from NAS: iobroker_2023_08_28-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.864 debug detect backup file 19 from NAS: iobroker_2023_08_21-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.863 debug detect backup file 18 from NAS: iobroker_2023_08_14-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.862 debug detect backup file 17 from NAS: iobroker_2023_08_07-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.861 debug detect backup file 16 from NAS: iobroker_2023_07_31-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.861 debug detect backup file 15 from NAS: iobroker_2023_07_24-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.860 debug detect backup file 14 from NAS: iobroker_2023_07_17-06_17_58_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.859 debug detect backup file 13 from NAS: iobroker_2023_07_10-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.858 debug detect backup file 12 from NAS: iobroker_2023_07_03-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.857 debug detect backup file 11 from NAS: iobroker_2023_06_26-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.855 debug detect backup file 10 from NAS: iobroker_2023_06_19-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.854 debug detect backup file 9 from NAS: iobroker_2023_06_12-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.854 debug detect backup file 8 from NAS: iobroker_2023_06_05-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.853 debug detect backup file 7 from NAS: iobroker_2023_05_29-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.852 debug detect backup file 6 from NAS: iobroker_2023_05_26-13_56_02_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.851 debug detect backup file 5 from NAS: iobroker_2023_05_22-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.850 debug detect backup file 4 from NAS: iobroker_2023_05_15-02_40_21_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.850 debug detect backup file 3 from NAS: iobroker_2023_05_08-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.849 debug detect backup file 2 from NAS: iobroker_2023_05_01-02_40_20_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:33.847 debug detect backup file 1 from NAS: iobroker_2023_04_24-17_29_54_backupiobroker.tar.gz backitup.0 2023-11-09 14:21:32.169 debug mount successfully completed backitup.0 2023-11-09 14:21:31.852 debug cifs-mount command: "sudo mount -t cifs -o username=gb,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777 //192.168.100.2/share/ioBrokerbackupDir/ /opt/iobroker/backups" backitup.0 2023-11-09 14:21:31.851 debug first mount attempt with smb option failed. try next mount attempt without smb option ... backitup.0 2023-11-09 14:21:31.813 debug mount successfully completed backitup.0 2023-11-09 14:21:31.812 debug Backup list be read ... backitup.0 2023-11-09 14:21:31.797 debug cifs-mount command: "sudo mount -t cifs -o username=gb,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=1.0 //192.168.100.2/share/ioBrokerbackupDir/ /opt/iobroker/backups" backitup.0 2023-11-09 14:21:31.796 debug noserverino option: false backitup.0 2023-11-09 14:21:31.107 debug cifs-mount command: "sudo mount -t cifs -o username=gb,password=****,domain=leevan.de,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=1.0 //192.168.100.2/share/ioBrokerbackupDir/ /opt/iobroker/backups" backitup.0 2023-11-09 14:21:31.107 debug noserverino option: false backitup.0 2023-11-09 14:21:31.019 info [iobroker] backup will be activated at 02:40 every 1 day(s) backitup.0 2023-11-09 14:21:30.992 debug Backitup has recognized a linux system backitup.0 2023-11-09 14:21:30.926 info starting. Version 2.8.7 in /opt/iobroker/node_modules/iobroker.backitup, node: v18.18.2, js-controller: 5.0.12 backitup.0 2023-11-09 14:21:30.420 debug Plugin sentry Initialize Plugin (enabled=true) backitup.0 2023-11-09 14:21:30.265 debug States connected to redis: 127.0.0.1:9000 backitup.0 2023-11-09 14:21:30.171 debug States create User PubSub Client backitup.0 2023-11-09 14:21:30.170 debug States create System PubSub Client backitup.0 2023-11-09 14:21:30.142 debug Redis States: Use Redis connection: 127.0.0.1:9000 backitup.0 2023-11-09 14:21:30.075 debug Objects connected to redis: 127.0.0.1:9001 backitup.0 2023-11-09 14:21:30.066 debug Objects client initialize lua scripts -
@andré-koschnik kaum macht man es richtig schon klappt es.
aber vorher auf alles andere schimpfen :rage; statt die notwendigen Infos zu Beginn beizubringen!
Lesen
https://forum.iobroker.net/topic/51555/hinweise-für-gute-forenbeiträge/1beim nächsten mal auswendig lernen!
-
sorry das backup wieder einpielen hat nicht funktioniert.
2023-11-09 14:21:42.004 error [pgsql] pg_dump: error: connection to database "anko_iobroker_v1" failed: connection to server at "192.168.100.104", port 5432 failed: Connection refusedUnd ich wollte auf keinen fall rumpöbeln. Wenn das der fall war enschuldige ich mich.
https://forum.iobroker.net/topic/51555/hinweise-für-gute-forenbeiträge/1
beim nächsten mal auswendig lernen!
