Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggvmr-0002WA-CK for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 18:07:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggvmo-0008J3-UI for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 18:07:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggvmo-0008Dd-8l for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 18:07:34 +0000 Received: from sonic305-3.consmr.mail.bf2.yahoo.com ([74.6.133.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggvmk-0008Qq-HB for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 18:07:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1546970848; bh=3kzliXnNsIJci0O8y7IIAjLUDqgPMzFhBPiC1bbcTOM=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=af/Gk5zmlJq8j0XuGbF4DzbwBi8sqh1tPBno41AE+lo62yNEsmTHtRuxrsTKk9JaTMUEGHUUDJgBBgjklVSdhbdY2xO75eoLkzBv+bxZ7/wom6PGpQCaxeF8pLTELmcNdMD2+mIrW41MzCRCCIw/PTUTfrgi4fNQYBZeXMw01hr1i9J5xDia1ckKHkUMeydoEHg+d7vmafqONllZWFyzFiHCevedIJB5gNG3/Vqab1mD3bKfqsDx4dqi3IddZV644b2AeDo3RNRC0z1jzbKBuiWA1rzpzMLKpvPM2w9do5FfY7zLrjHBBhniiKF8iOYKP9i8WAEFj2qh4ompxiFbOA== X-YMail-OSG: EXjlztYVM1k.0nTueRWxDcdmwuSWszDq8HDgxDODJIm4IQm1OOAwIhSEz3ke.hP x_XPwnQDeD7JrmEz4ThhDV.oZEBaRj_iM3ugunrWFbGsgVO3SJC.J4xTYgRf7nPL4VikRZ0BDCaN 3NF.fmqa7X3dChhEwiwP8mXHY0Ffn2obdMM8IlaQe83cr8FBUrl3NpL7iJ6.Kdchmg2at3E8KLrO JsZe8HdNCRKNGINzxna7oQGwB0WDuOs6vST8z_dmlfSnZ1.M1gMGm1v7.xV3y72FiSW6nOonzmJ1 0O5X7yqmSTB.n6JGbSuXvhmdxQBjAVD7XYwIL0zVB4ZxxsM3uri19A7TXfnBNSR2TMgsN37ztK5L rFr0oYyaF0hCog2Ep1P764T9u_OhDuGjnJ.SZfz6FNxhAyjPE2vbl8hEH251AA85ds.OcvvFthyc hjHBPCvIB2LVVjS2W_kjnQr5kvldG0p3lDjEIBp0uOCllxlD8FSQG4wdqsV9KeBYer5SZPAk.vdZ _.Wx0p_DRjdHt1wSSyQ6rfJawXgoSiwwMo7edTHSSUBDeit..64FCNTemGQ2KcKTmnkLs1rpA7pb TwQH7xhn4f7Xbk166xTplEVa6HH6Co0xM5lq6FkrGDMZnV7oPtE1Vc96WWNc_okn9rElAMsFrNtb KFAeWaf5TghbsLhUOUbRHPsnLL4h9GuEre0apqZIK5y1eKmkiB9gnmINopUVvCOvdfZZchmCpyzr LDDkK2bv_w576UwJ35JBL1Q.Z4tXILPEBrh7jWO_saQd76ytwU0oqv._Vf.bDjz4xfYlCcdIbDb4 yl1oVjVJ4SuhgquhEpQQGRi4UbbBNSpPZN41Z73F4CWNWPuKrC1TQL1ZMV4.a4XyHzV2mmGQLEGf Ceff7_sF99d4ioM500J9_139Gr__TY0uoQI1YSIXlEZo_xcnmNmgQxOgqJ8Ny7L5LNHUtlsfyJNo vXAa.Wmy9Zuakfyfu7tmvSpmORW281tJ_UkjTYGlmNBHQnaabBQK7HXbafYNEIrbdz5rHXDKfx.Z NX.0oG_Jht9AHekeCkKNUHY30MJxSsMCUtX_8fedCEJ.7oKHDx8Goq5BW4TV6VItgUHs- Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.bf2.yahoo.com with HTTP; Tue, 8 Jan 2019 18:07:28 +0000 Date: Tue, 8 Jan 2019 18:07:25 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Kris Deugau , "pgsql-admin@lists.postgresql.org" Message-ID: <1417769599.15062732.1546970845229@mail.yahoo.com> In-Reply-To: References: <1631501735.1420767.1545138861194.ref@mail.yahoo.com> <1631501735.1420767.1545138861194@mail.yahoo.com> <413070647.1500395.1545146432141@mail.yahoo.com> <655950091.6682015.1545227950414@mail.yahoo.com> <1647331387.6706670.1545231013241@mail.yahoo.com> <1026281491.6868813.1545244876819@mail.yahoo.com> <16116df4-3ae8-688b-5794-440e47d61ba1@vianet.ca> <404624400.7401294.1545328383827@mail.yahoo.com> Subject: Re: install Postgres on RHED 7 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15062731_1651908731.1546970845226" X-Mailer: WebService/1.1.12857 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 13815 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_15062731_1651908731.1546970845226 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable finally the SA installed the OS libraries and I installed the server packag= es successful but not postgres11-contrib.#yum install postgresql11-server p= ostgresql11-contrib=C2=A0 --> I see no package postgresql11-contrib availab= eDependencies resolvedTransaction test succeededrunning transaction=C2=A0in= stalling: libicu-50.1.2.17.el7.x86_64=C2=A0 =C2=A01/2Installing: postgresql= 11-11.1-1PGDG.rhel7.x86_64=C2=A0 =C2=A02/3failed to link /usr/bin/psql -> /= etc/alternative/pgsql-psql: /usr/bin/pgql exists and it's not a a symlinkfa= iled to link /usr/bin/clusterdb -> /etc/alternatives/pgsql-clusterdb: /usr/= bin/clusterdb exist and itis not a symlink failed to link /usr/bin/createdb -> /etc/alternatives/pgsql-createdb: /usr/= bin/createdb=C2=A0exist and it is not a symlinkfailed to link /usr/bin/crea= teuser -> /etc/alternatives/pgsql-createuser: /usr/bin/createuse=C2=A0exist= and it is not a symlink failed to link /usr/bin/dropdb -> /etc/alternatives/pgsql-dropdb: /usr/bin/= dropdb exist and it is not a symlinkfailed to link /usr/bin/dropuser -> /et= c/alternatives/pgsql-dropuser: /usr/bin/dropuser exist and it is not a syml= inkfailed to link /usr/bin/pg_basebackup -> /etc/alternatives/pgsql-pg_base= backup: /usr/bin/pg_basebackup exist and itis not a symlinkfailed to link /= usr/bin/pg_dump -> /etc/alternatives/pgsql-pg_dump: /usr/bin/pg_dump exist = and it is not a symlinkfailed to link /usr/bin/pg_dumpall -> /etc/alternati= ves/pgsql-pgdumpall: /usr/bin/pg_dumpall exist and it is not a symlinkfaile= d to link /usr/bin/pg_dumpall -> /etc/alternatives/pgsql-pgdumpall: /usr/bi= n/pg_dumpall exist and it is not a symlink After the server successful install, I initialize the database an/usr/pgsql= -11/bin/postgresql-11-setup initdb=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Thursday, December 20, 2018 4:17 PM, Kris Deugau = wrote: =20 Pepe TD Vo wrote: > May you suggest me exactly repositories packages needed for install=20 > PostgreSQL?=C2=A0 Seem to me this link,=20 > https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/ = =20 > all rpm files needed another dependencies.=C2=A0 Total more than 300 file= s=20 > and only a few allow me to install the rest of them needed another=20 > dependencies and didn't give me exactly what they are. Some of them will be from the stock Red Hat repositories, and some will=20 be from the PGDG repository.=C2=A0 I haven't used that repository, and I=20 haven't done much on an RPM-based system for a while so I can't give you=20 any more specific information. It's possible - but very tedious and difficult - to install a package=20 with a large dependency tree entirely by hand.=C2=A0 I *have* done this=20 myself in the past, and I recall a few cases where it literally took two=20 or three hours to get everything installed to support the specific=20 package I started out trying to install.=C2=A0 This is why tools like yum= =20 were developed;=C2=A0 they do the work of checking through the list to see= =20 what's required, and where it can be installed from. This isn't specific to Postgres;=C2=A0 it's how the underlying OS package= =20 system works.=C2=A0 You may want to see if someone in your office has more= =20 experience installing packages on RHEL with yum and ask them to give you=20 a hand.=C2=A0 You've got several issues around yum's basic operation that y= ou=20 need to fix, and local network/systems admins should know enough about=20 your setup to help a lot faster. -kgd =20 ------=_Part_15062731_1651908731.1546970845226 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
finally the SA installed the OS libraries and I inst= alled the server packages successful but not postgres11-contrib.
#yum install postgresql11-serve= r postgresql11-contrib  --> I see no package postgresql11-contrib a= vailabe
Dependencies resolved
Transaction test succeeded
running transaction 
=
installing: = libicu-50.1.2.17.el7.x86_64   1/2
Installing: postgresql11-11.1-1PGDG.rh= el7.x86_64   2/3
failed to link /usr/bin/psql -> /etc/alternative/pgs= ql-psql: /usr/bin/pgql exists and it's not a a symlink
failed to link /usr/bin/clu= sterdb -> /etc/alternatives/pgsql-clusterdb: /usr/bin/clusterdb exist an= d itis not a symlink

failed to link /usr/bin/createdb -> /etc/alternatives/pgsql-= createdb: /usr/bin/createdb exist and it is not a symlink
failed to link /usr= /bin/createuser -> /etc/alternatives/pgsql-createuser: /usr/bin/createus= e exist and it is not a symlink
failed to link= /usr/bin/dropdb -> /etc/alternatives/pgsql-dropdb: /usr/bin/dropdb exis= t and it is not a symlink
failed to link /u= sr/bin/dropuser -> /etc/alternatives/pgsql-dropuser: /usr/bin/dropuser e= xist and it is not a symlink
failed to link= /usr/bin/pg_basebackup -> /etc/alternatives/pgsql-pg_basebackup: /usr/b= in/pg_basebackup exist and itis not a symlink
failed to link /usr/bin/pg_dump -> /etc/alternatives/pgsql-pg_dump: /= usr/bin/pg_dump exist and it is not a symlink
failed to link /usr/bin/pg_dumpall -> /etc/alternatives/pgsql-pgdumpa= ll: /usr/bin/pg_dumpall exist and it is not a symlink
failed to link /usr/bin/pg_dumpall -> /etc/altern= atives/pgsql-pgdumpall: /usr/bin/pg_dumpall exist and it is not a symlink


<= /div>
<= span>
After the server successful install, I initialize the database an=
/usr/p= gsql-11/bin/postgresql-11-setup initdb
 
= <= /font>
Bach-Nga

No one in this world = is pure and perfect.  If you avoid people for their mistakes you will = be alone. So judge less, love and forgive more.
<= div id=3D"yui_3_13_0_rc_1_1_1381789421038_7874" class=3D"yiv3811552299ms__i= d13893">To call him a dog hardly seems to do him justice though in as much as he h= ad four legs, a tail, and barked, I admit he was, to all outward appearance= s. But to those who knew him well, he was a perfect gentleman (Hermione Gin= gold)

**Live simply *= *Love generously **Care deeply **Speak kindly.
*** Genuinely= rich *** Faithful talent *** Sharing success


On Thursday, December 20, 20= 18 4:17 PM, Kris Deugau <kdeugau@vianet.ca> wrote:
=

Pepe TD Vo wrote:<= br clear=3D"none">> May you suggest me exactly repositories packages nee= ded for install
> PostgreSQL?  Seem to me this l= ink,
> https= ://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/
> all rpm files needed another dependencies.  Total = more than 300 files
> and only a few allow me to inst= all the rest of them needed another
> dependencies an= d didn't give me exactly what they are.

Some of them will be from the stock Red Hat repositories, and some will <= br clear=3D"none">be from the PGDG repository.  I haven't used that re= pository, and I
haven't done much on an RPM-based system= for a while so I can't give you
any more specific infor= mation.

It's possible - but very tedio= us and difficult - to install a package
with a large dep= endency tree entirely by hand.  I *have* done this
= myself in the past, and I recall a few cases where it literally took two or three hours to get everything installed to support the = specific
package I started out trying to install.  = This is why tools like yum
were developed;  they do= the work of checking through the list to see
what's req= uired, and where it can be installed from.

This isn't specific to Postgres;  it's how the underlying OS pack= age
system works.  You may want to see if someone i= n your office has more
experience installing packages on= RHEL with yum and ask them to give you
a hand.  Yo= u've got several issues around yum's basic operation that you
need to fix, and local network/systems admins should know enough abou= t
your setup to help a lot faster.


-kgd



------=_Part_15062731_1651908731.1546970845226--