Backup: interface to export database backup including auto-recreate cache files

[kaligrafy]

trafficstars

create a zip with sql dump and cache data (at least auto run create cache after import)

[kaligrafy]

pg_dump --file "FILEPATH.sql" --host "HOST" --port "PORT" --username "USERNAME" --no-password --verbose --format=p --data-only --exclude-table="knex_migrations" --exclude-table="knex_migrations_lock" --exclude-table="sessions" --schema "SCHEMA" "DATABASE"

[kaligrafy]

We should be able to use the pg package to do the dump and restore

[greenscientist]

@kaligrafy isn't this more like a infra issue ? People should know how to backup their database I think. Maybe we could add something in the documentation ?

[kaligrafy]

It is mostly for developers and people installing it locally. I tend to always forget the correct settings when exporting (like the ownership and schemas correct config)

[kaligrafy]

The goal is to be able to do a full backup of a Transition instance with users and prefs, and then re-import it on another instance, which make sure everything is identical on the new machin/instance

[greenscientist]

ok, so this confirm that simply adding this to the documentation would be enough. (we cannot know how is each person database setup, so we can only gives guidelines)

[kaligrafy]

yes, it could be different then a simple dump/load so we can make sure it is always working on any system