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

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
Cc: Arlindo Neto <neto(dot)acs(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres port 5434 not being allowed when remote server is accessing
Date: 2018-08-01 17:10:27
Message-ID: CA+t6e1kPzqorF=84TWjdvcg90wvSn3qcDQg8DYJk08mCRXATVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Steben 2018-08-01 17:17:01 Re: postgres port 5434 not being allowed when remote server is accessing
Previous Message Mark Steben 2018-08-01 17:05:28 Re: postgres port 5434 not being allowed when remote server is accessing