Unable to install Application Stack Builder

Hello,

We use a Windows 2019 Datacenter OS based machine(server) where we are trying to install Application StackBuilder tools, including Npgsql tool. However, we get the error that we are unable to resolve. The firewall settings do allow all the PostgreSQL.org urls.

[cid:image001.png@01D97E82.EF73C410]

The errors we get when we try to install the stackbuilder tool on this machine are:

[cid:image004.png@01D97E84.411D1C70]

And when we choose 'Yes', the next message appears forcing the termination of the installation.

[cid:image005.png@01D97E84.863C9380]

As I said earlier, we have allowed *postgresql.org/* in the firewall whitelisted URLs. Please help us get this issue resolved. Now we are unable to connect to PostgreSQL dB from MS Excel. And it is a showstopper in moving away from MS SQL to PostgreSQL dB.

Thank You,
Subash

Company Registration number: 197807; Place of Registration: England; Registered office address: 2nd Floor, 400 Dashwood Lang Road, Bourne Business Park, Addlestone, Surrey, KT15 2HJ. Please consider the environment before you print this message.Confidentiality Notice: This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you should not disseminate, copy or distribute this email or its contents. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer.

Hi Subash,

From where did you download the installer?

On Thu, May 4, 2023 at 6:12 PM Krishnawarriar, Subash <
subash.krishna@brambles.com> wrote:

Hello,

We use a Windows 2019 Datacenter OS based machine(server) where we are
trying to install Application StackBuilder tools, including Npgsql tool.
However, we get the error that we are unable to resolve. The firewall
settings do allow all the PostgreSQL.org urls.

The errors we get when we try to install the stackbuilder tool on this
machine are:

And when we choose ‘Yes’, the next message appears forcing the termination
of the installation.

As I said earlier, we have allowed **postgresql.org/
<http://postgresql.org/&gt;** in the firewall whitelisted URLs. Please help
us get this issue resolved. Now we are unable to connect to PostgreSQL dB
from MS Excel. And it is a showstopper in moving away from MS SQL to
PostgreSQL dB.

Thank You,

Best Regards,

*Subash Krishnawarriar, PMP®________________________________*

*Senior Application Transformation Manager*

Brambles UK Limited,

Level 2, 400 Dashwood Lang Road,

Bourne Business
Park, Tel
+441932963198

Addlestone, KT15
2HJ, Mobile
+447917071450

United Kingdom
Subash.krishna@Brambles.com

Company Registration number: 197807; Place of Registration: England;
Registered office address: 2nd Floor, 400 Dashwood Lang Road, Bourne
Business Park, Addlestone, Surrey, KT15 2HJ. Please consider the
environment before you print this message.Confidentiality Notice: This
email is intended only for the use of the party to which it is addressed
and may contain information that is privileged, confidential, or protected
by law. If you are not the intended recipient you should not disseminate,
copy or distribute this email or its contents. If you have received this
message in error, please notify us immediately by replying to the message
and deleting it from your computer.

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/&gt;
"Don't Complain about Heat, Plant a TREE"

On Thu, 4 May 2023 at 13:42, Krishnawarriar, Subash <
subash.krishna@brambles.com> wrote:

Hello,

We use a Windows 2019 Datacenter OS based machine(server) where we are
trying to install Application StackBuilder tools, including Npgsql tool.
However, we get the error that we are unable to resolve. The firewall
settings do allow all the PostgreSQL.org urls.

The errors we get when we try to install the stackbuilder tool on this
machine are:

And when we choose ‘Yes’, the next message appears forcing the termination
of the installation.

As I said earlier, we have allowed **postgresql.org/
<http://postgresql.org/&gt;** in the firewall whitelisted URLs. Please help
us get this issue resolved. Now we are unable to connect to PostgreSQL dB
from MS Excel. And it is a showstopper in moving away from MS SQL to
PostgreSQL dB.

That's an error from Windows. Schannel is the Microsoft security
infrastructure used to implement SSL/TLS, and it's complaining it cannot
reach the server which tells it what certificates have been revoked. That
server isn't run by us; essentially, it's all Microsoft code and
infrastructure.

You'd need to figure out why your system cannot reach the revocation server.

--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

Hi,

We downloaded it from PostgreSQL.org site.

Sent from Outlook for iOS<https://aka.ms/o0ukef&gt;
________________________________
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Friday, May 5, 2023 1:44:21 PM
To: Krishnawarriar, Subash <subash.krishna@brambles.com>
Cc: pgadmin-support@postgresql.org <pgadmin-support@postgresql.org>
Subject: Re: Unable to install Application Stack Builder

Hi Subash, From where did you download the installer? On Thu, May 4, 2023 at 6: 12 PM Krishnawarriar, Subash <subash. krishna@ brambles. com> wrote: Hello, We use a Windows 2019 Datacenter OS based machine(server) where we are trying to install
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
<https://us-phishalarm-ewt.proofpoint.com/EWT/v1/HDu-1JFExg!2lHicPZILvBoBS0XkNlRbTqXFbvB23NQTHbeLtWkHHK9gfC5kNQRZmWsrCkLsNu-BnreNIYvjsElHaep2Y-hLY9tv4zalnKhIxEqT_gjw3HIfWGL7DaYXhZHndcxzMev$&gt;
Report Suspicious

ZjQcmQRYFpfptBannerEnd
Hi Subash,

From where did you download the installer?

On Thu, May 4, 2023 at 6:12 PM Krishnawarriar, Subash <subash.krishna@brambles.com<mailto:subash.krishna@brambles.com>> wrote:

Hello,

We use a Windows 2019 Datacenter OS based machine(server) where we are trying to install Application StackBuilder tools, including Npgsql tool. However, we get the error that we are unable to resolve. The firewall settings do allow all the PostgreSQL.org urls.

[cid:187eaf956aa4cff311]

The errors we get when we try to install the stackbuilder tool on this machine are:

[cid:187eaf956aa7745b44]

And when we choose ‘Yes’, the next message appears forcing the termination of the installation.

[cid:187eaf956aa855d355]

As I said earlier, we have allowed *postgresql.org/<https://urldefense.com/v3/__http://postgresql.org/__;!!HDu-1JFExg!QAIl4Qzu-ucpHGNqjVb-_tZTjmDx_uKcju4c4NF6EhMS7sH_UiJoolZYVuoP1xFX0bKBZGir9L_mUX_Cu8jCtQUYJmP9DXm3v4RW$&gt;* in the firewall whitelisted URLs. Please help us get this issue resolved. Now we are unable to connect to PostgreSQL dB from MS Excel. And it is a showstopper in moving away from MS SQL to PostgreSQL dB.

Thank You,

Best Regards,

[cid:187eaf956aa5b006a2]

Subash Krishnawarriar, PMP®________________________________

Senior Application Transformation Manager

Brambles UK Limited,

Level 2, 400 Dashwood Lang Road,

Bourne Business Park, Tel +441932963198

Addlestone, KT15 2HJ, Mobile +447917071450

United Kingdom Subash.krishna@Brambles.com<mailto:Subash.krishna@Brambles.com>

[cid:187eaf956aa692e333]

Company Registration number: 197807; Place of Registration: England; Registered office address: 2nd Floor, 400 Dashwood Lang Road, Bourne Business Park, Addlestone, Surrey, KT15 2HJ. Please consider the environment before you print this message.Confidentiality Notice: This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you should not disseminate, copy or distribute this email or its contents. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer.

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com<https://urldefense.com/v3/__https://www.enterprisedb.com/__;!!HDu-1JFExg!QAIl4Qzu-ucpHGNqjVb-_tZTjmDx_uKcju4c4NF6EhMS7sH_UiJoolZYVuoP1xFX0bKBZGir9L_mUX_Cu8jCtQUYJmP9DT0EoXVQ$&gt;
"Don't Complain about Heat, Plant a TREE"

I know nothing about this, but doing a quick Google Search, this is an EDB
sourced tool, and there are binaries that are to be downloaded.

The EDB install site link is
https://www.enterprisedb.com/docs/supported-open-source/postgresql/installer/03_using_stackbuilder/
The site linked at https://www.postgresql.org/download/windows/ states
specifically it is hosted at EDB.

EDB is a separate organization, which this forum doesn't cover.

On Fri, 5 May 2023 at 18:17, Krishnawarriar, Subash <
subash.krishna@brambles.com> wrote: