Postgresql stack builder error

postgresql stack builder error

Cc: pgsql-bugs(at)postgresql(dot)org · Subject: Re: BUG #6427: Installation stack builder · Date: 2012-02-02 06:46:19 · D5019C6D-7202-401D-A5F5-8578251CD362. The Stack Builder utility provides a graphical interface that simplifies the process of downloading and installing modules that complement your PostgreSQL. On error mesage (0x80090325) whilst installing Apps Stack Builder installation I am installing software I select "PostgreSQL 9.5 (x64).

Postgresql stack builder error - sorry

Re: Fwd: StackBuilder can't fetch application list?

Ah! Got it - I was using the full URL in the Proxy settings in
Stackbuilder. It only needs the "proxy.whatever.com" without the
protocol

Thanks for the assist Craig!

________________________________

From: Craig Barnes [mailto:cjbarnes18(at)gmail(dot)com]
Sent: Tuesday, September 07, 2010 1:33 PM
To: Turner, John J
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Fwd: StackBuilder can't fetch application list?

Hi John,

if what you are seeing in the browser looks something like this

<applications>
<application>
<id>pgoledb</id>
<platform>windows</platform>
<version>1.0.0.20</version>
<name>PgOleDB</name>
<description>An OLE DB Provider for PostgreSQL</description>
<category>Database Drivers</category>
<format>msi</format>
<upgradeoptions>/qr REINSTALLMODE=vamus REINSTALL=all</upgradeoptions>
<checksum>E148691AA76A81033438FC9B03F4478A</checksum>
<mirrorpath>
/projects/pgFoundry/stackbuilder/PgOleDB-1.0.0.20.msi
</mirrorpath>
<versionkey>Software\PgOleDB\Version</versionkey>
</application>
...

Then this is the xml that you should expect to see from the URL
http://www.postgresql.org/applications-v2.xml.

If this is the case it would seem that your proxy settings in IE are ok,
and that stackbuilder is having difficulty accessing it.

I don't use windows any more so cant suggest where to look further in
stackbuilder, here are some places you could look though.

* Are there settings in stackbuilder for Proxy?
* Do you have firewall software installed that blocks unauthorised
applications from accessing the the internet?

Hope this helps

Regards

Craig

On 7 September 2010 16:43, Turner, John J <JJTurner(at)statestreet(dot)com>
wrote:

Sachin,

I confirmed HTTP Proxy Settings with our company's tech Helpdesk and
website is still showing up as HTML code. They navigated to same URL
with same effect.

Could this possibly be an issue with the actual site rather than my
settings or IE??

________________________________

From: Sachin Srivastava [mailto:sachin(dot)srivastava(at)enterprisedb(dot)com]
Sent: Tuesday, September 07, 2010 8:28 AM
To: Turner, John J
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Fwd: StackBuilder can't fetch application list?

John,

You need to fix the HTTP Proxy Settings as per your IE. Also if the URL
gets opened in the IE, it should get opened by the stackbuilder also.

On 9/3/10 7:51 PM, Turner, John J wrote:

Hi Sachin,

I tried setting the http Proxy details in SB based on the settings in my
IExplorer - i.e., http://proxy.foo.com <http://proxy.foo.com/> , port
80, to no avail...

I don't have an FTP proxy I'm aware of, but perhaps that's what I need
instead?

________________________________

From: Sachin Srivastava [mailto:sachin(dot)srivastava(at)enterprisedb(dot)com]
Sent: Friday, September 03, 2010 2:56 AM
To: Turner, John J
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Fwd: StackBuilder can't fetch application list?

John,

Are you behind a proxy server?
If yes try setting the Proxy details on the Introduction/First page od
Stackbuilder and then try to connect.


Tom, thank again -

PG did install with StackBuilder, but when I try to use it to pull the
list of available applications, I'm getting an error message:

Failed to open the application list:
http://www.postgresql.org/applications-v2.xml

Error: The URL specified could not be opened

When I navigate to the URL using my browser, it simply displays html
code...?



