Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres port 5434 not being allowed when remote server isaccessing - Mailing list pgsql-admin

From Fabio Pardi
Subject Re: postgres port 5434 not being allowed when remote server isaccessing
Date
Msg-id 31e1a278-3aa8-5576-c8bf-b38e1f4a16ba@portavita.eu
Whole thread Raw
In response to postgres port 5434 not being allowed when remote server is accessing  (Mark Steben <mark.steben@drivedominion.com>)
List pgsql-admin
Tree view

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 | Autobase 
  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
www.twitter.com/DominionDealer
 www.drivedominion.com







pgsql-admin by date:

Previous
From: babak houman
Date:
Subject: Optimal SSD based RAID 0 config
Next
From: "For@ll"
Date:
Subject: PostgreSQL 9.3 - reindex problem