From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Need help in establishing pgadmin4 to connect to the postgres database server when the database is listening on port 5433 (instead of port 5432)
Date: Mon, 12 Aug 2019 17:14:04 -0500
Message-ID: <17180e4c-bac9-c9c4-de42-f99549fe8b7d@gmail.com> (raw)
In-Reply-To: <AM6PR0502MB36243AD2ECE1974DD14E33BFEFD30@AM6PR0502MB3624.eurprd05.prod.outlook.com>
References: <AM6PR0502MB3624BF8D423D6FDB944C0B08EFD30@AM6PR0502MB3624.eurprd05.prod.outlook.com>
<F6702E50CEAA3DC8.c7d7230e-3dcc-4f80-be14-e7b97c3fa7ce@mail.outlook.com>
<AM6PR0502MB36243AD2ECE1974DD14E33BFEFD30@AM6PR0502MB3624.eurprd05.prod.outlook.com>
There are more firewalls than just the one running (or not) on cemtore01.
Keep things simple and just run a traceroute from the server running
pgadmin4 to the server running postgres.
If that works, then telnet to the server on port 5433
On 8/12/19 4:51 PM, Bikram MAJUMDAR wrote:
>
> Hi Tim,
>
> Thanks for your quick response.
>
> Are you thinking port 5433 is not opened for listening on the postgres
> database server?
>
> [root@cemtore01 ~]# systemctl status firewalld.service
>
> â firewalld.service - firewalld - dynamic firewall daemon
>
> Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled;
> vendor preset: enabled)
>
> Active: active (running) since Mon 2019-04-01 05:49:28 CDT; 4 months 11
> days ago
>
> Docs: man:firewalld(1)
>
> Main PID: 883 (firewalld)
>
> CGroup: /system.slice/firewalld.service
>
> ââ883 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
>
> Apr 01 05:49:28 cemtore01 systemd[1]: Started firewalld - dynamic firewall
> daemon.
>
> Apr 01 05:49:30 cemtore01 firewalld[883]: WARNING: ICMP type
> 'beyond-scope' is not supported by the kernel for ipv6.
>
> Apr 01 05:49:30 cemtore01 firewalld[883]: WARNING: beyond-scope:
> INVALID_ICMPTYPE: No supported ICMP type., ignoring for run-time.
>
> Apr 01 05:49:30 cemtore01 firewalld[883]: WARNING: ICMP type
> 'failed-policy' is not supported by the kernel for ipv6.
>
> Apr 01 05:49:30 cemtore01 firewalld[883]: WARNING: failed-policy:
> INVALID_ICMPTYPE: No supported ICMP type., ignoring for run-time.
>
> Apr 01 05:49:30 cemtore01 firewalld[883]: WARNING: ICMP type
> 'reject-route' is not supported by the kernel for ipv6.
>
> Apr 01 05:49:30 cemtore01 firewalld[883]: WARNING: reject-route:
> INVALID_ICMPTYPE: No supported ICMP type., ignoring for run-time.
>
> May 22 11:25:23 cemtore01 firewalld[883]: ERROR: INVALID_ZONE: port
>
> May 22 11:25:40 cemtore01 firewalld[883]: ERROR: INVALID_ZONE: ports
>
> May 22 11:27:07 cemtore01 firewalld[883]: ERROR: INVALID_ZONE: zone
>
> *Bikram Majumdar*
>
> Sr Software Developer/DBA, Aqsacom Inc.
>
> *c.*1.972.365.3737
>
> <http://www.aqsacom.com/;
>
> *Disclaimer. *This electronic mail message contains CONFIDENTIAL
> information which is (a) CUSTOMER / SUPPLIER / PARTNER PRIVILEGED
> COMMUNICATION, WORK PRODUCT, PROPRIETARY IN NATURE, OR OTHERWISE PROTECTED
> BY LAW FROM DISCLOSURE, and (b) intended only for the use of the
> Addressee(s) named herein. If you are not an Addressee, or the person
> responsible for delivering this to an Addressee, you are hereby notified
> that reading, copying, or distributing this message is prohibited. If you
> have received this electronic mail message in error, please reply to the
> sender and take the steps necessary to delete the message completely from
> your computer system. Statement and opinions expressed in this e-mail are
> those of the sender, and do not necessarily reflect those of AQSACOM.
> AQSACOM accepts no liability for any damage caused by any virus/worms
> transmitted by this email.
>
> *From:* Tim Scheurenbrand <info@timscheurenbrand.de>
> *Sent:* Monday, August 12, 2019 4:25 PM
> *To:* Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>;
> pgsql-admin@postgresql.org
> *Cc:* bikramma@gmail.com
> *Subject:* Re: Need help in establishing pgadmin4 to connect to the
> postgres database server when the database is listening on port 5433
> (instead of port 5432)
>
> Hi Bikram
>
> Have you checked your firewall settings?
>
> Tim Scheurenbrand
>
>
>
> On Mon, Aug 12, 2019 at 11:08 PM +0200, "Bikram MAJUMDAR"
> <Bikram.Majumdar@aqsacom.com <mailto:Bikram.Majumdar@aqsacom.com>> wrote:
>
> Hi ,
>
> We need help in resolving connection issues using the pgadmin tool.
>
> We had our pgadmin (pgadmin4) installed a few months back on windows
> 10 and we were able to use it for our postgres server running on port
> 5432.
>
> But, recently we had to change our postgres server port from 5433 to
> 5432 -
>
> And accordingly, in pgadmin we changed the port also to 5433 – but we
> are receiving connection timed out error in connecting to our server
> (see below screen shot).
>
> Please help to resolve this issue.
>
> *Bikram Majumdar*
>
> Sr Software Developer/DBA, Aqsacom Inc.
>
> *c.*1.972.365.3737
>
> *e.*bikram.majumdar@aqsacom.com <mailto:bikram.majumdar@aqsacom.com>
>
> *s.*BIKRAM MAJUMDAR
>
> <http://www.aqsacom.com/;
>
> *Disclaimer. *This electronic mail message contains CONFIDENTIAL
> information which is (a) CUSTOMER / SUPPLIER / PARTNER PRIVILEGED
> COMMUNICATION, WORK PRODUCT, PROPRIETARY IN NATURE, OR OTHERWISE
> PROTECTED BY LAW FROM DISCLOSURE, and (b) intended only for the use of
> the Addressee(s) named herein. If you are not an Addressee, or the
> person responsible for delivering this to an Addressee, you are hereby
> notified that reading, copying, or distributing this message is
> prohibited. If you have received this electronic mail message in
> error, please reply to the sender and take the steps necessary to
> delete the message completely from your computer system. Statement and
> opinions expressed in this e-mail are those of the sender, and do not
> necessarily reflect those of AQSACOM. AQSACOM accepts no liability for
> any damage caused by any virus/worms transmitted by this email.
>
--
Angular momentum makes the world go 'round.
Attachments:image004.png (image/png, 10.0K) downloadview imageimage006.jpg (image/jpeg, 29.6K) downloadview imageimage008.png (image/png, 10.0K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Need help in establishing pgadmin4 to connect to the postgres database server when the database is listening on port 5433 (instead of port 5432)
In-Reply-To: <17180e4c-bac9-c9c4-de42-f99549fe8b7d@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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