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 1ggxz9-0001h6-L3 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 20:28:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggxz7-0000BL-2u for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2019 20:28:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggxz6-0008V0-Oj for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 20:28:24 +0000 Received: from sonic310-14.consmr.mail.bf2.yahoo.com ([74.6.135.124]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggxz1-00006R-14 for pgsql-admin@lists.postgresql.org; Tue, 08 Jan 2019 20:28:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1546979296; bh=H9uTiKRN4uTFgpeKGPZ2QvmBid6rW29DRPNrRnet4zI=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=MlJVvpbWvxvv34xuYv+ZUPHAKFMf/He67r9LYP+g2hDelUr8xnFLKWrYAbRgJOGyT0xdGMMpEy299gCiOUwanot2S6kQk/OldNspovoQrpuiDPEO97fKbLohjR18dVkBV4luTiPxxDOSMQJeqr2HcpysPXoJyRv47wT9H9RwJPzzFmhfrDADcPXHd2FYYbJYmDeIacJmBvfecpKUBd5hHeWXITifWa5AwiGbkRgG1g1wR8Ces7AehZ22Le0kgADWhviZlDOfRnOZV7KocdLHxVJrg2FJRTrTQ90JVYZj+7DnmcQInpMwlysR86lNM4Qrxe/aEyUhZXAwtFtfTolf/A== X-YMail-OSG: XqbvEWQVM1nemenN4xPkGmlN5ZoAZsh.bJVuL5LqXyFrBVi8sbmT67Vf_fbBPMl azyvCTb2PkcNmvBKdRGFJR3OSxHi.XOEcgu3plojVPI4EBRKChoZTfRDqAJXk5WjRvD5ybFrkAeD BnKZTKex9.rklk2mpPoHIVHIcALeomK8YmBmANIiNjCiNEvJNHo0pNJE8rm4L7uemuw0zz9MiTJI a2sIzT.fZLApU3rKnAJxxSl6A3byZOj68viFEs7.0P2t2REXAwXLCYgj0bCPaJSzlqFqPeLQDm6Z FS9xz4WdDkZSkH8XZLSG7m.MTG_ZvQc8DCoDx19Whr2fxMeAANk6IrRXHjU9H4FSxyledR4ALx.L n_CiXsI8JVMfPtNO3PzIvL8wBUsdHmTPHd5mHm1pEhbI5vwhjxGm7SAmlbc_qzAVLd9rgqH85Dg_ 6BnoJjuTcmNwa5RKm7ziL9QKNhPKcLpUmcDWynfXARRbFWzY6tOGmu1bdKDyuQ_BwYOTPxAneUkK 0y.sowWXFDy3GMVrcUr4s1W_yOtglvzmjC_g9r2xnIZMmjcbYQYZR9EcES1Hhmfl0XRmufF9Cfu7 _f14Tx9eZLtaRI_hLqMQ781uOZEmHj2cICw8Aw7QSD62tbUXkR5ZZUslpnyZCwR8cTt6PIw9uUFy PZ3Rabf7OxJxSXVN90ebKqG0KLep4LLXk6LoT0aO3SurGlzKy8fxc8MCp9Fr7Rpwzg5MHJF4fwu3 Orj4STTU9RBaCUo4WdLC9ONu4p5j3TmaSj4MNU.27I9dIlxEmqDLpVtP5p72XQC4a6dEwtMYaW85 ct9t1aFN3G8Iyn8ELtCxbIqt5mwL7EhbSduxLpgLiX1WkVeJfESvJ6vdr3YcTTlCaenoTSrA87RZ ADPuB.IfLWnOS.f.w3yZ1ukLWQ23LWG_vTDeJ7MS3Ta2HAKCpl2KQlE3ZYPCpj5QhsvigwAe3OsR Zz3lrYj.esU0nOVDIDesgs_xrgfbiz8BtkoPzOcMCgklIgjrJLrvkk_watgLL.HQW0Vy6BZo67HZ drmD.LcMvqMKjNZU6KteGi.U5m1sD.kNN1yZPELPSBNw.3hA0sSd4nlaiHjiL8RjG.MuBMCVsO8M Ziw-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.bf2.yahoo.com with HTTP; Tue, 8 Jan 2019 20:28:16 +0000 Date: Tue, 8 Jan 2019 20:28:12 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Ricardo Martin Gomez , Kris Deugau , "pgsql-admin@lists.postgresql.org" Message-ID: <1174448879.15161463.1546979292149@mail.yahoo.com> In-Reply-To: <1512268703.15157573.1546978861810@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> <663674680.15076651.1546972379997@mail.yahoo.com> <646999185.15108632.1546978105400@mail.yahoo.com> <1512268703.15157573.1546978861810@mail.yahoo.com> Subject: Re: install Postgres on RHED 7 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15161462_1153312055.1546979292140" 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: 68846 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_15161462_1153312055.1546979292140 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable #ps -aux|grep postgres postgres 4840 0.0 0.1=C2=A0 396576 16772 ? Ss 12:02 0:00 /usr/pgsql-11/bin/= postmaster -D /var/lib/pgsql/11/data/ postgre 4842 0.9 9.9 251496 1928 ? Ss 12:02 0:00 posgres:loggerpostgre 4844= 0.9 9.9 396692 3456 ? Ss 12:02 0:00 posgres:checkpointer postgre 4845 0.9 9.9 396576 3344 ? Ss 12:02 0:00 posgres:background writer postgre 4846 0.9 9.9 396576 6248 ? Ss 12:02 0:00 posgres:walwriter postgre 4847 0.9 9.9 396992 3088 ? Ss 12:02 0:00 posgres:autovacuum launche= r postgre 4848 0.9 9.9 251492 2044 ? Ss 12:02 0:00 posgres:stats collectorpos= tgre 4849 0.9 9.9 396992 2796 ? Ss 12:02 0:00 posgres:logical replication l= auncher root 14091 0.0 0.0=C2=A0 112704 980 pts/1 S+ 14:53 0:00 grep --color=3Dauto= postgres Even I stop and restart the service still error #service postgresql stopredirecting to /bin/systemctl stop posgresql.servic= e #service postgresql startredirecting to /bin/systemctl start postgresql.ser= vicejob for posgresql.service failed because the control process existed wi= th error code. See "systemctl status posgresql.service" and "journalctl -xe= " for details. for systemctl status posgresql.service, as same as I posted from previous. #journalctl -xe -- Unit user-995.slice has begun shutting down.Jan 08 14:55:26 hostname pol= kidtd[1000]: Registered Authentication Agent for unix-procesJan 08 14:55:26= hostname polkidtd[1000]: Unregistered Authentication Agent for unix-proc Jan 08 14:55:26 hostname polkidtd[1000]: Registered Authentication Agent fo= r unix-proces Jan 08 14:55:26 hostname systemd[1]: Starting PostgreSQL database server ..= . -- Subject: Unit posgresql.service has begun start-up-- Defined-By:systemd-= - Support:=C2=A0http://lists.freedesktop.org/mailman/listinfor/systemd-deve= l---- Unit postgresql.service has begun starting uo.Jan 08 14:44:31 hostnam= e [pg_ctl[14265]: LOG: could not bind IPv4 socket: Address alreaJan 08 14:4= 4:31 hostname [pg_ctl[14265]: HINT: is another postmaster already running o= n Jan 08 14:44:31 hostname [pg_ctl[14265]: LOG: could not bind IPv6 socket: a= ddress alrea Jan 08 14:44:31 hostname [pg_ctl[14265]: HINT: Is another postmaster alread= y running on Jan 08 14:44:31 hostname [pg_ctl[14265]: WrANING: could not create listen s= ocket for "*" Jan 08 14:44:31 hostname [pg_ctl[14265]: FATAL: could not create any TCP/IP= sockets Jan 08 14:44:32 hostname [pg_ctl[14265]: pg_ctl: could not start server Jan 08 14:44:32 hostname [pg_ctl[14265]: Examine the log output Jan 08 14:44:31 hostname systemd[1]: postgresql.service: control process ex= isted, code=3De: Jan 08 14:44:31 hostname systemd[1]: Failed to start PostgreSQL database se= rver. --Subject:unit postgresql.service has failed--Defined-By:systemd--Unit post= gresql.service has failed---- the result is failedJan 08 14:55:32 hostname = systemd[1]: Unit postgresql.service entered failed state.Jan 08 14:55:32 ho= stname systemd[1]: Unit postgresql.service failed Jan 08 14:55:32 hostname polkitd[1000]: sorry again for multi splitting my fingers to send out. thank you so much for looking into the problems. R/=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 Tuesday, January 8, 2019 3:21 PM, Pepe TD Vo wrot= e: =20 #ps -aux|grep postgres postgres 4840 0.0 0.1=C2=A0 396576 16772 ? Ss 12:02 0:00 /usr/pgsql-11/bin/= postmaster -D /var/lib/pgsql/11/data/ postgre 4842 0.9 9.9 251496 1928 ? Ss 12:02 0:00 posgres:loggerpostgre 4844= 0.9 9.9 396692 3456 ? Ss 12:02 0:00 posgres:checkpointer postgre 4845 0.9 9.9 396576 3344 ? Ss 12:02 0:00 posgres:background writer postgre 4846 0.9 9.9 396576 6248 ? Ss 12:02 0:00 posgres:walwriter postgre 4847 0.9 9.9 396992 3088 ? Ss 12:02 0:00 posgres:autovacuum launche= r postgre 4848 0.9 9.9 251492 2044 ? Ss 12:02 0:00 posgres:stats collectorpos= tgre 4849 0.9 9.9 396992 2796 ? Ss 12:02 0:00 posgres:logical replication l= auncher root 14091 0.0 0.0=C2=A0 112704 980 pts/1 S+ 14:53 0:00 grep --color=3Dauto= postgres Even I stop and restart the service still error #service postgresql stopredirecting to /bin/systemctl stop posgresql.servic= e #service postgresql startredirecting to /bin/systemctl start postgresql.ser= vicejob for posgresql.service failed because the control process existed wi= th error code. See "systemctl status posgresql.service" and "journalctl -xe= " for details. for systemctl status posgresql.service, as same as I posted from previous. #journalctl -xe -- Unit user-995.slice has begun shutting down.Jan 08 14:55:26 hostname pol= kidtd[1000]: Registered Authentication Agent for unix-procesJan 08 14:55:26= hostname polkidtd[1000]: Unregistered Authentication Agent for unix-proc Jan 08 14:55:26 hostname polkidtd[1000]: Registered Authentication Agent fo= r unix-proces Jan 08 14:55:26 hostname systemd[1]: Starting PostgreSQL database server ..= . -- Subject: Unit posgresql.service has begun start-up-- Defined-By:systemd-= - Support: http://lists.freedesktop.org/mailman/listinfor/systemd-devel----= Unit postgresql.service has begun starting uo.Jan 08 14:44:31 hostname [g_= c tl[14265]: LOG: could not bind IPv4 socket: Address alreaJan 08 14:44:31 = hostname [g_c tl[14265]: Jan 08 14:44:31 hostname [g_c tl[14265]: Jan 08 14:44:31 hostname [g_c tl[14265]: Jan 08 14:44:31 hostname [g_c tl[14265]: 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 Tuesday, January 8, 2019 3:08 PM, Pepe TD Vo wrot= e: =20 #ps -aux|grep postgres postgres 4840 0.0 0.1396576 16772 ? Ss 12:02 0:00 /usr/pgsql-11/bin/postmas= ter -D /var/lib/pgsql/11/data/ postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:loggerpostgre 4/8= 42 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger =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 Tuesday, January 8, 2019 1:41 PM, Ricardo Martin Gomez wrote: =20 #yiv9180917263 P {margin-top:0;margin-bottom:0;}Hi, but the ERROR is: "pg_= ctl[6896]:HINT: Is another postmaster alreadying runnin ...y" Please, Can you check this?# ps -aux |grep postgres Regards. ______________________Saludos=C2=A0Ing. Ricardo Mart=C3=ADn GomezDBA - SysA= dminDe: Pepe TD Vo Enviado: martes, 8 de enero de 2019 15:32 Para: Kris Deugau; pgsql-admin@lists.postgresql.org Asunto: Re: install Postgres on RHED 7=C2=A0sorry, my fingers split before = I can finish all typing: 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-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 On Thursday, December 20, 2018 4:17 PM, Kris Deugau wro= te: 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 =20 ------=_Part_15161462_1153312055.1546979292140 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
#ps -aux|grep postgres

postgres 4840 0.0 0.1  396576 16772 ? Ss 12:02 0:00 /usr/pgsql-11/bin= /postmaster -D /var/lib/pgsql/11/data/

post= gre 4842 0.9 9.9 251496 1928 ? Ss 12:02 0:00 posgres:logger
postgre 4844 0.9= 9.9 396692 3456 ? Ss 12:02 0:00 posgres:checkpointer
postgre 4845 0.9 9.9 396576 3344 ? Ss 1= 2:02 0:00 posgres:background writer
postgre 4846 0.9 9.9 396576 6248 ? Ss 12:02 0:00 posgres:w= alwriter
postgre 48= 47 0.9 9.9 396992 3088 ? Ss 12:02 0:00 posgres:autovacuum launcher
postgre 4848 0.9 9.9 251492= 2044 ? Ss 12:02 0:00 posgres:stats collector
postgre 4849 0.9 9.9 396992 2796 ? Ss 12:02 0:00 posgres:logic= al replication launcher
root 14091 0.0 0.0  112704 980 pts/1 S+ 14:53 0:00 grep --color= =3Dauto postgres

Even I stop and restart the service still er= ror

#service postgresql stop
redirecting to = /bin/systemctl stop posgresql.service

#service postgresql start
redirecting to /bin/systemctl start postgresq= l.service
job for posgresql.service failed because the control process existed with= error code. See "systemctl status posgresql.service" and "journalctl -xe" = for details.

=
for systemctl= status posgresql.service, as same as I posted from previous.

#journalctl -xe

-- Unit user-995.slice has begun shutting down.
Jan 08 14= :55:26 hostname polkidtd[1000]: Registered Authentication Agent for unix-pr= oces
Jan= 08 14:55:26 hostname polkidtd[1000]: Unregistered Authentication Agent for= unix-proc
<= /div>
Jan 08 1= 4:55:26 hostname polkidtd[1000]: Registered Authentication Agent for unix-p= roces
=
Jan 08 14:55:= 26 hostname systemd[1]: Starting PostgreSQL database server ...

-- Subject: Unit posgresql.service ha= s begun start-up
-- Defined-By:systemd
--
-- U= nit postgresql.service has begun starting uo.
Jan 08 14:44:31 hostname [pg_ctl[1426= 5]: LOG: could not bind IPv4 socket: Address alrea
Jan 08 14:44:31 hostname [pg_ctl= [14265]: HINT: is another postmaster already running on
Jan 08 14:44:31 hostname [pg_ctl[14265= ]: LOG: could not bind IPv6 socket: address alrea
Jan 08 14:44:31 hostname [pg_ctl[14265]: HIN= T: Is another postmaster already running on
Jan 08 14:44:31 hostname [pg_ctl[14265]: WrANING: = could not create listen socket for "*"
Jan 08 14:44:31 hostname [pg_ctl[14265]: FATAL: could not create any= TCP/IP sockets
Jan 08 14:44:32 hostname [pg_ctl[14265]: pg_ctl: could not star= t server
Jan 08 14:= 44:32 hostname [pg_ctl[14265]: Examine the log output
Jan 08 14:44:31 hostname systemd[1]: po= stgresql.service: control process existed, code=3De:
Jan 08 14:44:31 hostname systemd[1]: Fa= iled to start PostgreSQL database server.
--Subject:unit postgresql.service has failed
--Defined-By:sy= stemd
--= Unit postgresql.service has failed
--
-- the result is failed
Jan 08 14:55:32 hostname systemd[1]: = Unit postgresql.service entered failed state.
Jan 08 14:55:32 hostname systemd[1]: = Unit postgresql.service failed
Jan= 08 14:55:32 hostname polkitd[1000]:


sorry again for multi splitting my fingers to send out.

thank you so much for looki= ng into the problems.

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, lo= ve and forgive more.
To call him a dog hardly seem= s to do him justice though in as much as he had four legs, a tail, and bark= ed, I admit he was, to all outward appearances. But to those who knew him w= ell, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply= **Speak kindly.
*** Genuinely rich *** Faithful talent *** = Sharing success

=
On Tuesday, January 8, 2019 3:21 PM, Pepe TD Vo <pepevo@y= ahoo.com> wrote:


#ps -aux|grep postg= res

postgres 4840 0.0 0.1  396576 16772 ? Ss 12:02 0:00 /usr/= pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/

postgre 4842 0.= 9 9.9 251496 1928 ? Ss 12:02 0:00 posgres:logger
postgre 4844 0= .9 9.9 396692 3456 ? Ss 12:02 0:00 posgres:checkpointer
postgre 4845= 0.9 9.9 396576 3344 ? Ss 12:02 0:00 posgres:background writer
postg= re 4846 0.9 9.9 396576 6248 ? Ss 12:02 0:00 posgres:walwriter
postgr= e 4847 0.9 9.9 396992 3088 ? Ss 12:02 0:00 posgres:autovacuum launcher
postgre 4848 0.9 9.9 251492 2044 ? Ss 12:02 0:00 posgres:stats collector=
postgr= e 4849 0.9 9.9 396992 2796 ? Ss 12:02 0:00 posgres:logical replication laun= cher
root 14091 0.0 0.0  112704 980 pts/1 S+ 14:53 0:00 grep --= color=3Dauto postgres


=
= Even I stop and restart the service still error

#service= postgresql stop
redirecting to /bin/systemctl stop posgresql.service<= /div>

#service postgresql start
redirecting to= /bin/systemctl start postgresql.service
job for posgresql.service fai= led because the control process existed with error code. See "systemctl sta= tus posgresql.service" and "journalctl -xe" for details.

for systemctl status posgresql.service, as same as I posted fro= m previous.

#journalctl -xe

-- Unit user-995.slice has begun shutting down.
Jan 08 1= 4:55:26 hostname polkidtd[1000]: Registered Authentication Agent for unix-p= roces
Jan 08 14:55:26 hostname polkidtd[1000]: Unregistered Authentica= tion Agent for unix-proc
Jan 08 14:55:26 hostname p= olkidtd[1000]: Registered Authentication Agent for unix-proces
Jan 08 14:55:26 hostname systemd[1]: Starting PostgreSQL databa= se server ...

-- Subject: Unit posgresql.serv= ice has begun start-up
-- Defined-By:systemd
--
-- Unit postgresql.service has begun starting u= o.
Jan 08 14:44:31 hostname [g_c tl[14265]: LOG: could not bind IPv4 s= ocket: Address alrea
Jan 08 14:44:31 hostname [g_c tl[14265]:
Jan 08 14:44:31 hostname [g_c tl[14265]:
=
Jan 08 14:44:31 hostname [g_c tl[14265]:
Jan = 08 14:44:31 hostname [g_c tl[14265]:






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.
<= span class=3D"yiv9180917263sg" id=3D"yiv9180917263yui_3_16_0_ym19_1_1546976= 653190_20466">To call him a dog hardly seems to do him justice thoug= h in as much as he had four legs, a tail, and barked, I admit he was, to al= l outward appearances. But to those who knew him well, he was a perfect gen= tleman (Hermione Gingold)

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


On Tuesday, January 8, 2019 3:08 PM, Pepe TD Vo <pepevo@ya= hoo.com> wrote:


#ps = -aux|grep postgres

postgres 4840 0.0 0.1396576 16772 ? Ss 12= :02 0:00 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/

postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0= :00 posgres:logger
postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02= 0:00 posgres:logger
postgre 4/842 0.9= 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger
pos= tgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger
postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 posgres:logger=
postgre 4/842 0.9 9.9 352496 1928 ? Ss 12:02 0:00 = posgres:logger
 
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 forgiv= e 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 to those= who knew him well, he was a perfect gentleman (Hermione Gingold)

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


On Tuesday, January 8, = 2019 1:41 PM, Ricardo Martin Gomez <rimartingomez@hotmail.com> wrote:=