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

Hi Arlindo - yes hot_standby is turned on for that server. Thanks for
quick response.

On Wed, Aug 1, 2018 at 12:26 PM, Arlindo Neto <neto(dot)acs(at)gmail(dot)com> wrote:

> 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.
>> <https://maps.google.com/?q=95D+Ashley+Ave.+West+Springfield,+MA+01089&entry=gmail&source=g>
>> West Springfield, MA 01089
>> <https://maps.google.com/?q=95D+Ashley+Ave.+West+Springfield,+MA+01089&entry=gmail&source=g>
>> 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/>
>
>

--
*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/>