Re: postgres port 5434 not being allowed when remote server is accessing

Hi,

From your description looks like a firewall or maybe routing issue.

Could you post the output of tcpdump on both machines while you attempt to open the connections?

Regards,

fabio pardi

On 01/08/18 18:22, Mark Steben wrote:
> Good morning,
>
> We run postgres 9.4.8 on our GNU linux standby server.  We run 3 instances receiving data there:
>    1. a slony instance - port 5432
>    2. standby instance 1 - port 5433
>    3.  standby instance 2 - port 5434
>
> We run connection strings in another GNU linux server to access the data on our standby server.
>
>   We can access  the postgres instances on port 5432 and port 5433 but not port 5434.
>
> All the instances are up and running on the standby server.  Any insights as to why 5434 does not work?
>
> Thank you
>
> --
> *Mark Steben*
>  Database Administrator
> @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/> 
>   CRM division of Dominion Dealer Solutions 
> 95D Ashley Ave.
> West Springfield, MA 01089
> t: 413.327-3045
> f: 413.383-9567
>
> www.fb.com/DominionDealerSolutions <http://www.fb.com/DominionDealerSolutions>
> www.twitter.com/DominionDealer <http://www.twitter.com/DominionDealer>
>  www.drivedominion.com <http://www.autorevenue.com/>
>
>
>
>
>
>
> <https://www.drivedominion.com/transform-your-vision/>