redash server high availability

[anujthedevopsguy]

I have setup a Redash EC2 instance and set auto-scaling to 1. Currently, Redash has user accounts, a dashboard, queries, and other data. Let's say that if this instance goes down, all this data will be lost. A new redash instance will be created due to auto-scaling, though. How to avoid losing data.

[justinclift]

You need to backup your PostgreSQL database, and the environment file (env) that's in the /opt/redash directory.

With those, you're able to recreate your Redash instance if you need to for some reason. 😄

[anujthedevopsguy]

Are you referring the DB which we use as data source to produce dashboard? Or db instance running into redash EC2 instance? I am new to redash. questions could be vague :). where is created users info, dashboard , queries data saved ?

…

On Mon, 12 Feb 2024 at 8:56 PM, Justin Clift ***@***.***> wrote: You need to backup your PostgreSQL database, and the environment file (env) that's in the /opt/redash directory. With those, you're able to recreate your Redash instance if you need to for some reason. 😄 — Reply to this email directly, view it on GitHub <#6766 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APRCWEESHCOYMR5QCRCUULLYTIYD5AVCNFSM6AAAAABDEW5ULSVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4DINBTGEYDQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[justinclift]

Sorry, I wasn't as clear as I should have been.

Redash internally uses a PostgreSQL database that it stores all of the info (data sources, user info, queries, etc) in.

That's what you need to back up, and also make a copy of the matching environment file for.

I'm pretty sure we have instructions written somewhere for how to do the backup, but I'm not finding them in some quick searching. Hopefully one of our other Community members will be able to provide the link... 😄