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 1ggwBk-00040Q-PA for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 18:33:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggwBi-000662-FV for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 18:33:18 +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 1ggwBh-00065v-Rh for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 18:33:18 +0000 Received: from sonic304-11.consmr.mail.bf2.yahoo.com ([74.6.128.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggwBZ-0000Xk-NU for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 18:33:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1546972388; bh=IP8/rfJjwOkZDwF03J22sBWiNH+xjeZJgowoT7dTxSo=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=BaNIEjWHgrOYE94vgvLQBdg8erDi7lyxmGRxW8yRAY7A1RAtUwnP69F0FIkzL7mcq2xen8gR/1rsWwRPInW4VAk/amTs+h6jVTSqGR1SUn/bAGEshJc2Nk8toJoF+7WY2yzsbaya9R8E93KZkJdPxUFC3/7/jOgRiDp61EwBZTJ2AVOsdBqqxALuhS+dcPZAb3tEk942VKL7dKJ3fC51CONiH+S1IMa/21JekCutUBpXMhG5tKGRgoFJKbUS+9ojQr++ihJDns+j0D5TZwb1cbs7qIGvCMROjlrFRbv7UpXLHD40t3r5dLNscSa4Y2oV783mkNjnh0kmPY5f+fDACw== X-YMail-OSG: VXLecOUVM1mHOzCqg7lsZnVG_0jzZWyerh_2Mj4ETePdeuM3x9eyF0PRkewjg.q iikZ_UsOO9TST4zHMv7jzZJSWEByf0I8_BSbM1SKIBwMm1c9jP2MbW5Z1Aji3TmSjfGRRPtYIXrH klcAe09zw5waK.5tWjUHGZwLNi1vxlB832CNcXxFubxwk_CuuQL.xter7GIfn0480WyDrJigajoZ vgu3vEyPYmVuYrxH5ADNN2_mykykRBAuOsXUPufAITvWFRjaT_H8kPqwYu2gdM_A1ps3sG1aMF6J 9uitnKiykSC13kSyf3SPbGnv2OaJQ52JWepxrhtbzuX8xM2EWrqS__CAkWbjpn1SAj1.zP28RO2Y t2p7flaNsv8hlTr6MnDl2l.OXj3emqUsBIyi7QyqP2UNhcWXeqrtEpEPjSrVHrSqZ2KNWNWhfFYR FXyYo3tUGCx11mKE19nNsEaNCQ3tjKOUKnOV9RieGkQNJ19aOkm6WSTpwHQVTqvmv18fnwStgPmF oygfyhDoluk.9V4bheYCPRYeTmoICmDe9oTOfIBo43l.0OoJR3mJ839H0FDX5JJ4dwPMrZ9QnTKJ ScLVCxdgL5kP2EWkLEjVZRFBgPHg32RJUuwZB4UhCC3kihsDdXOzjKNQZOqPv1mW6LJvTVQErVoZ pc.qxIUlt2jJrhFi.WjhkR70LtXx7kp0zqXeGtBZp2IhR6daW6D_bX1J68csWl6wjUXGtE.LjqEk xGOT830NmcADQcGIBwaw0rM0iHYg.QgSnyuQr2tkwlgWUluUeYMikhLx3tjTGAx7BkqDfSfuQeZy qU3mERpSErZVG4v8LgTurdyD_jWQ8eyeQXyxwF_vJXtuB9ZeFXOpSj.lfhfk6X8AX3W09XQb565o sUdKOruxZtv8tced9BFqHEN1gChnzBlXtbZC7Ac0Vs0b09lDx5EJ7N5g_qW.AgekNmDRyj3sVVYF OneZWhC7XMEqSecpDQc9XPljkHjHrVB3AEmtPRjo6TtSRm9O_wYq7McRFKFGgKHe7XB2KiVj771o ZnMFMb_U.ddlbMD.UfqSlxDFmSxLNTrEo_umkv5d8So2a3M9j6obPr5LCeACiafgAgh0f5Ec- Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.bf2.yahoo.com with HTTP; Tue, 8 Jan 2019 18:33:08 +0000 Date: Tue, 8 Jan 2019 18:32:59 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Kris Deugau , "pgsql-admin@lists.postgresql.org" Message-ID: <663674680.15076651.1546972379997@mail.yahoo.com> In-Reply-To: <1417769599.15062732.1546970845229@mail.yahoo.com> 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> <1417769599.15062732.1546970845229@mail.yahoo.com> Subject: Re: install Postgres on RHED 7 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15076650_1700698173.1546972379992" 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: 27860 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_15076650_1700698173.1546972379992 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable sorry, my fingers split before I can finish all typing: =20 finally the SA installed the OS libraries and I installed the server packa= ges successful but not postgres11-contrib.#yum install postgresql11-server = postgresql11-contrib=C2=A0 --> I see no package postgresql11-contrib availa= beDependencies resolvedTransaction test succeededrunning transaction=C2=A0i= nstalling: libicu-50.1.2.17.el7.x86_64=C2=A0 =C2=A01/2Installing: postgresq= l11-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 symlinkf= ailed 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-pg_dumpall: /usr/bin/pg_dumpall exist and it is not a symlinkfail= ed to link /usr/bin/pg_restore -> /etc/alternatives/pgsql-pg_restore: /usr/= bin/pg_restore exist and it is not a symlink failed to link /usr/bin/reindexdbl -> /etc/alternatives/pgsq-reindexdb: /us= r/bin/reindexdb exist and it is not a symlink failed to link /usr/bin/vacuumdb -> /etc/alternatives/pgsql-vacuumdb: /usr/= bin/vacuumdbexist and it is not a symlink installing:=C2=A0=C2=A0postgresql11-server-11.1-1PGDB.rhel7.x86_64=C2=A0=C2= =A0 1/3 Verifying:=C2=A0 postgresql11-11.1-1PGDB.rhel7.x86_64=C2=A0 =C2=A01/3Verify= ing: libicu-50.1.2-17.el7.x86_64=C2=A0 =C2=A02/3Verirying:=C2=A0 postgresql= 11-server-11.1-1PGDB.rhel7.x86_64=C2=A0 =C2=A03/3 Installed:postgresql11-server.x86_64 0:11.1-1PGDG.rhel7Dependency Installed= :libicu.x86_64 0:50.1.2-17.el7=C2=A0 =C2=A0postgres11.x86_64 0:11.1-1PGDG.r= hel 7 Completed! After the server successful install, I initialize the database an # /usr/pgsql-11/bin/postgresql-11-setup initdbInitializing database .....OK # systemctl enable postgres-11created symlink from /etc/systemd/system/mult= i-user.target.wants/postgresql-11.service to /usr/lib/systemd/system/postge= resql-11.service. # systemctl start postgresql-11# systemctl status postgresql-11postgresql-1= 1.service - PostgreSQL 11 database serverLoaded:loaded (/usr/lib/systemd/sy= stem/postgresql-11.service; enabled; vendor preset: disabled)Active: active= (running) since Tues 2019-01-08 12:02:05 EST; 12s agoand so on .... # service postgresql initdbhint: the perferred way to do this is now "postg= resql-set initdb"Initializing database ... OK but when I tried to correct the postgres.conf with the listen_addresses =3D= '*' and port=3D5432.=C2=A0 Restart the postgresql server I get an error. redirecting to /bin/systemctl start postgresql.service job for postgresql.service failed because the control proces exited with er= ror code.=C2=A0 See "systemctl status postgresql.service" and "jouralctl -x= e" for details. I run:=C2=A0#systemctl status postgresql.service -lpostgresql.service - Pos= tgreSQL database serverLoaded:loaded (/usr/lib/systemd/system/postgresql.se= rvice; diabled; vendor preset: disabled)Active: failed (result: exit-code) = since Tues 2019-01-08 12:34:43 EST; 2min 22s agoProcess: 6896 ExecStart=3D/= usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=3Dexis= ted, status=3D1/FAILUREProcess: 688 ExecStartPre=3D/usr/bin/postgresql-chec= k-db-dir ${PGDATA} (code=3Dexisted, status=3D0/SUCCESS)=C2=A0=C2=A0Jan 08 1= 2:34:42 hostname pg_ctl[6896]:HINT: Is another postmaster alreadying runnin= ...yJan 08 12:34:42 hostname pg_ctl[6896]:LOG: could not bing IPV6 socket:= Addressa ...seJan 08 12:34:42 hostname pg_ctl[6896]:HINT: Is another postm= aster alreadying runnin ...yJan 08 12:34:42 hostname pg_ctl[6896]:WARNING: = could not create any TCP/IP socketsJan 08 12:34:43 hostname pg_ctl[6896]:pg= _ctl: could nto start serverJan 08 12:34:43 hostname pg_ctl[1]: postgresql.= service: control process existed, c...=3D1 Jan 08 12:34:43 hostname pg_ctl[1]: Failed to start PostgreSQL database ser= ver. Jan 08 12:34:43 hostname pg_ctl[1]: Unit postgresql.service entered failed = state. Jan 08 12:34:43 hostname pg_ctl[1]: postgresql.service failed Hint: Some lines were ellipsized, use -l to show in full what I did wrong here?=C2=A0 Do I need to add listen_addresses =3D '*' and = port =3D 5432 on both /var/lib/pgsql/data/postgres.conf and /var/lib/pgsql/= 11/data/postgres.conf ? thank you for all your help. v/r, Bach-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 =20 ------=_Part_15076650_1700698173.1546972379992 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
sorry, my fingers split befor= e I can finish all typing:


=


finally the SA installed the OS libraries and I ins= talled the server packages successful but not postgres11-contrib.
#yum i= nstall postgresql11-server postgresql11-contrib  --> I see no packa= ge postgresql11-contrib availabe
Dependencies resolved
T= ransaction test succeeded
running transaction 
installing:= libicu-50.1.2.17.el7.x86_64   1/2
Installing: postgresql11= -11.1-1PGDG.rhel7.x86_64   2/3
failed to link /usr/bin/psql= -> /etc/alternative/pgsql-psql: /usr/bin/pgql exists and it's not a a s= ymlink
failed to link /usr/bin/clusterdb -> /etc/alternatives/pgsq= l-clusterdb: /usr/bin/clusterdb exist and 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-createuse= r: /usr/bin/createuse exist and it is not a symlink
=
failed to link /us= r/bin/dropdb -> /etc/alternatives/pgsql-dropdb: /usr/bin/dropdb exist an= d it is not a symlink
failed to link /usr/bin/dropuser -> /etc/alternatives/pgsql-dropuser: = /usr/bin/dropuser exist and it is not a symlink
failed to link /usr/bin/pg_basebackup -> /= etc/alternatives/pgsql-pg_basebackup: /usr/bin/pg_basebackup exist and itis= not a symlink
faile= d 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/alternative= s/pgsql-pg_dumpall: /usr/bin/pg_dumpall exist and it is not a symlink
=
failed to link /usr/bin/pg= _restore -> /etc/alternatives/pgsql-pg_restore: /usr/bin/pg_restore exis= t and it is not a symlink
failed to link /usr/bin/= reindexdbl -> /etc/alternatives/pgsq-reindexdb: /usr/bin/reindexdb exist= and it is not a symlink
failed to link /usr/bin/vacuumdb -> /e= tc/alternatives/pgsql-vacuumdb: /usr/bin/vacuumdbexist and it is not a syml= ink

installing:  postgresql11-server-11.1-1P= GDB.rhel7.x86_64   1/3

Verifying:  postgres= ql11-11.1-1PGDB.rhel7.x86_64   1/3
Verifying: libicu-50.1.2= -17.el7.x86_64   2/3
Verirying:  postgresql11-server-1= 1.1-1PGDB.rhel7.x86_64   3/3
<= div dir=3D"ltr" id=3D"yiv8271349837yui_3_16_0_ym19_1_1546952750506_184760">=
Installed:
postgre= sql11-server.x86_64 0:11.1-1PGDG.rhel7
Dependency Instal= led:
libicu.x86_64 0:50.1.2-17.el7   postgres11.x86_= 64 0:11.1-1PGDG.rhel 7

Completed!

After t= he server successful install, I initialize the database an

=
# /usr/pgsql-11/bin/postgresql-11-setup initdb
Initializing database= .....OK

# systemctl enable postgres-11
created syml= ink from /etc/systemd/system/multi-user.target.wants/postgresql-11.service = to /usr/lib/systemd/system/postgeresql-11.service.

# syste= mctl start postgresql-11
# systemctl status postgresql-11
postg= resql-11.service - PostgreSQL 11 database server
Loaded:loaded (/us= r/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disable= d)
Active: active (running) since Tues 2019-01-08 12:02:05 EST; 12s a= go
and so on ....

# service postgresql initdb
<= div dir=3D"ltr" id=3D"yiv8271349837yui_3_16_0_ym19_1_1546952750506_184010">= hint: the perferred way to do this is now "postgresql-set initdb"
Ini= tializing database ... OK

but when I tried to correct the = postgres.conf with the listen_addresses =3D '*' and port=3D5432.  Rest= art the postgresql server I get an error.

redirecting to /= bin/systemctl start postgresql.service

job for postgresql= .service failed because the control proces exited with error code.  Se= e "systemctl status postgresql.service" and "jouralctl -xe" for details.

I run: 
#systemctl status postgresql.service = -l
postgresql.service - PostgreSQL database server
Loaded:loade= d (/usr/lib/systemd/system/postgresql.service; diabled; vendor preset: disa= bled)
Active: failed (result: exit-code) since Tues 2019-01-08 12:34:= 43 EST; 2min 22s ago
Process: 6896 ExecStart=3D/usr/bin/pg_ctl start = -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=3Dexisted, status=3D1/FAILU= RE
Process: 688 ExecStartPre=3D/usr/bin/postgresql-check-db-dir ${PGD= ATA} (code=3Dexisted, status=3D0/SUCCESS) 
 
Jan 08 12:34:42 hostn= ame pg_ctl[6896]:HINT: Is another postmaster alreadying runnin ...y
J= an 08 12:34:42 hostname pg_ctl[6896]:LOG: could not bing IPV6 socket: Addre= ssa ...se
Jan 08 12:34:42 hostname pg_ctl[6896]:HINT: Is another post= master alreadying runnin ...y
Jan 08 12:34:42 hostname pg_ctl[6896]:W= ARNING: could not create any TCP/IP sockets
Jan 08 12:34:43 hostname = pg_ctl[6896]:pg_ctl: could nto start server
Jan 08 12:34:43 hostname = pg_ctl[1]: postgresql.service: control process existed, c...=3D1
<= div id=3D"yiv8271349837yui_3_16_0_ym19_1_1546952750506_184735" dir=3D"ltr">= Jan 08 12:34:43 hostname pg_ctl[1]: Failed to start PostgreSQL database ser= ver.
Jan 08 12:34:43 hostname pg_ctl[1]: Unit postgresql.service = entered failed state.
Jan 08 12:34:43 hostname pg_ctl[1]: postgre= sql.service failed

Hint: Some lines were ellipsized, u= se -l to show in full

what I did wrong here?  Do I ne= ed to add listen_addresses =3D '*' and port =3D 5432 on both /var/lib/pgsql= /data/postgres.conf and /var/lib/pgsql/11/data/postgres.conf ?

thank you for all your help.

v/r,

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.
= To call him a dog hardly seems to do him justice th= ough in as much as he had four legs, a tail, and barked, I admit he was, to= all outward appearances. But to those who knew him well, he was a perfect = gentleman (Hermione Gingold)

<= span id=3D"yiv8271349837yui_3_13_0_rc_1_1_1381789421038_7867" style=3D"colo= r:rgb(128, 0, 255);">**Live simply **Love generously **Care deeply **Speak = kindly.
*** Genuinely= rich *** Faithful talent *** Sharing success


<= div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1546952750506_189015"> On Thursday, December 20, 2018 4:17 PM, Kris Deugau <= ;kdeugau@vianet.ca> wrote:


Pepe TD Vo wrote:
> Ma= y you suggest me exactly repositories packages needed for install
> PostgreSQL?  Seem to me this link,
&= gt; https://downl= oad.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/
> all rpm files needed another dependencies.  Total more tha= n 300 files
> and only a few allow me to install the = rest of them needed another
> dependencies and didn't= give me exactly what they are.

Some o= f them will be from the stock Red Hat repositories, and some will
be from the PGDG repository.  I haven't used that repository= , and I
haven't done much on an RPM-based system for a w= hile so I can't give you
any more specific information.<= br clear=3D"none">
It's possible - but very tedious and d= ifficult - to install a package
with a large dependency = tree entirely by hand.  I *have* done this
myself i= n the past, and I recall a few cases where it literally took two
or three hours to get everything installed to support the specifi= c
package I started out trying to install.  This is= why tools like yum
were developed;  they do the wo= rk of checking through the list to see
what's required, = and where it can be installed from.

Th= is isn't specific to Postgres;  it's how the underlying OS package system works.  You may want to see if someone in your = office has more
experience installing packages on RHEL w= ith yum and ask them to give you
a hand.  You've go= t several issues around yum's basic operation that you
n= eed to fix, and local network/systems admins should know enough about
your setup to help a lot faster.


-kgd





------=_Part_15076650_1700698173.1546972379992--