Обсуждение: POSTGRESQL 10 Media download with CHECKSUM VALUE

Поиск
Список
Период
Сортировка

POSTGRESQL 10 Media download with CHECKSUM VALUE

От
"Saeed Ahmed (DB)"
Дата:

Dear Team,

 

I want to download media from www.postgresql.org with the checksum value. Is there any way to get the checksum value of the zip or installer file.

 

Secondly I want to confirm if there is any way I download the media ISO image file from the Postgresql.org site.

 

Thanks

 

Regards,

 

Saeed Ahmed

 

RE: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
Mohammad Ali Raza
Дата:

Hi Team,

 

Checksum means MD5 checksum.

 

Regards

Ali

From: Saeed Ahmed (DB)
Sent: Friday, January 19, 2018 3:17 PM
To: pgsql-admin@postgresql.org
Cc: Adnan Hamd Us Salam; Mohammad Ali Raza
Subject: POSTGRESQL 10 Media download with CHECKSUM VALUE

 

Dear Team,

 

I want to download media from www.postgresql.org with the checksum value. Is there any way to get the checksum value of the zip or installer file.

 

Secondly I want to confirm if there is any way I download the media ISO image file from the Postgresql.org site.

 

Thanks

 

Regards,

 

Saeed Ahmed

 

Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
Umair Shahid
Дата:
Haroon, please see below ...

On Fri, Jan 19, 2018 at 3:39 PM, Mohammad Ali Raza (via Accelo) <mohammad.raza@telenor.com.pk> wrote:

Hi Team,

 

Checksum means MD5 checksum.

 

Regards

Ali

From: Saeed Ahmed (DB)
Sent: Friday, January 19, 2018 3:17 PM
To: pgsql-admin@postgresql.org
Cc: Adnan Hamd Us Salam; Mohammad Ali Raza
Subject: POSTGRESQL 10 Media download with CHECKSUM VALUE

 

Dear Team,

 

I want to download media from www.postgresql.org with the checksum value. Is there any way to get the checksum value of the zip or installer file.

 

Secondly I want to confirm if there is any way I download the media ISO image file from the Postgresql.org site.

 

Thanks

 

Regards,

 

Saeed Ahmed

 




--
Umair Shahid
Head of Marketing & Products
2ndQuadrant - PostgreSQL Support & Services

Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
Haroon
Дата:
On 20 January 2018 at 09:54, Umair Shahid <umair.shahid@2ndquadrant.com> wrote:
Haroon, please see below ...

On Fri, Jan 19, 2018 at 3:39 PM, Mohammad Ali Raza (via Accelo) <mohammad.raza@telenor.com.pk> wrote:

Hi Team,

 

Checksum means MD5 checksum.

 

Regards

Ali

From: Saeed Ahmed (DB)
Sent: Friday, January 19, 2018 3:17 PM
To: pgsql-admin@postgresql.org
Cc: Adnan Hamd Us Salam; Mohammad Ali Raza
Subject: POSTGRESQL 10 Media download with CHECKSUM VALUE

 

Dear Team,

 

I want to download media from www.postgresql.org with the checksum value. Is there any way to get the checksum value of the zip or installer file.

 

Secondly I want to confirm if there is any way I download the media ISO image file from the Postgresql.org site.

 

Thanks

 

Regards,

 

Saeed Ahmed

 


Thank you Umair for looping me in!

> Is there any way to get the checksum value of the zip or installer file.
Checksum is MD5 checksum. Under *nix environments, you can get checksum by using md5sum ( md5 on Mac) utility e.g.

[root@localhost repo]# md5sum 2cd836c0.gz
234d2551189e5999cae3fa2bff533e60  2cd836c0.gz

> Secondly I want to confirm if there is any way I download the media ISO image file from the Postgresql.org site.


So there is this PostgreSQL LiveCD project that gives you an ISO image which essentially is a live cd. It is Fedora based and contains packages from the PostgreSQL Yum repository. It is a bootable image that lets you run PostgreSQL and a few other related tools without installing anything on your machine. Looking at its repository, it is currently available up until PostgreSQL 9.6 only.

Can you please elaborate a bit on what you are trying to achieve by using an ISO image?

If you plan to use ISO image as an offline medium of installation and/or as a local offline store of PGDG package repository, you can achieve that by using following approach:

1. Use reposync to get a copy of packages from Yum repository. You can do this by installing repo RPM first for your target platform on any machine that has internet access. So for example, if you are running RHEL/CentOS 7:
     a) Setup pgdg10 RHEL/CentOS 7 yum repository for PostgreSQL 10
          yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
     b) Use reposync to sync everything from target repository to your local directory
            reposync --gpgcheck -l --repoid=pgdg10 --download_path=<path to a local directory> --downloadcomps --download-metadata
