search

Heavybullets8 / heavy_script

Bash script for managing Truenas SCALE applications, automatically update applications, backup applications datasets, open a shell for containers.
GNU General Public License v3.0
386 stars 27 forks source link

backup Nextcloud database, possible? #91

Closed PackElend closed 1 year ago

PackElend commented 1 year ago

Hi, would like to continue the discussion happened in the comments of Truenas Scale - Truecharts Nextcloud - Install & Restore - YouTube in regard to the backup of the Nextcloud database.

TrueCharts is migrating to CloudNativePG - PostgreSQL Operator for Kubernetes and came across Datenbank in neue Nextcloud importieren ... (Import database into new Nextcloud install), which references to Migrating to a different server — Nextcloud latest Administration Manual latest documentation

So I'm wondering could using PostgreSQL native support for PostgreSQL: Documentation: 15: Chapter 26. Backup and Restore and PostgreSQL: Documentation: 15: Chapter 27. High Availability, Load Balancing, and Replication. The first is used in Backup — Nextcloud latest Administration Manual latest documentation

Heavybullets8 commented 1 year ago

Thank you for bringing this issue to my attention. I understand that TrueCharts is migrating to CloudNativePG - PostgreSQL Operator for Kubernetes, and you're looking for ways to backup and restore the Nextcloud database using PostgreSQL's native support.

TrueCharts provides a guide and script for exporting PostgreSQL databases, which can be found here: https://truecharts.org/manual/SCALE/guides/sql-export

Although it would be great to incorporate this feature into heavyscript in the future, I am currently focused on other aspects of the project. In the meantime, you can rely on the TrueCharts script for database export.

Regarding the restoration of an old database into a new one, I am not entirely certain about the process. I suggest reaching out to TrueCharts directly for assistance on this matter.

I hope this helps, and please let me know if you have any further questions or concerns.

PackElend commented 1 year ago

thanks for the detailed answer again. based on the comments to the video I understood that it seems not being easily feasible, so I not even checked any guide in detail. TrueCharts use the pg_dump command as mentioned in NC documentation, so all fine 😃

Maybe, once in not so far futur, their backup script becomes part of yours 🤞

all said, thx again, I close the ticket good luck with anything