Hey there,
I have had a nosey at the selfhost docs but I can't find any instructions on how to restored a database from a forem PostGres backup.
Can anyone point me in the right direction?
ta!
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (10)
Which hosting service are you using, because that may also be a factor?
For example, Digital Ocean has docs here and I think you have at least one Heroku instance
Would you mind asking if I need the full PostGres URI if I am connecting to a restored AWS RDS database?
I am attempting configure ansible for AWS RDS rather than localhost, then boot a self host forem and then restore the DB from an existing forem DB.
Also from my reliable source @andygeorge :
Ooooh, does @andrewbrown's post help with some of this?
Ah yes it does, it validates that Selfhost can run with the db on RDS, I can see the @jdoss has commented that you can just specify the following values before launching the ansible build, I just want to check the format should be:
postgres_user: postgres
postgres_password: "xxxxxxxxxxx"
postgres_host: xxxx.xxxx.eu-west-2.rds.amazonaws.com
@jdoss said that should work, so looking forward to hearing more from you about how you get on with it!
It doesn't :( everything is in place, there are no errors from the build, jsut no database is commissioned so the app isn't available. Have reverted back to local but it would be good to be able to abstract the DB in RDS and take advantage of all the cool backup and scalability features 😎
Another question (sorry, I know you're here for answers 😉): are you attempting this with a life-and-in-person Forem?
If I understand @jdoss correctly, you either need to
Alternatively,
If not, this is curiouser and curiouser (and I'll be happy to continue relaying questions to our team for ideas on why it's not working).
Hey @ellativity 🤩 I am using AWS (I am also assuming here that selfhost deploys PostGres)
I asked around, and had a reliable source inform me:
This should work on all selfhost Forems 🤞
Perfect, as usual, exactly what I needed 🤩