Selfhost runs PostGres itself, and doesn't use AWS RDS... it runs PostGres locally on the selfhost VM instance (eg AWS EC2 instance). The forem-postgres.service service manages the PostGres process directly
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:
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 π
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).