pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres port 5434 not being allowed when remote server is accessing
7+ messages / 5 participants
[nested] [flat]
* postgres port 5434 not being allowed when remote server is accessing
@ 2018-08-01 16:22 Mark Steben <mark.steben@drivedominion.com>
0 siblings, 2 replies; 7+ messages in thread
From: Mark Steben @ 2018-08-01 16:22 UTC (permalink / raw)
To: pgsql-admin
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/;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres port 5434 not being allowed when remote server is accessing
@ 2018-08-01 16:26 Arlindo Neto <neto.acs@gmail.com>
parent: Mark Steben <mark.steben@drivedominion.com>
1 sibling, 1 reply; 7+ messages in thread
From: Arlindo Neto @ 2018-08-01 16:26 UTC (permalink / raw)
To: mark.steben@drivedominion.com; +Cc: pgsql-admin
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.steben@drivedominion.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/;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres port 5434 not being allowed when remote server is accessing
@ 2018-08-01 17:05 Mark Steben <mark.steben@drivedominion.com>
parent: Arlindo Neto <neto.acs@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Mark Steben @ 2018-08-01 17:05 UTC (permalink / raw)
To: Arlindo Neto <neto.acs@gmail.com>; +Cc: pgsql-admin
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.acs@gmail.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.steben@drivedominion.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/;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres port 5434 not being allowed when remote server is accessing
@ 2018-08-01 17:10 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: Mark Steben <mark.steben@drivedominion.com>
0 siblings, 1 reply; 7+ messages in thread
From: Mariel Cherkassky @ 2018-08-01 17:10 UTC (permalink / raw)
To: Mark Steben <mark.steben@drivedominion.com>; +Cc: Arlindo Neto <neto.acs@gmail.com>; pgsql-admin
Hi, what error do you get?
On Wed, Aug 1, 2018, 8:05 PM Mark Steben <mark.steben@drivedominion.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.acs@gmail.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.steben@drivedominion.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/;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres port 5434 not being allowed when remote server is accessing
@ 2018-08-01 17:17 Mark Steben <mark.steben@drivedominion.com>
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Mark Steben @ 2018-08-01 17:17 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: Arlindo Neto <neto.acs@gmail.com>; pgsql-admin
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.cherkassky@gmail.com> wrote:
> Hi, what error do you get?
>
>
> On Wed, Aug 1, 2018, 8:05 PM Mark Steben <mark.steben@drivedominion.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.acs@gmail.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.steben@drivedominion.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/;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres port 5434 not being allowed when remote server is accessing
@ 2018-08-01 18:00 Ron <ronljohnsonjr@gmail.com>
parent: Mark Steben <mark.steben@drivedominion.com>
0 siblings, 0 replies; 7+ messages in thread
From: Ron @ 2018-08-01 18:00 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
nmap to the rescue!!!
It's a go-to tool in cases like this.
On 08/01/2018 12:17 PM, Mark Steben wrote:
> 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.cherkassky@gmail.com <mailto:mariel.cherkassky@gmail.com>> wrote:
>
> Hi, what error do you get?
>
>
> On Wed, Aug 1, 2018, 8:05 PM Mark Steben
> <mark.steben@drivedominion.com <mailto:mark.steben@drivedominion.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.acs@gmail.com
> <mailto:neto.acs@gmail.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.steben@drivedominion.com
> <mailto:mark.steben@drivedominion.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?
>
>
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: postgres port 5434 not being allowed when remote server is accessing
@ 2018-08-02 08:05 Fabio Pardi <f.pardi@portavita.eu>
parent: Mark Steben <mark.steben@drivedominion.com>
1 sibling, 0 replies; 7+ messages in thread
From: Fabio Pardi @ 2018-08-02 08:05 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2018-08-02 08:05 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-08-01 16:22 postgres port 5434 not being allowed when remote server is accessing Mark Steben <mark.steben@drivedominion.com>
2018-08-01 16:26 ` Arlindo Neto <neto.acs@gmail.com>
2018-08-01 17:05 ` Mark Steben <mark.steben@drivedominion.com>
2018-08-01 17:10 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
2018-08-01 17:17 ` Mark Steben <mark.steben@drivedominion.com>
2018-08-01 18:00 ` Ron <ronljohnsonjr@gmail.com>
2018-08-02 08:05 ` Fabio Pardi <f.pardi@portavita.eu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox