How to (manually) backup (and potentially restore) a map for an Ecovacs Deebot in Android?

How to (manually) backup (and potentially restore) a map for an Ecovacs Deebot in Android ?

The app is "buggy", as of March 2021.

Restore from local disk vs SAN on physical machine (SQL Server Linux)

So I am new to Linux and our client decided to use SQL Server on Linux. As soon as we started testing, we ran into performance issues.

The server in question is a physical machine configured with a SSD local disk and a “natively” attached Storage. I don’t know what a quoted “natively” actually mean here. Linux guy’s exact words below

the storage is “natively” attached to the server

The storage area network is also built on top of SSD and I copied a 4.7 GB backup file from there over to local SSD within a second.

cp gsfssqlbackupstestdb01.bak tmpbackupstestdb01.bak

But when I try to restore from

  1. SAN

RESTORE DATABASE successfully processed 612466 pages in 369.425 seconds (12.952 MB/sec).

  1. Local Disk

RESTORE DATABASE successfully processed 612466 pages in 26.248 seconds (182.295 MB/sec).

The database files are also stored on the SAN and while SAN to physical machine has not connectivity issues, I am certain, the way MS SQL reads the files on SAN has something to do with the slowness.

The database size is not big enough and the database is usually idle based on wait statistics

enter image description here

wait_type   wait_time_s signal_wait_time_s  resource_wait_time_s    pct
SOS_WORK_DISPATCHER 9643760.19  114.83  9643645.35  98.2
PWAIT_EXTENSIBILITY_CLEANUP_TASK    174660.62   174660.62   0   1.78
BACKUPTHREAD    676.2   0   676.19  0.01
BACKUPIO    627.86  0.37    627.49  0.01
PREEMPTIVE_OS_LOOKUPACCOUNTSID  342.43  0   342.43  0
PREEMPTIVE_OS_AUTHENTICATIONOPS 298.48  0   298.48  0
PAGEIOLATCH_SH  116.55  0.04    116.51  0
PREEMPTIVE_OS_QUERYREGISTRY 28.7    0   28.7    0
SERVER_IDLE_CHECK   22  0   22  0
PREEMPTIVE_OS_WRITEFILEGATHER   13.71   0   13.71   0
PARALLEL_REDO_WORKER_WAIT_WORK  9.78    0.01    9.78    0
STARTUP_DEPENDENCY_MANAGER  5.11    0   5.11    0
IO_COMPLETION   5.02    0   5.02    0
PWAIT_ALL_COMPONENTS_INITIALIZED    3.75    0   3.75    0
PREEMPTIVE_OS_FILEOPS   3.41    0   3.41    0

I want to understand why SQL Server is restoring from SAN slower than local file system. I would understand if the difference was little, but currently the different is dramatic. Since our data files and log files are also on SAN, we need to ensure disk is read/written on as fast as possible.

Most of settings are set as default
network packet size is 4096

recovery – Restore PFILE files copied directly off of a Bitlocker encrypted directory

I have PFILE files copied directly off of a Bitlocker encrypted directory along with a backup of the pfx recovery key. The original computer died. I understand this is not the way to make copies of Bitlocker encrypted files. Is there any way to recover these files?

I imagined one might create a new directory, copy the PFILES files into it, and use Bitlocker somehow with the pfx file.

Possible? Thanks in advance.

dnd 5e – Is Restore Balance a visible effect?

It’s up to the DM. I would rule it is imperceptible.

The Restore Balance feature does not have much helpful flavor text to tell us what the sorcerer is doing:

Your connection to the plane of absolute order allows you to equalize chaotic moments.

There’s nothing here or in the rest of the feature description that tells us the sorcerer is doing anything outside of their own mind when they use this feature. This is why I would rule it is imperceptible, but it is also why there is plenty of room for a DM to make a different ruling.

oracle – Restore non-cdb backup into pdb database

I haven’t found any information on is it possible to restore a Oracle non-cdb 19.8 backup into a container-database PDB (still 19c) , or not.
The method i have found is not suitable for my situation (convert non-cdb to pdb using DBMS_PDB.DESCRIBE – that seems to imply that the database type is converted + all data is copied during this operation, which is not the same as restoring from a backup).
*Export/import/Golden Gate are not viable options for me.

Has anyone had a similar challenge and what was the best way to get a non-cdb to get into pdb form.

Restore android google drive backup after factory reset

I have google drive backup. I am using android 10 on nokia mobile. I did factory reset / erase all data. during set up I skip restore backup.

I check on google drive. I have backup on 23 February. But How do I restore that backup.
I do not find restore backup option on device. I check in setting.

PostgreSQL: How to backup only One Schema from a database and restore it to other schema having same name of database?

I have a database named "A" which has three schemas "B","C" and "D". I want to take backup of schema "C" and restore the data to Schema "B"? not sure how to do this as I am new to Postgres. pls help with commands.

recovery – Restore partially broken PostgreSQL Database

I have managed to break my own server, and undo months of work.

The thing is, I hosted a nextcloud instance on the server, and had it configured to use WasabiS3 as primary storage, which means the data is still intact.

However, the files are stored in a urn:oid format, which means without the database, the data is pretty much useless.

I need to recover the database that contains the filetable, but I cannot connect to pgsql.

After restoring the corrupted folder to /var/lib/postgresql/12/main, I have successfully managed to start the postgresql server.

Trying to log in using the pgsql command, however, this error is encountered.

psql: error: FATAL:  "base/16408" is not a valid data directory
DETAIL:  File "base/16408/PG_VERSION" is missing.

And, the directory /var/lib/postgresql/12/main/base/16408 is indeed empty.

However, I would at least like to restore part of the database if that is possible.
Is this a possibility?

Thanks in advance.

bootcamp – Restore a NTFS volume back up by Disk Utility

I have a Windows installation which I created with Bootcamp. Then I need to expand the volume to add more Software. So I use Disk Utility to create a DMG image for the Bootcamp volume. But after I have deleted the old Bootcamp volume and create a new larger volume, I cannot restore it with Disk Utility:

enter image description here

Nor asr:

 asr restore --source /Users/phuongnd08/Downloads/BOOTCAMP.dmg  --target /dev/disk0s3 --erase --noverify
    Validating target...done
    Validating source...done
    Erase contents of /dev/disk0s3 ()? (ny): y
    Repartitioning target device...
Could not change the partition type for /dev/disk0s3 - Operation not permitted

I guess due to NTFS? But this sounds very illogical because: you can create image out of it, you should be able to restore it from an image? What should I do now to restore that image?

restore – pg_restore using PostGIS/PostgreSQL Dump Changes Data in Geography Column

Two PostGIS databases (PostGIS 3.0, PostgreSQL 13.1) were setup on two separate machines to be as close to each other as possible using Docker images.

A dump of the database was taken from the first machine using

pg_dump --host=db1.foo.com --dbname=foo --username=postgres -Fc --file=/tmp/foo.dump

and then restored on the database on the second machine using

pg_restore --clean --dbname=foo /tmp/foo.dump

When we view a query result using a GUI software TablePlus, we noticed that the column named coordinates of type Geography contains values that look very different after restoring.

Query Result on 1st Machine:

SELECT coordinates FROM locations LIMIT 5;

enter image description here

Query Result on 2nd Machine (after pg_restore):

SELECT coordinates FROM locations LIMIT 5;

enter image description here

However, our app that queries this database for coordinate data appears to be plotting the data correctly on a map.

Question: Why did the Geography data values in the column coordinates changed, and how can we restore from the dump while keeping the original data values?


Update: Tried using -b when performing pg_dump, but the problem persist.

pg_dump --host=db1.foo.com --dbname=foo --username=postgres -Fc -b --file=/tmp/foo.dump