-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]=20
Sent: Wednesday, September 01, 2010 6:20 PM
To: Turner, John J
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Installing temporal "period" data type and support
functions=20

"Turner, John J" <JJTurner(at)statestreet(dot)com>
<mailto:JJTurner(at)statestreet(dot)com> writes:

I have a "pg_config.exe" located in c:\program
files\PostgreSQL\9.0\bin... beyond that I'm stumped at the
moment, I'm
afraid


Oh, then this is Windows? Sorry, my comments were for Unix-ish
platforms. I'm afraid I don't know anything about building software
on Windows ... but you probably don't want to get involved with that
anyway. You should look around and see if there's a prepackaged
version of the temporal module available already. If you used the
one-click Windows installer for PG, the "StackBuilder" component
might have it available.

regards, tom lane

------- End of Forwarded Message



--
Regards,
Sachin Srivastava
EnterpriseDB <http://www.enterprisedb.com> , the Enterprise Postgres
<http://www.enterprisedb.com> company.

--
Regards,
Sachin Srivastava
EnterpriseDB <http://www.enterprisedb.com> , the Enterprise Postgres
<http://www.enterprisedb.com> company.

In response to

Browse pgsql-novice by date

PostgreSQL 10.4 installation failed.

PostgreSQL failing to install isn't something that is seen to happen very often.  Try to install it manually instead. The installer unpacks the PostgreSQL installer when it runs, copy it out of the Temp folder and run it by itself.
  • Start the WS_FTP installer
  • Open Windows File Explorer and type %TEMP% in the address bar and press enter
  • There should be a folder with a long string of letters and numbers, open it (it may require going through a couple to find the file)
  • Look for the file "postgresql-10.4.1-windows-x64.exe"
  • Copy this to the desktop
Once the installer has been saved, cancel the WS_FTP Server installer. Then run the PostgreSQL installer by itself.
NOTE: Make sure to uncheck the box to run the Stack Builder before clicking the Finish button.

Once PostgreSQL is finished setting up, run the WS_FTP Server installer again.
 

If receiving an error that the IPS_ user is not found, or cannot log in, when running the WS_FTP installer

This is due to the IPS_ user not being set up in PGAdmin4. Manually create this user.
  • Open PGAdmin4
  • Expand Servers and right-click on PostgreSQL and choose Properties
  • Switch to the Connection tab and change the Username to postgres, then save
  • Double click PostgreSQL 10 under Servers and type in the password that was used for the postgres user during the PostgreSQL install
  • Right-click on "Login/Group Roles" and choose Create > Login Group/Role
  • The name will be IPS_ and then the username that was chosen during the WS_FTP install
    • For example, if the username ftpadmin was entered, type in IPS_ftpadmin (add IPS_ before the chosen username)
  • Switch to the Definition tab and type in the Password that was created during the WS_FTP Server install
  • Switch to the Privileges tab
    • Change Login to Yes
    • Change Superuser to Yes
  • Save that new Login Role
  • Run the WS_FTP Server installer again

PostgreSQL Stack Builder Installation Certificate verification problem on Windows

I have downloaded and installed PostgreSQL 12 (64 bit) on a developer machine running Windows 10 Pro Education (64 bit).

When the installation came to the Stack Builder download application list step, an error occurred as follows:

A certification verification problem was encountered whilst accessing https://www.postgresql.org/applications-v2.xml schannel: next InitializeSecurityContext failed: Unknown error (0x80092013) - The revocation function was unable to check revocation because the revocation server was offline. This means that the source download cannot be verified. It is recommended that you do not continue with the download as it may be coming from a site that is pretending to be the intended download site and may contain viruses or malware.

Do you wish to continue?

I have tried to use Proxy servers referring to this answer. https://serverfault.com/questions/555125/postgresql-stack-builder-installation-proxy-setting-on-windows

I have also tried both solutions from that question. Still, I can not get the application list downloaded.

I want to install PostGIS. It seems the stack builder is safe and easy to use. What should I do to get the PostGIS installed?

