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

[hassanshaikhi]

[root@IBSng ~]# ping ftp.postgresql.org
PING ftp.mirrors.postgresql.org (147.75.85.69) 56(84) bytes of data.
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=1 ttl=55 time=11.3                                                                                                         ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=2 ttl=55 time=11.2                                                                                                         ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=3 ttl=55 time=11.2                                                                                                         ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=4 ttl=55 time=11.2                                                                                                         ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=5 ttl=55 time=11.4 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=6 ttl=55 time=11.1 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=7 ttl=55 time=11.2 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=8 ttl=55 time=11.2 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=9 ttl=55 time=11.3 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=10 ttl=55 time=11.3 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=11 ttl=55 time=11.5 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=12 ttl=55 time=11.2 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=13 ttl=55 time=11.2 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=14 ttl=55 time=11.2 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=15 ttl=55 time=11.2 ms
64 bytes from fendaus.postgresql.org (147.75.85.69): icmp_seq=16 ttl=55 time=11.3 ms

[root@IBSng ~]# ping as250.net
PING as250.net (194.150.168.160) 56(84) bytes of data.
64 bytes from as250.net (194.150.168.160): icmp_seq=1 ttl=56 time=15.7 ms
64 bytes from as250.net (194.150.168.160): icmp_seq=2 ttl=56 time=15.8 ms
64 bytes from as250.net (194.150.168.160): icmp_seq=3 ttl=56 time=15.7 ms
64 bytes from as250.net (194.150.168.160): icmp_seq=4 ttl=56 time=15.8 ms
64 bytes from as250.net (194.150.168.160): icmp_seq=5 ttl=56 time=15.9 ms
64 bytes from as250.net (194.150.168.160): icmp_seq=6 ttl=56 time=15.8 ms
64 bytes from as250.net (194.150.168.160): icmp_seq=7 ttl=56 time=15.7 ms
64 bytes from as250.net (194.150.168.160): icmp_seq=8 ttl=56 time=15.8 ms

[root@IBSng ~]# wget https://download.postgresql.org/pub/...est.noarch.rpm
--2020-08-30 15:34:32--  https://download.postgresql.org/pub/...est.noarch.rpm
Resolving download.postgresql.org... 87.238.57.227, 147.75.85.69, 72.32.157.246, ...
Connecting to download.postgresql.org|87.238.57.227|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2020-08-30 15:34:33 ERROR 404: Not Found.

پس مشکلتون از dns نیست ولی عجیبه توی عکس های پست اول ریزالو نتونسته کنه

همونطور که دوستان گفتند آدرس رو کامل وارد کنید

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

اگه بدون مشکل دانلود شد بعدش اینو بزنید

rpm -Uvh pgdg-redhat-repo-latest.noarch.rpm


و اخر

yum install pgadmin4

[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