Thread: cannot run pgadmin on database listening on port 5434
Good morning,
I am running pgadmin4 (3.5) We currently run postgres 9.4.8 in our production environments
I have a linux server running two instances of postgres 9.4. One listens on port 5433 and one listens on port 5434. I can login to the instance on 5433 but not on 5434, receiving this error:
Unable to connect to server:
could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "10.93.156.52" and accepting
TCP/IP connections on port 5434?
could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "10.93.156.52" and accepting
TCP/IP connections on port 5434?
As I mentioned databases are running and active on port 5433 AND 5434 on server 10.93.156.52. I can login to 5433 via pgadmin but not on 5434.
Any comments/suggestions welcome. Thank you,
-- Mark Steben
Database Administrator
@utoRevenue | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
Database Administrator
@utoRevenue | Autobase
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
Looks like a firewall or pg_hba.conf issue, probably the 5433 is open to pgadmin4 client but not 5434.
En 9 de enero de 2019 14:14:19 Mark Steben <mark.steben@drivedominion.com> escribió:
Good morning,I am running pgadmin4 (3.5) We currently run postgres 9.4.8 in our production environmentsI have a linux server running two instances of postgres 9.4. One listens on port 5433 and one listens on port 5434. I can login to the instance on 5433 but not on 5434, receiving this error:Unable to connect to server:
could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "10.93.156.52" and accepting
TCP/IP connections on port 5434?As I mentioned databases are running and active on port 5433 AND 5434 on server 10.93.156.52. I can login to 5433 via pgadmin but not on 5434.Any comments/suggestions welcome. Thank you,--Mark Steben
Database Administrator
@utoRevenue | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com