Starting pact broker container with RDS postgresql

[satrifoso]

Hello all, I am trying to start pact broker docker container from my local machine to connect to an RDS postgresql instance that is public and I can connect to from psql. I set the environment variable as such: PACT_BROKER_DATABASE_URL='postgres://${USERNAME}:${PASSWORD}!@pactbroker-postgresdb-instance-*blahblahblah*.rds.amazonaws.com/postgres?sslmode=disable'

and try to start the container with docker run pactfoundation/pact-broker but am getting this error. It looks like it's still trying to use the local postgresql instance instead of the remote one I set up. Any ideas? Thank you in advance!

! Unable to load application: Sequel::DatabaseConnectionError: PG::ConnectionBad: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
bundler: failed to load command: puma (/pact_broker/vendor/bundle/ruby/2.7.0/bin/puma)
/pact_broker/vendor/bundle/ruby/2.7.0/gems/pg-1.4.6/lib/pg/connection.rb:756:in `connect_start': PG::ConnectionBad: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory (Sequel::DatabaseConnectionError)
	Is the server running locally and accepting connections on that socket?

[edouard-lopez]

It's close, but there is no solution :S