2. Once you have a local copy of the Yum repository, you can use that as an offline mirror for servers on your local network. You can copy it around on your network and/or burn it on some optical/offline storage. If you plan to point yum to this offline repo, be sure to run createrepo on it.

These steps assume your target platform is RHEL/CentOS. You can follow similar approach for Debian environments too by making platform specific adjustments to the commands above.

Regards, 
 
--
Haroon                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

RE: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
Mohammad Ali Raza
Дата:

Hi Haroon,

 

Thanks for the response.

Software vendors publish MD5 hash values for software. We need hash value for Postgres 10 database software and will verify this value by command shared in below email PFB inline response

 

Regards

Ali

 

> Is there any way to get the checksum value of the zip or installer file.
Checksum is MD5 checksum. Under *nix environments, you can get checksum by using md5sum ( md5 on Mac) utility e.g.


[root@localhost repo]# md5sum 2cd836c0.gz
234d2551189e5999cae3fa2bff533e60  2cd836c0.gz

 

> Secondly I want to confirm if there is any way I download the media ISO image file from the Postgresql.org site.

 

So there is this PostgreSQL LiveCD project that gives you an ISO image which essentially is a live cd. It is Fedora based and contains packages from the PostgreSQL Yum repository. It is a bootable image that lets you run PostgreSQL and a few other related tools without installing anything on your machine. Looking at its repository, it is currently available up until PostgreSQL 9.6 only.

 

Can you please elaborate a bit on what you are trying to achieve by using an ISO image?

 

If you plan to use ISO image as an offline medium of installation and/or as a local offline store of PGDG package repository, you can achieve that by using following approach:

 

1. Use reposync to get a copy of packages from Yum repository. You can do this by installing repo RPM first for your target platform on any machine that has internet access. So for example, if you are running RHEL/CentOS 7:

     a) Setup pgdg10 RHEL/CentOS 7 yum repository for PostgreSQL 10

     b) Use reposync to sync everything from target repository to your local directory

            reposync --gpgcheck -l --repoid=pgdg10 --download_path=<path to a local directory> --downloadcomps --download-metadata

2. Once you have a local copy of the Yum repository, you can use that as an offline mirror for servers on your local network. You can copy it around on your network and/or burn it on some optical/offline storage. If you plan to point yum to this offline repo, be sure to run createrepo on it.

 

These steps assume your target platform is RHEL/CentOS. You can follow similar approach for Debian environments too by making platform specific adjustments to the commands above.

 

Regards, 

 

--

Haroon                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

 

This e-mail has been scanned for viruses by Forefront Protection @ Telenor Pakistan.

Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
Magnus Hagander
Дата:


On Mon, Jan 22, 2018 at 9:55 AM, Mohammad Ali Raza <mohammad.raza@telenor.com.pk> wrote:

Hi Haroon,

 

Thanks for the response.

Software vendors publish MD5 hash values for software. We need hash value for Postgres 10 database software and will verify this value by command shared in below email PFB inline response

 


Hello!

The PostgreSQL source tarfiles come with associated MD5 and SHA256 checksums. See https://www.postgresql.org/ftp/source/v10.1/.

If you are talking about binaries, you'd have to check that which each individual binary provider. For example, the RPM and DEB binaries are all GPG signed, which is an even stronger signing.

--

RE: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
"Saeed Ahmed (DB)"
Дата:

Hi  Magnus Hagander,

 

Many thanks for the prompt response. We need a binary rpm for installation on linux RHEL7 environment and for that CHECKSUM is required. As the source tar file does not fulfill our requirement due to no expertise in compiling the source code. Is there any way as no success in finding the MD5 value for rpm on the website.

 

 

Regards,

 

Saeed Ahmed

 

 

 

From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Monday, January 22, 2018 2:28 PM
To: Mohammad Ali Raza
Cc: Haroon; Umair Shahid; Saeed Ahmed (DB); pgsql-admin@postgresql.org; Adnan Hamd Us Salam
Subject: Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

 

 

 

On Mon, Jan 22, 2018 at 9:55 AM, Mohammad Ali Raza <mohammad.raza@telenor.com.pk> wrote:

Hi Haroon,

 

Thanks for the response.

Software vendors publish MD5 hash values for software. We need hash value for Postgres 10 database software and will verify this value by command shared in below email PFB inline response

 

 

Hello!


The PostgreSQL source tarfiles come with associated MD5 and SHA256 checksums. See https://www.postgresql.org/ftp/source/v10.1/.

 

If you are talking about binaries, you'd have to check that which each individual binary provider. For example, the RPM and DEB binaries are all GPG signed, which is an even stronger signing.

 

--

 

This e-mail has been scanned for viruses by Forefront Protection @ Telenor Pakistan.

Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
Haroon
Дата:


On 24 January 2018 at 12:56, Saeed Ahmed (DB) <saeed.ahmed1@telenor.com.pk> wrote:

Hi  Magnus Hagander,

 

Many thanks for the prompt response. We need a binary rpm for installation on linux RHEL7 environment and for that CHECKSUM is required. As the source tar file does not fulfill our requirement due to no expertise in compiling the source code. Is there any way as no success in finding the MD5 value for rpm on the website.


Package installation via Yum should automatically take care of verifying checksum and GPG signature (unless you manually disable PGP verification).

Yum repository where packages are hosted stores checksum and other relevant information in what is called yum db. So for example, for RHEL/CentOS 7.2, here's the Yum repository that contains relevant information on all the packages. 

(Please refer to the relevant files for your minor version of RHEL/CentOS)



So for example, if you wanted to get checksum for postgresql10-server rpm package, here's this excerpt from the file linked above for postgresql10-server version 10.1 rpm package:

<package type="rpm">

  <name>postgresql10-server</name>

  <arch>x86_64</arch>

  <version epoch="0" ver="10.1" rel="1PGDG.rhel7"/>

  <checksum type="sha256" pkgid="YES">d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910</checksum>

  <summary>The programs needed to create and run a PostgreSQL server</summary>


The highlighted entry above should give you the sha256 checksum of the package in question.

Once you have installed the same package via Yum, you can verify this checksum against the installed package by running a query against yumdb. Essentially:

yumdb info <package name>

lists out the required information. For example, for postrgesql10-server package, here's the output:

[haroon@localhost ~]$ yumdb info postgresql10-server
Loaded plugins: fastestmirror, langpacks
postgresql10-server-10.1-1PGDG.rhel7.x86_64
     checksum_data = d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910
     checksum_type = sha256
     command_line = install postgresql10-server
     from_repo = pgdg10
     from_repo_revision = 1516304771
     from_repo_timestamp = 1516304876
     installed_by = 1000
     reason = user
     releasever = 7
     var_infra = stock
     var_uuid = 3b612142-4be3-4551-b529-66391cfe3a9d

Regards,
Haroon

RE: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
"Saeed Ahmed (DB)"
Дата:

Dear Haroon,

 

Really appreciate your prompt reply. There are some limitation due to company policy we are not having internet connection on the host to use the yum repository. The only option we have to manually copy the rpm to the host machine. So we cannot avail the Yum repository facility. If I download the file directly from the link mention below. Doest the checksum_data value will work for this particular RPM.

 

 

https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/postgresql10-server-10.1-1PGDG.rhel7.x86_64.rpm

 

     checksum_data = d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910

     

Thanks.

 

Regards,

 

Saeed Ahmed

 

 

From: Haroon [mailto:muhammad.haroon@2ndquadrant.com]
Sent: Wednesday, January 24, 2018 2:05 PM
To: Saeed Ahmed (DB)
Cc: Magnus Hagander; Mohammad Ali Raza; Umair Shahid; pgsql-admin@postgresql.org; Adnan Hamd Us Salam
Subject: Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

 

 

 

On 24 January 2018 at 12:56, Saeed Ahmed (DB) <saeed.ahmed1@telenor.com.pk> wrote:

Hi  Magnus Hagander,

 

Many thanks for the prompt response. We need a binary rpm for installation on linux RHEL7 environment and for that CHECKSUM is required. As the source tar file does not fulfill our requirement due to no expertise in compiling the source code. Is there any way as no success in finding the MD5 value for rpm on the website.

 

Package installation via Yum should automatically take care of verifying checksum and GPG signature (unless you manually disable PGP verification).

 

Yum repository where packages are hosted stores checksum and other relevant information in what is called yum db. So for example, for RHEL/CentOS 7.2, here's the Yum repository that contains relevant information on all the packages. 

 

(Please refer to the relevant files for your minor version of RHEL/CentOS)

 

 

 

So for example, if you wanted to get checksum for postgresql10-server rpm package, here's this excerpt from the file linked above for postgresql10-server version 10.1 rpm package:

 

<package type="rpm">

  <name>postgresql10-server</name>

  <arch>x86_64</arch>

  <version epoch="0" ver="10.1" rel="1PGDG.rhel7"/>

  <checksum type="sha256" pkgid="YES">d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910</checksum>

  <summary>The programs needed to create and run a PostgreSQL server</summary>

 

 

The highlighted entry above should give you the sha256 checksum of the package in question.

 

Once you have installed the same package via Yum, you can verify this checksum against the installed package by running a query against yumdb. Essentially:

 

yumdb info <package name>

 

lists out the required information. For example, for postrgesql10-server package, here's the output:

 

[haroon@localhost ~]$ yumdb info postgresql10-server