In this article, we are going to learn how we can install and configure PostgreSQL on windows 10. PostgreSQL, also known as Postgres, is a free and open relational database management system.

The PostgreSQL database manages the multi-version concurrency control to manage the concurrency (MVCC). When we run a transaction on PostgreSQL, it gives the snapshot of the database, which allows each transaction to made changes on the database without affecting the other transaction. PostgreSQL has three levels of transaction isolation.

  1. Read committed
  2. Repeatable Read
  3. Serializable

We can install PostgreSQL on the following operating systems:

  1. Windows
  2. Linux
  3. Mac OS Server
  4. Free BSD and Open BSD

In this article, we are going to focus on the step-by-step installation process of PostgreSQL on windows 10. Before the installation, we must download the stable copy of the PostgreSQL 13 server from the location. We can use this installer to install PostgreSQL on windows in graphical and silent mode. The setup file contains the following software packages:

  1. PostgreSQL 13 server
  2. pgAdmin: It is a graphical tool to develop and manage the PostgreSQL server and database
  3. Stack builder: It is a package manager that contains additional tools that are used for management, migration, replication, connectors, and other tools

Once the setup file has been downloaded, double-click on the file. The installation wizard of PostgreSQL on Windows has begun. The first screen is the Welcome screen of the PostgreSQL installation.

Postgresql on windows installation began

On the Installation directory screen, specify the location where you want to install the PostgreSQL.

Specify installtion directory

On the Select component screen, choose the component that you want to install on your workstation. You can choose any of the following:

  1. PostgreSQL Server
  2. pgAdmin4: It is a graphical interface that is used to manage the PostgreSQL database
  3. Stack builder: The stack builder will be used to download and install drivers and additional tools
  4. Command-line tools. The command-line tools and client libraries like pg_bench, pg_restore, pg_basebackup, libpq, pg_dump, and pg_restore will be installed

In our case, we will install all components.

Choose PostgreSQL components

On the Data Directory screen, specify the directory where you want to store the database files. In our case, the data directory is C:\PostgreSQL Data.

Specify Data directory

On the Password screen, specify the database superuser password. This password will be used to connect to the PostgreSQL database server.

Specify password of superuser

On the Port screen, specify the Port number on which the PostgreSQL server will listen to the incoming connections. By default, the PostgreSQL server listens on port number 5432. You can specify the non-default post on this screen. Make sure any other application must not use the port you specify in the Port textbox, and it must allow the incoming and outgoing connections. In our case, I am not changing the port.

specify port

You can choose the locale that you want to use in the database on the advance option screen. In our case, I am choosing the default locale.

specify locale

On the Pre-Installation Summary screen, you can view the settings used for installing the PostgreSQL server.

PostgreSQL on windows installation summary

The Ready to install screen is the notification screen that states that the PostgreSQL installation process will begin.

PostgreSQL on windows installation Ready to install

The installation process of PostgreSQL on windows has begun.

PostgreSQL on windows is installing

The PostgreSQL server has been installed successfully. If you want to install additional components and drivers, you can choose to open the stack builder. In our case, I am not installing additional components. Click on Finish to complete the installation.

PostgreSQL on Windows Installation completed.

Now, reboot the workstation. Let us understand how we can connect to the PostgreSQL server using pgAdmin4 and SQL Shell (pSQL).

Connect to PostgreSQL using pgAdmin4

We can use the pgAdmin4 tool to manage and administrate the PostgreSQL server. We can also use the pgAdmin4 to execute the Adhoc queries and create database objects.

To connect to the PostgreSQL. Launch the pgAdmin4. On the first screen, specify the password of the superuser that can be used to connect to the PostgreSQL Server.

Provide password of superuser

Once you’re connected to PostgreSQL13, you can view the database objects in the Browser pan. To view the installed servers, expand Servers. Under Servers, you can view the list of installed servers. In our case, the installed PostgreSQL is PostgreSQL13. You can view the list of databases, users, and tablespaces under PostgreSQL13.

