When using the Postgres Writer to connect and write data to a different Postgres port the DB Connection String Port= is being over written by the default value of 5432, and therefore I was seeing 'Connection refused' messages.
e.g. User ID=postgres;Password=*****;Host=mypostgresbox;Port=5434;Database=logshark;Pooling=true;
I found a workaround to select a different port looking at the code of this bit, where it extracts the port from the db hostname.
|
var r = Regex.Match(host, @"(?<host>.*?)(:?(?<port>\d+))?$"); |
I modified my connection string as follows:
e.g. User ID=postgres;Password=*****;Host=mypostgresbox:5434;Port=5434;Database=logshark;Pooling=true;
After this the Postgres Writer was able to write data to my postgres instance listening on a different port.