Connect to multiple PostgreSQL hosts

[Gogoloogu]

Connect to multiple PostgreSQL hosts

[markphelps]

Hey @Gogoloogu thanks for the request!

I think we'll need to switch Postgres DB libraries from our current lib/pq to something like pgx in order to support this as it looks like lib/pq cannot handle multiple hosts and also looks like its in maintenance mode (so it might be time to switch anyways to another impl)

Looks like hashicorp/vault ran into the same thing and decided to switch to pgx

We'll have to do some investigation to see:

1. how difficult a lift this would be to switch (Im hoping not too difficult since we don't do anything crazy as far as queries)
2. how this will affect performance (hopefully it will be an improvement)

So this might take a little bit of time, but I think its doable and likely the right move to switch to a better maintained library like pgx anyways.

It looks like the dburl library that we use to parse db connection strings natively only supports lib/pq, however they do allow us to add our own schema to driver support, so that might be possible to get it to support pgx.

golang migrate which we use for migrations also seems to support pgx.. so we should be good there

But yeah I think this is doable, it just might take a bit of work/time but any help would be appreciated!!