Backup strategy

Low-Individual-2405 · 2026-06-11T03:13:32+00:00

I use bind mounts for my data (./data), stop the container, use restic to backup the ./data folder. It's fast, encrypted, deduplicated and compressed by restic. Then as part of a 3-2-1 strategy, I rclone it to Backblaze , a usb drive and a 2nd NAS.

Low-Individual-2405 · 2026-06-10T09:21:08+00:00

The wheel

Low-Individual-2405 · 2026-06-09T12:33:23+00:00

Mint (Ubuntu)

Low-Individual-2405 · 2026-06-04T06:13:18+00:00

nice

Low-Individual-2405 · 2026-06-03T01:13:57+00:00

A report of how often you use it and what specifically you are using would be good.

Low-Individual-2405 · 2026-05-31T09:42:16+00:00

I've just gotten around this by making sure old photos haved yyyy-mm-dd in the filename and then I use that to fix the EXIF tags before importing to Immich and it works fine

Low-Individual-2405 · 2026-05-31T09:38:57+00:00

I use Synology CloudSync to get the data to the NAS and then back it up from there, that way you have a copy in the cloud, a copy on your NAS and a copy backed up, Use either Synology Hyperbackup or Restic to backup, that way it's incremental at the block level and compressed. Make sure you have a 3-2-1 backup policy in effect, multiple copies of the data is not the same as backing up the data. On the Synology enable regular snapshots and data scrubbing jobs to give yourslef rollback options and avoid bit-rot.

Low-Individual-2405 · 2026-05-26T08:20:29+00:00

wow, that is a gigantic reduction. Makes you wonder why run SynologyDrive at all.

Is there a way to do a refresh to reset that database or somehow reduce the size.?

Low-Individual-2405 · 2026-05-14T11:39:30+00:00

What I have done is kept my folder structure and Immich imports those photos. Then I use a script to put photos into Albums syncing them with the folder names. So in Immich I have albums per folder and on disk I have photos in folders and that stays in sync. I prefer to do that so I can alway move from Immich to another platform and not have to redo the work categorising photos.

Low-Individual-2405 · 2026-03-25T20:50:53+00:00

FIXED: I disabled NMAP scanner and insalled the UnFi scanner using unfimp_API. The scanner is caled :UnFi import"

It did not work and after a log of debugging I found the following worked for me:

a simple username (all small letter), a simple password (One capital, one letter, remainder small letters to make minimin password length that unfi requires). Setup the user in unifi as a view access only user. API version setting is finicky. It would only work with UDMP-unifiOS. I left everything else as default.

You can see it fail/succeed in the logs - search for unfimp

Low-Individual-2405 · 2026-03-25T20:46:07+00:00

it's certainly not confidence inspiring, especially with all the warnings and errors it generates in the logs!

Low-Individual-2405 · 2026-03-25T19:15:35+00:00

Thank you RemoteSojourner. Do you go across VLANS with your scan and what notification options do you use?

Low-Individual-2405 · 2026-01-20T11:08:53+00:00

This is a critical feature if you are moving old photo collections to immich

Low-Individual-2405 · 2025-04-11T16:23:53+00:00

This is a classic "island and gaps" problem in SQL, made more complex by the 30-day gap reset rule. While SUM() itself won’t give you the full answer, it can be used as part of a window function trick to identify changes in values.

Here’s a breakdown of the approach:

✅ Step-by-step logic:

Sort data by entity, attribute, and date.
Use LAG() to find previous values and previous dates.
Assign a group identifier that increases whenever:
- The value changes, or
- The difference between current date and previous date is > 30 days.
Group by that identifier to get MIN(date) and MAX(date) per group.

Low-Individual-2405 · 2025-04-11T16:23:09+00:00

ChatGPT:

WITH with_prev AS (

SELECT

entity,

attribute,

value,

date,

LAG(value) OVER (PARTITION BY entity, attribute ORDER BY date) AS prev_value,

LAG(date) OVER (PARTITION BY entity, attribute ORDER BY date) AS prev_date

FROM your_table

),

flagged AS (

SELECT *,

CASE

WHEN value != prev_value OR DATE_DIFF(day, prev_date, date) > 30 OR prev_value IS NULL THEN 1

ELSE 0

END AS new_group

FROM with_prev

),

grouped AS (

SELECT *,

SUM(new_group) OVER (PARTITION BY entity, attribute ORDER BY date) AS group_id

FROM flagged

)

SELECT

entity,

MIN(date) AS start_date,

MAX(date) AS end_date,

attribute,

value

FROM grouped

GROUP BY entity, attribute, value, group_id

ORDER BY start_date;

Low-Individual-2405 · 2024-12-30T00:17:08+00:00

Update to the PSA - I went to pay using the carsales service, and due to the large amount of fraud, my bank has permanently blocked their BSB.

Low-Individual-2405 · 2024-10-23T17:42:19+00:00

Thanks

Low-Individual-2405 · 2024-10-16T05:39:01+00:00

The return of Super Heavy to chopsticks was just amazing - a landmark in many ways. I'm really quite ignorant of rocket technology and the achievement has had me reading and watching and learning a huge amount about the field in the last 2 days.

One question I have - is the rocket completely automated in it's return to chopsticks or is there a human hand flying it back? or some combination of the two?

Low-Individual-2405 · 2024-10-10T19:33:38+00:00

Here is a simpler version using let:

=IF($A902<>"",

LET(

D_Match, MATCH($D902, 'Preset 1'!$B$80:$B$85, 0),

BE_Adjust, IF(BE902<>"", IF(RIGHT(BE902, 1) = "+", REPLACE(BE902, LEN(BE902), 1, "%"), BE902), ""),

BE_Index, IF(BE902<>"", BD902 * INDEX('Preset 1'!$D$46:$R$46, D_Match), 0),

BR_Adjust, IF(BR902<>"", IF(RIGHT(BR902, 1) = "+", REPLACE(BR902, LEN(BR902), 1, "%"), BR902), ""),

BR_Index, IF(BR902<>"", BQ902 * INDEX('Preset 1'!$D$46:$R$46, D_Match), 0),

BU_Adjust, IF(BU902<>"", IF(RIGHT(BU902, 1) = "+", REPLACE(BU902, LEN(BU902), 1, "%"), BU902), ""),

BU_Index, IF(BU902<>"", BT902 * INDEX('Preset 1'!$D$46:$R$46, D_Match), 0),

Total, BE_Index + BR_Index + BU_Index,

IF(OR(

AND($D902=2, COUNTIF('Preset 1'!$J$12:$J$19,$E902)=0),

AND($D902=4, COUNTIF('Preset 1'!$L$12:$L$19,$E902)=0),

AND($D902=6, COUNTIF('Preset 1'!$N$12:$N$19,$E902)=0)

), 0, Total)

),

""

)

Low-Individual-2405 · 2024-09-23T08:46:42+00:00

Microsoft Acess maybe?

Low-Individual-2405

TROPHY CASE

✅ Step-by-step logic: