مشکل در نصب pgadmin در centos

[SaeedFazlollahzadeh]

سلام
روی لینک راست کلیک و کپی کنید. لینک رو از روی متن کپی کردید و طبیعتا خطای 404 داده.

https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

[NINJA]

نمام مشکلات سر این repository است

[root@IBSng ~]# wget   https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm                                                                                                              --2020-08-30 22:51:22--  https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Resolving download.postgresql.org... 147.75.85.69, 217.196.149.55, 72.32.157.246, ...
Connecting to download.postgresql.org|147.75.85.69|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6672 (6.5K) [application/x-redhat-package-manager]
Saving to: “pgdg-redhat-repo-latest.noarch.rpm”


100%[===================================================================================================================================================================================================>] 6,672       --.-K/s   in 0s


2020-08-30 22:51:22 (159 MB/s) - “pgdg-redhat-repo-latest.noarch.rpm” saved [6672/6672]


[root@IBSng ~]# rpm -Uvh pgdg-redhat-repo-latest.noarch.rpm
warning: pgdg-redhat-repo-latest.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing...                ########################################### [100%]
   1:pgdg-redhat-repo       ########################################### [100%]
[root@IBSng ~]# yum install pgadmin4
Loaded plugins: fastestmirror, priorities, replace
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.softaculous.com
 * extras: linux.darkpenguin.net
 * rpmforge: mirror1.hs-esslingen.de
 * updates: mirror.alpix.eu
 * webtatic: uk.repo.webtatic.com
Webmin                                                                                                                                                                                                                | 2.9 kB     00:00
base                                                                                                                                                                                                                  | 3.7 kB     00:00
extras                                                                                                                                                                                                                | 3.4 kB     00:00
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-6-x86_64/repodata/repomd.xml: [Errno 14] problem making ssl connection
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg-common. Please verify its path and try again

[hassanshaikhi]

نمام مشکلات سر این repository است

[root@IBSng ~]# wget   https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm                                                                                                              --2020-08-30 22:51:22--  https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Resolving download.postgresql.org... 147.75.85.69, 217.196.149.55, 72.32.157.246, ...
Connecting to download.postgresql.org|147.75.85.69|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6672 (6.5K) [application/x-redhat-package-manager]
Saving to: “pgdg-redhat-repo-latest.noarch.rpm”


100%[===================================================================================================================================================================================================>] 6,672       --.-K/s   in 0s


2020-08-30 22:51:22 (159 MB/s) - “pgdg-redhat-repo-latest.noarch.rpm” saved [6672/6672]


[root@IBSng ~]# rpm -Uvh pgdg-redhat-repo-latest.noarch.rpm
warning: pgdg-redhat-repo-latest.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing...                ########################################### [100%]
   1:pgdg-redhat-repo       ########################################### [100%]
[root@IBSng ~]# yum install pgadmin4
Loaded plugins: fastestmirror, priorities, replace
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.softaculous.com
 * extras: linux.darkpenguin.net
 * rpmforge: mirror1.hs-esslingen.de
 * updates: mirror.alpix.eu
 * webtatic: uk.repo.webtatic.com
Webmin                                                                                                                                                                                                                | 2.9 kB     00:00
base                                                                                                                                                                                                                  | 3.7 kB     00:00
extras                                                                                                                                                                                                                | 3.4 kB     00:00
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-6-x86_64/repodata/repomd.xml: [Errno 14] problem making ssl connection
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg-common. Please verify its path and try again

گویا مشکل توی ارتباط ssl هست احتمالا ارتباط با سرور tls1.2 باشه و توی سیستم عامل داره از tls1.0 یا tls1.1 استفاده میشه
نسخه centos چند هست؟ به آخرین نسخه آپدیتش کنید
این هم تست کنید

yum install ca-certificates openssl nss


الان چک کردم سرور postgresql فقط از tls1.2 پشتیبانی میکنه برای اینکه بتونید بهش وصل بشید باید آپدیت کنید چون tls1.0 1.1 قدیمی شده

Starting Nmap 6.40 ( http://nmap.org ) at 2020-08-30 23:41 +0430
Nmap scan report for download.postgresql.org (147.75.85.69)
Host is up (0.0067s latency).
Other addresses for download.postgresql.org (not scanned): 217.196.149.55 72.32.157.246 87.238.57.227
rDNS record for 147.75.85.69: fendaus.postgresql.org
PORT    STATE SERVICE
443/tcp open  https
| ssl-enum-ciphers:
|   SSLv3: No supported ciphers found
|   TLSv1.2:
|     ciphers:
|       TLS_DHE_RSA_WITH_AES_128_CBC_SHA - strong
|       TLS_DHE_RSA_WITH_AES_128_CBC_SHA256 - strong
|       TLS_DHE_RSA_WITH_AES_128_GCM_SHA256 - strong
|       TLS_DHE_RSA_WITH_AES_256_CBC_SHA - strong
|       TLS_DHE_RSA_WITH_AES_256_CBC_SHA256 - strong
|       TLS_DHE_RSA_WITH_AES_256_GCM_SHA384 - strong
|       TLS_RSA_WITH_AES_128_CBC_SHA - strong
|       TLS_RSA_WITH_AES_128_CBC_SHA256 - strong
|       TLS_RSA_WITH_AES_128_GCM_SHA256 - strong
|       TLS_RSA_WITH_AES_256_CBC_SHA - strong
|       TLS_RSA_WITH_AES_256_CBC_SHA256 - strong
|       TLS_RSA_WITH_AES_256_GCM_SHA384 - strong
|     compressors:
|       NULL
|_  least strength: strong


Nmap done: 1 IP address (1 host up) scanned in 1.15 seconds