View PostgreSQL instances

We can view the Server Activities and the configuration of the PostgreSQL server in the Dashboard tab.

PostgreSQL Server dashboard

You can view the list of sessions, locks acquired by the process, prepared transactions, and configuration under the server activity pan.

PostgreSQL Server activity

Now, let us see how we can create a database.

How to create a database using pgAdmin4

Now, let us create a database using pgAdmin4. To create a database, Expand Serves 🡪 Expand PostgreSQL13 🡪 Right-click on Databases 🡪 Hover Create 🡪 Select Database.

Create database

A Create database dialog box opens. In the general tab, specify the database name in the Database Textbox.

Specify the database name

You can specify the Database Encoding template used to create a database, tablespace, database collation, character type, and connection limit on the Definition tab.

Specify the different parameters

In the Security tab, you can configure the privileges and security configuration. In our case, we have not changed anything.

Configure security

In the Parameters tab, you can configure the database-specific parameters. I have not changed any configuration.

Configure advance parameter

In the SQL tab, you can view the CREATE DATABASE statement generated with the configuration defined in the Create – database dialog box.

Create database statement

Click on Save to create the database named EmployeeDB and close the dialog box. You can view the new database in Browser pan.

Database has been created

As you can see, the database has been created successfully.

  • Note: If you do not see the EmployeeDB database in the Browser pane, right-click on the Databases and select Refresh

    Refresh database

We can view the database files under the C:\PostgreSQL Data directory. See the following screenshot.

View database files

Now, let us see how we can execute the queries on PostgreSQL.

Querying the PostgreSQL database using pgAdmin4

To execute the queries using the pgAdmin4, Click on Tools 🡪 Click on Query Tool.

Open query editor

A query editor pan opens. Now, let us create a table named tblEmployeeGrade. The following query creates a table.

CreatetabletblEmployee

    (

        Employee_IDvarchar(20),

        First_namevarchar(500),

        middle_namevarchar(500),

        last_namevarchar(500),

        Addressvarchar(1000),

        Contact_numberint,

        DepartmentIDint,

        GradeIDint,

    )

Screenshot of the Query Editor:

create table in Query editor

As you can see, the query execution status will be displayed in the messages pan. Now, let us insert some records in the tblemployee. Run the following query to insert data in tblemployee.

insertintotblemployee

(Employee_ID,First_name,middle_name,last_name,Address,Contact_number,DepartmentID,GradeID)

values

('EMP0001','Nisarg','Dixitkumar','Upadhyay','AB14, Akshardham Flats, Mehsana',123456,10,10),

('EMP0002','Nirali','Nisarg','Upadhyay','AB14, Suyojan Road,  Ahmedabad',123456,10,10),

('EMP0003','Dixit','Lalshankar','Upadhyay','AB14, Suramya Stauts, Ahmedabad',123456,10,10)

Insert statement in Query editor

Run the SELECT statement to populate the data from the tblemployee table.

1

Select*fromtblemployee

Select Query output

As you can see, the query output had populated the data in grid view format and can be viewed in the Data output pan.

Connect to PostgreSQL using SQL Shell (pSQL)

We can use the pSQL command-line utility to manage the PostgreSQL database. The SQL Shell is automatically installed with the PostgreSQL server. When we launch the SQL Shell, it prompts for following options.

  1. Server Name: Specify the hostname of the machine on which the PostgreSQL has been installed. If you do not specify the hostname, then pSQL will connect to the localhost
  2. Database: Specify the database name that you want to use. If you do not specify the database name, pSQL will connect to the Postgres database
  3. Port: Specify the port. If you do not specify any port, pSQL will use port number 5432 to connect to the server
  4. Username: specify the username that you want to use to connect to PostgreSQL. If you do not specify the username, the pSQL will use the Postgres user
  5. Password: Specify the password of the user specified in the username parameter

Specify all the parameters and hit enter to connect to the database.

PostgreSQL connected using pSQL.

As you can see, the connection has been established successfully.

