Re: POSTGRESQL 10 Media download with CHECKSUM VALUE

On 20 January 2018 at 09:54, Umair Shahid <umair(dot)shahid(at)2ndquadrant(dot)com>
wrote:

> Haroon, please see below ...
>
> On Fri, Jan 19, 2018 at 3:39 PM, Mohammad Ali Raza (via Accelo) <
> mohammad(dot)raza(at)telenor(dot)com(dot)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(at)postgresql(dot)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
>> <http://click.accelo.com/wf/click?upn=5deYF4nRqwWI2BVO4mbtGT9301CefCX3EW49qthzEIQ-3D_OjycfVhcsAKChx8sjQzmyHbY-2FUz84i3RYU7fXQmPBUfAG6-2BcmtQPyoy9epRqiPDVfyDUcAo4-2B5xdtA7p2aQNp2Ldp9gj8bcDs-2Bc5ayuoEMsb7ey4CH3YU4-2Baz1TeDRGxGFAFj8mBY-2FWB-2BfF-2B2Ym18XKi0ejuOO2361EkA0OzSG0yRJ34HviSfE0vGDABmDkR1emvhjfEPSDtPYWXvYN0kEkr47TKQ7PGv3pUUd9vxBnF4B93FKt2PK8xFJ-2F-2BJr7IwTQtJRDS4v2F5MU4tiJ41iqikKR814eArrWobRasXdaQrBQcELJ8O2yf8UPl-2BG8T>
>> 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(at)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 <https://www.pglivecd.org> 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/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services