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