Summary

In this article, we learned the step-by-step installation process of PostgreSQL on windows 10. I have also given a high-level overview of the pgAdmin4 tool and how we can connect to the PostgreSQL database using pgAdmin and SQL Shell (pSQL) utility.

Nisarg Upadhyay

Nisarg Upadhyay

Nisarg Upadhyay is a SQL Server Database Administrator and Microsoft certified professional who has more than 8 years of experience with SQL Server administration and 2 years with Oracle 10g database administration.

He has expertise in database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades. He has completed the B.Tech from Ganpat University. He can be reached on [email protected]

Nisarg Upadhyay

Latest posts by Nisarg Upadhyay (see all)

PostgreSQL

About Nisarg Upadhyay

Nisarg Upadhyay is a SQL Server Database Administrator and Microsoft certified professional who has more than 8 years of experience with SQL Server administration and 2 years with Oracle 10g database administration. He has expertise in database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades. He has completed the B.Tech from Ganpat University. He can be reached on [email protected]

View all posts by Nisarg Upadhyay →

PostgreSQL Stack Builder Installation Proxy Setting on Windows

I have downloaded and installed PostgreSQL 9.3 (64 bit) on a developer machine running Windows 8.1 (64 bit). This developer machine requires use of a proxy server for accessing hosts external to the LAN.

The StackBuilder 3.1.1 Wizard / Installer pulls the proxy settings from IE, and they appear to be correct, but when clicking the "Next" button, I receive a "Stack Builder Error" dialog indicating:

Failed to open the application list: http://www.postgresql.org/applications-v2.xml Error: The URL specified could not be opened.

I have been able to successfully download the application list using IE and Chrome with the same proxy settings the installer initially pulled from IE.

Other things I have tried:

  • Pre-pending the proxy server hostname with the protocol 'http://'
  • Used the proxy server's IP address instead of the hostname
  • Removed the proxy settings entirely

In the first two cases, the installer responds almost immediately with the error message above. In the last, there is about a 5 second delay before it responds with the error message above.

A similar problem seems to be documented as a bug on the PostgreSQL bug tracker but there has been no response to the initial report.

Is anybody familiar with this problem, and if so, what work arounds have been found to be effective in using the Stack Builder installer?

On error mesage (0x80090325) whilst installing Apps Stack Builder

Hi,

Although I'm fairly familiar with IT in general and DBMS in
particular, I'm new to GIS. After reviewing several sources it seems
that a good choice to star t is PostgreSQL.

I downloaded and installed successfuly the setup, on a PC desktop
running Windows Seven Home Premium.

Then came Stack Builder 4.1.0's turn. When instructed to select the
installation I am installing software I select "PostgreSQL 9.5 (x64)
on port 5432"

The problem is that I keep getting the following error mesage:
----------------------------------------------------------------------------------------------------
A certificate verification problem was encountered whilst accessing
https//www.postgresql.org/applications-v2.xml
schcannel: next InitializeSecurityContext failed:
SEC_E_UNTRUSTED_ROOT (0x80090325) - The certificate chain was
issued by an authority that is not trusted.
This means that the source of the download cannot be verified. it is
recommended that you do not continue with the download as it may
be coming from a site that is preending to be the intended download
site and may contain viruses or malware.

Do you wish to continue?
---------------------------------------------------------------------------------------------------
I intend to continue, but there again I keep getting the following
error message:
----------------------------------------------------------------------------------------------------
Couldn't access the URL
'https://www.postgresql.org/applications-v2.xml'.

ERROR: schannel: next InitializeSecurityContext failed:
SEC_E_UNTRUSTED_ROOT (0x80090325) - The certificate chain was
issued by an authority that is not trusted.
---------------------------------------------------------------------------------------------------
I should be most grateful if any of you would provide me with any advice.

Best regards.
Pablo Liendo
Caracas

---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus

Responses

Browse pgsql-general by date

Can recommend: Postgresql stack builder error

