I'm setting up my own postgres database to use with a heroku app (I don't wanna pay $200 a month just to have postgis, I don't need a huge database or anything, just postgis). I'm enabling remote access to my postgres database but it seems I have to do it on a per-ip basis with something like the following line in my pg_hba.conf file:
host all all 22.214.171.124/8 md5
Now that's all fine and good, except I have no idea from what ip heroku will be trying to access my database. I was considering just changing the line to:
host all all 0.0.0.0/0 md5
But that feels dangerous. So two part question:
Is this really as dangerous as I feel it is?
If it really is as dangerous as I feel it is, is there a different way to approach the problem?