Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. ioBroker Allgemein
    4. Backup wiederherstellen

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Backup wiederherstellen

    This topic has been deleted. Only users with topic management privileges can see it.
    • André Koschnik
      André Koschnik @Thomas Braun last edited by André Koschnik

      @thomas-braun said in Backup wiederherstellen:

      Dann mountest du das von Hand?

      nein

      aber der backup adapter, ist beim backup wiederherstellen ein paar abgebrochen. Evlt. deshalb die mehrfachen mounts.
      die sind aber nach einem neustart wieder weg oder?

      Homoran Thomas Braun 2 Replies Last reply Reply Quote 0
      • Homoran
        Homoran Global Moderator Administrators @André Koschnik last edited by Homoran

        @andré-koschnik sagte in Backup wiederherstellen:

        Evlt. deshalb die mehrfachen mounts.

        nein!
        wenn da bereits ein mount existiert gibt's ne Fehlermeldung und nichts passiert.
        Auf keinen Fall wird "drübergemountet"

        wieso gibt es keinen port der auf 5432 hört?
        ich komme mit dem PG admin von anderen rechner an die db

        was ist das denn jetzt wieder?

        André Koschnik 1 Reply Last reply Reply Quote 0
        • Thomas Braun
          Thomas Braun Most Active @André Koschnik last edited by

          @andré-koschnik sagte in Backup wiederherstellen:

          die sind aber nach einem neustart wieder weg oder?

          Sollte...
          Oder

          sudo umount /opt/iobroker/backups
          
          1 Reply Last reply Reply Quote 0
          • André Koschnik
            André Koschnik @Homoran last edited by

            @homoran

            OK muss ich das beheben?wenn ja wie?

            und

            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.

            danke schon mal für eure unterstützung

            Homoran 1 Reply Last reply Reply Quote 0
            • Homoran
              Homoran Global Moderator Administrators @André Koschnik last edited by

              @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...
              Oder

              sudo 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?

              André Koschnik 1 Reply Last reply Reply Quote 0
              • André Koschnik
                André Koschnik @Homoran last edited by

                nein sorry,

                dachte nur weil die backup node für die postges DB nicht funktioniert

                Homoran 1 Reply Last reply Reply Quote 0
                • Homoran
                  Homoran Global Moderator Administrators @André Koschnik last edited by

                  @andré-koschnik sagte in Backup wiederherstellen:

                  weil die backup node für die postges DB nicht funktioniert

                  ???

                  was hat das mit Backitup zu tun?

                  André Koschnik 1 Reply Last reply Reply Quote 0
                  • André Koschnik
                    André Koschnik @Homoran last edited by

                    @homoran

                    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=# \q
                    

                    wieso mach es backitup nicht

                    André Koschnik Homoran 2 Replies Last reply Reply Quote 0
                    • André Koschnik
                      André Koschnik @André Koschnik last edited by

                      @andré-koschnik

                      egal ihr hab mir schon weitergeholfen.
                      vielen dank dafür.

                      1 Reply Last reply Reply Quote 0
                      • Homoran
                        Homoran Global Moderator Administrators @André Koschnik last edited by

                        @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?

                        André Koschnik 1 Reply Last reply Reply Quote 0
                        • André Koschnik
                          André Koschnik @Homoran last edited by André Koschnik

                          @homoran

                          wie gesagt... bin ein mausschubser.
                          hätte gedacht wenn ich das per ssh kann sollte der adapter das auch können

                          a0d90d0e-e91a-4f6b-a53f-58cd0ac46203-grafik.png

                          Homoran 1 Reply Last reply Reply Quote 0
                          • Homoran
                            Homoran Global Moderator Administrators @André Koschnik last edited by Homoran

                            @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

                            André Koschnik 1 Reply Last reply Reply Quote 0
                            • André Koschnik
                              André Koschnik @Homoran last edited by

                              @homoran

                              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'
                              
                              Homoran Thomas Braun 2 Replies Last reply Reply Quote 0
                              • Homoran
                                Homoran Global Moderator Administrators @André Koschnik last edited by

                                @andré-koschnik sagte in Backup wiederherstellen:

                                @homoran

                                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 André Koschnik 2 Replies Last reply Reply Quote 0
                                • Homoran
                                  Homoran Global Moderator Administrators @Homoran last edited by Homoran

                                  @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 1 Reply Last reply Reply Quote 0
                                  • Thomas Braun
                                    Thomas Braun Most Active @André Koschnik last edited by

                                    @andré-koschnik sagte in Backup wiederherstellen:

                                    EPERM: operation not permitted

                                    Dem user 'iobroker' fehlen die Mittel / die Rechte dazu.

                                    Mit sudo psql bulldoozerst du da mit root durch die Gegend.

                                    André Koschnik 1 Reply Last reply Reply Quote 0
                                    • André Koschnik
                                      André Koschnik @Homoran last edited by

                                      @homoran
                                      das ist der localhost.

                                      hab auch mal mit der ip versucht. weil sol komme ich auch von extern

                                      Homoran 1 Reply Last reply Reply Quote 0
                                      • Homoran
                                        Homoran Global Moderator Administrators @André Koschnik last edited by Homoran

                                        @andré-koschnik sagte in Backup wiederherstellen:

                                        das ist der localhost.

                                        localhost ist 127.0.0.1

                                        also: wo kommt diese IP her?

                                        1 Reply Last reply Reply Quote 0
                                        • André Koschnik
                                          André Koschnik @Thomas Braun last edited by

                                          @thomas-braun

                                          im pg admin habe ich den user zum db owner gemacht.
                                          was brauch er noch

                                          Thomas Braun 1 Reply Last reply Reply Quote 0
                                          • André Koschnik
                                            André Koschnik @Homoran last edited by Homoran

                                            @homoran

                                            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_YOURSELF
                                            

                                            MOD-EDIT: Code-tags korrigiert!

                                            Homoran 1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate
                                            FAQ Cloud / IOT
                                            HowTo: Node.js-Update
                                            HowTo: Backup/Restore
                                            Downloads
                                            BLOG

                                            903
                                            Online

                                            31.7k
                                            Users

                                            79.9k
                                            Topics

                                            1.3m
                                            Posts

                                            9
                                            95
                                            6915
                                            Loading More Posts
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            Community
                                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                            The ioBroker Community 2014-2023
                                            logo