Postgresql stack builder error
PCTSGUI ERROR 0XC0000142
Bios hdd self test error read failure
postgresql stack builder error

Postgresql stack builder error - remarkable, rather

PostgreSQL 10.4 installation failed.

PostgreSQL failing to install isn't something that is seen to happen very often.  Try to install it manually instead. The installer unpacks the PostgreSQL installer when it runs, copy it out of the Temp folder and run it by itself.
  • Start the WS_FTP installer
  • Open Windows File Explorer and type %TEMP% in the address bar and press enter
  • There should be a folder with a long string of letters and numbers, open it (it may require going through a couple to find the file)
  • Look for the file "postgresql-10.4.1-windows-x64.exe"
  • Copy this to the desktop
Once the installer has been saved, cancel the WS_FTP Server installer. Then run the PostgreSQL installer by itself.
NOTE: Make sure to uncheck the box to run the Stack Builder before clicking the Finish button.

Once PostgreSQL is finished setting up, run the WS_FTP Server installer again.
 

If receiving an error that the IPS_ user is not found, or cannot log in, when running the WS_FTP installer

This is due to the IPS_ user not being set up in PGAdmin4. Manually create this user.
  • Open PGAdmin4
  • Expand Servers and right-click on PostgreSQL and choose Properties
  • Switch to the Connection tab and change the Username to postgres, then save
  • Double click PostgreSQL 10 under Servers and type in the password that was used for the postgres user during the PostgreSQL install
  • Right-click on "Login/Group Roles" and choose Create > Login Group/Role
  • The name will be IPS_ and then the username that was chosen during the WS_FTP install
    • For example, if the username ftpadmin was entered, type in IPS_ftpadmin (add IPS_ before the chosen username)
  • Switch to the Definition tab and type in the Password that was created during the WS_FTP Server install
  • Switch to the Privileges tab
    • Change Login to Yes
    • Change Superuser to Yes
  • Save that new Login Role
  • Run the WS_FTP Server installer again

PostgreSQL Stack Builder Installation Certificate verification problem on Windows

I have downloaded and installed PostgreSQL 12 (64 bit) on a developer machine running Windows 10 Pro Education (64 bit).

When the installation came to the Stack Builder download application list step, an error occurred as follows:

A certification verification problem was encountered whilst accessing https://www.postgresql.org/applications-v2.xml schannel: next InitializeSecurityContext failed: Unknown error (0x80092013) - The revocation function was unable to check revocation because the revocation server was offline. This means that the source download cannot be verified. It is recommended that you do not continue with the download as it may be coming from a site that is pretending to be the intended download site and may contain viruses or malware.

Do you wish to continue?

I have tried to use Proxy servers referring to this answer. https://serverfault.com/questions/555125/postgresql-stack-builder-installation-proxy-setting-on-windows

I have also tried both solutions from that question. Still, I can not get the application list downloaded.

I want to install PostGIS. It seems the stack builder is safe and easy to use. What should I do to get the PostGIS installed?

How to install PostGIS and pgrouting on Windows if Stack Builder fails to connect?

I know this has probably been covered and that there are plenty of guides out there, but for the life of me I cannot get pgrouting installed. All guides/how-tos are different or assume prior knowledge. I'm a QGIS newbie and please assume I know nothing!

How do install pgrouting? And what do I need first and how do I install whatever is needed? Can some helpful soul offer a step-by-step guide?

I've been trying to do this for days. I can get Postgres installed but the Stack Builder will not connect. I am thoroughly confused.

I'm using Windows 7 Enterprise 64bit Service Pack 1, QGIS Lisboa.

I'm now having trouble getting PostgreSQL to install.

Executing cscript //NoLogo "C:\Program Files (x86)\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files (x86)\PostgreSQL\9.2" "C:\Program Files (x86)\PostgreSQL\9.2\data" 5432 Script exit code: 2

Script output: Installing the adminpack module in the postgres database... Executing 'C:\Users\ucesga1\AppData\Local\Temp\rad87BB2.bat'... psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

