[Guide] Database backup in Truenas #8809
aviv926
started this conversation in
Community Guides
Replies: 2 comments 1 reply
-
I love immich but all the breaking changes on major released stopped me from using it. I was waiting for exactly the same. How to restore from truenas apps instead of container. Thank you for the info. Ill try |
Beta Was this translation helpful? Give feedback.
1 reply
-
Same happened to me . Yes you can I tested and it works. The instructions are a little confusing You have to select save as sql . Click on the ? Mark to see the details in pgadmin. This is a game changer at least for me. Now I can backup the db in truenas scale. I was able to backup and restore from scratch
Thank you,
Diego
…________________________________
From: Wayne Scott ***@***.***>
Sent: Monday, May 6, 2024 9:08:05 PM
To: immich-app/immich ***@***.***>
Cc: Dievale ***@***.***>; Comment ***@***.***>
Subject: Re: [immich-app/immich] [Guide] Database backup in Truenas (Discussion #8809)
This does allow me to connect to the database with pgadmin, but it doesn't seem to work to restore the pgbackup files that are automatically saved by the current immich image. Those are .SQL files that want to be restored with psql.
—
Reply to this email directly, view it on GitHub<#8809 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AI4F45AQO2CE5WE7COLILJTZBASPLAVCNFSM6AAAAABGHK6IW6VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TGMZVGUZTS>.
You are receiving this because you commented.Message ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I recently started using Truenas to deploy Immich, I ran into a lot of missing information about how it's deployed.
As part of this their layout includes a different name for the database (immich&immich) rather than immich and postgres which has led to a lot of confusion.
In addition the database password is generated randomly without the user knowing what it is (It does not appear in the Truenas documentation).
How is it tested?
The backup was created on Immich with an environment of 260 images (including machine learning running)
and successful restoration of the backup.
Problems:
During the restoration process I encountered a problem that the names of the places were not restored at all, this is a known problem #7004.
Guide
Backup
Note
By default when using the Immich distribution of TrueNAS the database password is randomly generated, to back up Immich the database password is needed.
sudo heavyscript dns immich
Copy the entry of immich-postgres It should look something like this:
immich-postgres.ix-immich.svc.cluster.local
heavyscript pod -s immich
env
and copy the POSTGRES_PASSWORD value.Now go to pgAdmin
Connect to the browser interface.
Select Add New Server.
Enter the following values:
The value from section 2
5432
immich
immich
The value from section 6
Under Databases select Immich -> right click -> backup.
Select the backup location and click Backup.
You have successfully backed up your database!
Recovery
If you have suggestions or other ways in which you take a backup, you are welcome to write to me, I will edit accordingly.
Beta Was this translation helpful? Give feedback.
All reactions