Loaded plugins: fastestmirror, langpacks

postgresql10-server-10.1-1PGDG.rhel7.x86_64

     checksum_data = d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910

     checksum_type = sha256

     command_line = install postgresql10-server

     from_repo = pgdg10

     from_repo_revision = 1516304771

     from_repo_timestamp = 1516304876

     installed_by = 1000

     reason = user

     releasever = 7

     var_infra = stock

     var_uuid = 3b612142-4be3-4551-b529-66391cfe3a9d

 

Regards,

Haroon

 

This e-mail has been scanned for viruses by Forefront Protection @ Telenor Pakistan.

RE: POSTGRESQL 10 Media download with CHECKSUM VALUE

От
"Saeed Ahmed (DB)"
Дата:

Dear Haroon,

 

As we cannot proceed using rpm without checksum value and yum repository, what if i download Interactive installer by EnterpriseDB from the link given on https://www.postgresql.org website, If there is any way we can get the checksum for the file provided by https://www.enterprisedb.com/downloads/postgres-postgresql-downloads location. As I did not find any.

 

 

Regards,

 

Saeed Ahmed

 

 

 

From: Saeed Ahmed (DB)
Sent: Wednesday, January 24, 2018 2:52 PM
To: 'Haroon'
Cc: Magnus Hagander; Mohammad Ali Raza; Umair Shahid; pgsql-admin@postgresql.org; Adnan Hamd Us Salam
Subject: RE: POSTGRESQL 10 Media download with CHECKSUM VALUE

 

Dear Haroon,

 

Really appreciate your prompt reply. There are some limitation due to company policy we are not having internet connection on the host to use the yum repository. The only option we have to manually copy the rpm to the host machine. So we cannot avail the Yum repository facility. If I download the file directly from the link mention below. Doest the checksum_data value will work for this particular RPM.

 

 

https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/postgresql10-server-10.1-1PGDG.rhel7.x86_64.rpm

 

     checksum_data = d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910

     

Thanks.

 

Regards,

 

Saeed Ahmed

 

 

From: Haroon [mailto:muhammad.haroon@2ndquadrant.com]
Sent: Wednesday, January 24, 2018 2:05 PM
To: Saeed Ahmed (DB)
Cc: Magnus Hagander; Mohammad Ali Raza; Umair Shahid; pgsql-admin@postgresql.org; Adnan Hamd Us Salam
Subject: Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

 

 

 

On 24 January 2018 at 12:56, Saeed Ahmed (DB) <saeed.ahmed1@telenor.com.pk> wrote:

Hi  Magnus Hagander,

 

Many thanks for the prompt response. We need a binary rpm for installation on linux RHEL7 environment and for that CHECKSUM is required. As the source tar file does not fulfill our requirement due to no expertise in compiling the source code. Is there any way as no success in finding the MD5 value for rpm on the website.

 

Package installation via Yum should automatically take care of verifying checksum and GPG signature (unless you manually disable PGP verification).

 

Yum repository where packages are hosted stores checksum and other relevant information in what is called yum db. So for example, for RHEL/CentOS 7.2, here's the Yum repository that contains relevant information on all the packages. 

 

(Please refer to the relevant files for your minor version of RHEL/CentOS)

 

 

 

So for example, if you wanted to get checksum for postgresql10-server rpm package, here's this excerpt from the file linked above for postgresql10-server version 10.1 rpm package:

 

<package type="rpm">

  <name>postgresql10-server</name>

  <arch>x86_64</arch>

  <version epoch="0" ver="10.1" rel="1PGDG.rhel7"/>

  <checksum type="sha256" pkgid="YES">d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910</checksum>

  <summary>The programs needed to create and run a PostgreSQL server</summary>

 

 

The highlighted entry above should give you the sha256 checksum of the package in question.

 

Once you have installed the same package via Yum, you can verify this checksum against the installed package by running a query against yumdb. Essentially:

 

yumdb info <package name>

 

lists out the required information. For example, for postrgesql10-server package, here's the output:

 

[haroon@localhost ~]$ yumdb info postgresql10-server

Loaded plugins: fastestmirror, langpacks

postgresql10-server-10.1-1PGDG.rhel7.x86_64

     checksum_data = d669c07f3c670299f2f1adc5a81ec90187bffc9aca0e8ceb7aa51a9194614910

     checksum_type = sha256

     command_line = install postgresql10-server

     from_repo = pgdg10

     from_repo_revision = 1516304771

     from_repo_timestamp = 1516304876

     installed_by = 1000

     reason = user

     releasever = 7

     var_infra = stock

     var_uuid = 3b612142-4be3-4551-b529-66391cfe3a9d

 

Regards,

Haroon

 

This e-mail has been scanned for viruses by Forefront Protection @ Telenor Pakistan.