Failed to install the 'adminpack' module in the 'postgres' database loadmodules.vbs ran to completion

Script stderr: Program ended with an error exit code

Error running cscript //NoLogo "C:\Program Files (x86)\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files (x86)\PostgreSQL\9.2" "C:\Program Files (x86)\PostgreSQL\9.2\data" 5432 : Program ended with an error exit code

enter image description here

On error mesage (0x80090325) whilst installing Apps Stack Builder

Hi,

Although I'm fairly familiar with IT in general and DBMS in
particular, I'm new to GIS. After reviewing several sources it seems
that a good choice to star t is PostgreSQL.

I downloaded and installed successfuly the setup, on a PC desktop
running Windows Seven Home Premium.

Then came Stack Builder 4.1.0's turn. When instructed to select the
installation I am installing software I select "PostgreSQL 9.5 (x64)
on port 5432"

The problem is that I keep getting the following error mesage:
----------------------------------------------------------------------------------------------------
A certificate verification problem was encountered whilst accessing
https//www.postgresql.org/applications-v2.xml
schcannel: next InitializeSecurityContext failed:
SEC_E_UNTRUSTED_ROOT (0x80090325) - The certificate chain was
issued by an authority that is not trusted.
This means that the source of the download cannot be verified. it is
recommended that you do not continue with the download as it may
be coming from a site that is preending to be the intended download
site and may contain viruses or malware.

Do you wish to continue?
---------------------------------------------------------------------------------------------------
I intend to continue, but there again I keep getting the following
error message:
----------------------------------------------------------------------------------------------------
Couldn't access the URL
'https://www.postgresql.org/applications-v2.xml'.

ERROR: schannel: next InitializeSecurityContext failed:
SEC_E_UNTRUSTED_ROOT (0x80090325) - The certificate chain was
issued by an authority that is not trusted.
---------------------------------------------------------------------------------------------------
I should be most grateful if any of you would provide me with any advice.

Best regards.
Pablo Liendo
Caracas

---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus

Responses

Browse pgsql-general by date

Re: BUG #6427: Installation stack builder error

Hi,
On Feb 1, 2012, at 10:35 PM, download_mn(at)hotmail(dot)com wrote:

> The following bug has been logged on the website:
>
> Bug reference: 6427
> Logged by: MN
> Email address: download_mn(at)hotmail(dot)com
> PostgreSQL version: 9.1.2
> Operating system: Windows 2008 server R2 SP1
> Description:
>
> With a fresh new installation of Windows 2008 server R2 SP1, I install
> PostgreSQL 9.1.2. When the Stack builder 3.1.0 ask me wath I want to
> install, I sellect a lot of options to try.
>
> But some error append on installation process:
> - java not already install (I correct it);
If a component requires java, it gives such an error, You can install java and retry to install that component.
> - SSL not install (I make it further);
Which component?
> - No PostgreSQL 9.0 install ?? (but 9.1.2 is installed);
I believe you are trying to install Postgres Enterprise Manager Server, which currently supports only PostgreSQL 9.0 and hence is required (though the installer will set it up for you if you continue with the installation)
> - do not able to reach get.enterpriseDB.com/.../...;
Are you behind a proxy server?
> - one error I don't remember;
> - The email and/or password are not valid. (but is working on the web site
> and for other options);
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.

In response to

Browse pgsql-bugs by date

Installing software needed to work from home in CSE 444

Summary

These notes will walk you through installing the programs you need to work from home in CSE 444:

  • Java
  • PostgreSQL
  • JDBC drivers (Java database connection libraries) for:

We assume here that you're using Windows. If you're using Mac OS X or Linux, please help us out by contributing notes for your OS.

Please remember that we only support CSE Instructional Lab-supported computers. If you are having trouble getting your assignment running at home, please try running it on a Lab machine.

General notes

  • You will need to access both a local PostgreSQL install and SQL Server on IISQLSRV for project 2. Please see how to tunnel SQL Server using SSH.
  • Make sure to download the CSE 444 shell launcher script. Note that you may need to modify the hard-coded paths in the script to use it on a non-Lab machine.
  • You must be running as an Administrator to perform many of the tasks described here. In Vista you may need to choose the "Run as Administrator" option (right-click the program or shortcut, "Run as Adminstrator").
  • If you're running a 64-bit version of Windows, you need to change to in the Installing PostgreSQL and Adapting the PostgreSQL instructions sections.

Installing Java

Download and install the Java SDK 6, update 13 from Sun. This version of the Java SDK is consistent with the version currently on the Lab machines.

Installing PostgreSQL and its JDBC driver

Follow these steps:

  1. Download PostgreSQL 8.3.7 for Windows.
  2. Install it with the default options. The installer should prompt you to create two different passwords, but you only need to fill in the one for the "database superuser"; the installer will auto-generate a value for the other password (the "service password") if you don't supply one. Remember the password you entered; you'll need it later.
  3. Now you need to install the JDBC driver. To do so, start by running the Stack Builder program, either by accepting the default options for tasks after install, or from Start->Programs->PostgreSQL 8.3->Application Stack Builder.
  4. Select "PostgreSQL Database Server 8.3 on port 5432", then choose Next.
  5. Open the "Database Drivers" category, check the box for "psqlJDBC 8.3.604", then choose Next.
  6. Choose any mirror, then choose Next.
  7. Choose Next at the confirmation window.
  8. Wait until you see "All the installation files have now been successfully downloaded", then choose Next.
  9. Choose Finish when done.
  10. Verify that the files and exist.

Installing the JDBC driver for SQL Server

Follow these steps:

  1. Download the JDBC driver from Microsoft. You'll end up "downloading" the license agreement; scroll to the bottom, then choose Accept to download the actual file. (The two "Accept" links point to different archives storing the same data; the "Windows version" is a self-extracting EXE, while the "UNIX version" is a gzipped tarball (.tar.gz file).)
  2. Unpack the archive to
  3. Verify that the file exists.

Adapting the PostgreSQL instructions

With two major exceptions, the PostgreSQL instructions for Lab machines still apply to working from home.

The first exception is that you can completely skip the sections titled "Creating a data folder" and "Starting and stopping PostgreSQL". The installer already created a data folder, so you don't need to create one yourself, and it set up PostgreSQL to start and shut down along with the computer, so you don't need to start it explicitly.

The second exception is the way you log in to the database system. On Lab machines (when following the suggested procedure for creating a data folder), you are not normally asked for a username or password when connecting to the database. This is because your PostgreSQL username is the same as your Windows username (the default username for PostgreSQL client tools and libraries), and PostgreSQL automatically trusts all connections from the local computer, so any local user can connect using any PostgreSQL username without providing a password.

By default, however, PostgreSQL installed using the Windows installer will prompt you for a username and password; you will need to use for the username and the "database superuser password" you previously set for the password. There are two ways to work around this problem:

  • Shut down the PostgreSQL service (), then run it manually using a data folder created with , as you would do on a Lab computer.
  • Modify the data folder created during the PostgreSQL installation to get the same authentication behavior as one created with plain . This is a two-step process:
    1. Allow locally connected users to connect without a password:
      1. Open the pg_hba.conf file in the data folder, typically located at .
      2. Modify the last lines of this file, which read: # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 by changing "md5" to "trust", so they read: # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
      3. Save and close the file. (If this fails, you may need to re-open the file as an Administrator, and try again.)
      4. Tell PostgreSQL to reread its configuration files: Start->Programs->PostgreSQL 8.3->Reload configuration
    2. Create a PostgreSQL user with the same name as your Windows username:
      1. Open a PostgreSQL shell.
      2. Make sure PostgreSQL is running: > net start pgsql-8.3
      3. Run the following command: > createuser -U postgres -s "%USERNAME%" This command creates a PostgreSQL user with administrative privileges (), and the same name as your Windows username (value of the environment variable ), using the authority of the existing database superuser ().

0 Comments

Leave a Comment