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

Hello Mark,

Have you checked the hot_standby parameter? It must be ON so you can run
queries on a standby.

Regards,
Arlindo Neto.

Em qua, 1 de ago de 2018 às 13:22, Mark Steben <
mark(dot)steben(at)drivedominion(dot)com> escreveu:

> 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
> www.twitter.com/DominionDealer
> www.drivedominion.com <http://www.autorevenue.com/>
>
> <http://autobasedigital.net/marketing/DD12_sig.jpg>
>
>
>
>
> <https://www.drivedominion.com/transform-your-vision/>