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

No error - the connection attempt just spins until the attempt times out.
I now suspect a firewall issue and have reached out to our IT team to
investigate.

Thank you,

On Wed, Aug 1, 2018 at 1:10 PM, Mariel Cherkassky <
mariel(dot)cherkassky(at)gmail(dot)com> wrote:

> Hi, what error do you get?
>
>
> On Wed, Aug 1, 2018, 8:05 PM Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
> wrote:
>
>> 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.
>> <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/>