CentOS6 and PostgreSQL-YUM, (Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg90. Please verify its path and try again)

centoscentos6postgresqlyum

I'm using CentOS 6. I need to configure my YUM to have access to the PostgreSQL repository, but I'm getting an error.

I've followed this guide: http://www.postgresonline.com/journal/index.php?/archives/45-An-Almost-Idiots-Guide-to-PostgreSQL-YUM.html

When I do:

yum install postgresql

I got this error:

[root@andre yum.repos.d]# yum install postgresql
Loaded plugins: fastestmirror, refresh-packagekit, rpm-warm-cache
Loading mirror speeds from cached hostfile
 * base: ftp.di.fc.ul.pt
 * extras: ftp.di.fc.ul.pt
 * updates: ftp.di.fc.ul.pt
http://yum.pgsqlrpms.org/9.0/redhat/rhel-6-x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404"
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg90. Please verify its path and try again

Someone have any clue on what I should do to correct this?

Best Regards,

Best Answer

http://yum.pgsqlrpms.org/ is not used anymore, they have relocated to pgrpms.org, this is causing your errors.

Revert your changes, then check http://yum.pgrpms.org/howtoyum.php, this page will tell you to install the CentOS 6 repository RPM from here.