postgres service can't restart/start
Pepe TD Vo <[email protected]> Wed, 4 Dec 2019 17:55:27 +0000 (UTC)
| Newsgroups | gmane.comp.db.postgresql.pgadmin,gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_2008677_1539007214.1575482127452 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi experts, I am trying to install Postgresql 11.1 replication master-slave.=C2=A0 The = configure, make and make install went well.=C2=A0 Initdb to the shared driv= e and psql are up and running. After configured pg_hba.conf and postgresql.= conf, I can't restart the service and/or reload.=C2=A0 Error is:ATHENTICATI= NG for org.freedesktop.systemd1.manage-units ---Athentication is required t= o manage system services or units.authenticating as :user1Password:-- ATHEN= TICATION COMPLETE --Failed to start psotgres-11.service: unit no found. I worked around and add the postgres on pg_hba.conf and using pg_ctl to rel= oad the service.=C2=A0 Postgres server stopped but can't start, it complain= ed about checkpoint_segments which I have set its to 8. Working with SA to reconfigure the authenticating and the server reaching o= ut and getting authenticaion from org.freedesktop.systemd1.nanage-units.=C2= =A0 How can I by pass this issue and bring the postgres up? 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 ------=_Part_2008677_1539007214.1575482127452 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <html><head></head><body><div class=3D"ydpb36af001yahoo-style-wrap" style= =3D"font-family:verdana, helvetica, sans-serif;font-size:16px;"><div><div d= ir=3D"ltr" data-setdir=3D"false">Hi experts,</div><div dir=3D"ltr" data-set= dir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">I am trying = to install Postgresql 11.1 replication master-slave. The configure, m= ake and make install went well. Initdb to the shared drive and psql a= re up and running. After configured pg_hba.conf and postgresql.conf, I can'= t restart the service and/or reload. Error is:</div><div dir=3D"ltr" = data-setdir=3D"false">ATHENTICATING for org.freedesktop.systemd1.manage-uni= ts ---</div><div dir=3D"ltr" data-setdir=3D"false">Athentication is require= d to manage system services or units.</div><div dir=3D"ltr" data-setdir=3D"= false">authenticating as :user1</div><div dir=3D"ltr" data-setdir=3D"false"= >Password:</div><div dir=3D"ltr" data-setdir=3D"false">-- ATHENTICATION COM= PLETE --</div><div dir=3D"ltr" data-setdir=3D"false">Failed to start psotgr= es-11.service: unit no found.</div><div dir=3D"ltr" data-setdir=3D"false"><= br></div><div dir=3D"ltr" data-setdir=3D"false">I worked around and add the= postgres on pg_hba.conf and using pg_ctl to reload the service. Post= gres server stopped but can't start, it complained about checkpoint_segment= s which I have set its to 8.</div><div dir=3D"ltr" data-setdir=3D"false"><b= r></div><div dir=3D"ltr" data-setdir=3D"false">Working with SA to reconfigu= re the authenticating and the server reaching out and getting authenticaion= from org.freedesktop.systemd1.nanage-units. How can I by pass this i= ssue and bring the postgres up?</div><div dir=3D"ltr" data-setdir=3D"false"= ><br></div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr= " data-setdir=3D"false"><b id=3D"ydpb36af001yui_3_13_0_rc_1_16_138178942103= 8_18" style=3D"background-color: inherit; color: rgb(128, 0, 255);">Bach-Ng= a</b><br></div><div class=3D"ydpb36af001signature"><div id=3D"ydpb36af001yu= i_3_13_0_rc_1_1_1381789421038_7868" class=3D"ydpb36af001yiv3811552299ms__id= 13889"><div id=3D"ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7874" class=3D= "ydpb36af001yiv3811552299ms__id13893"><font id=3D"ydpb36af001yui_3_13_0_rc_= 1_1_1381789421038_7873" color=3D"#0000ff"><span id=3D"ydpb36af001yui_3_13_0= _rc_1_1_1381789421038_7871" class=3D"ydpb36af001yiv3811552299sg"><font id= =3D"ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7870" color=3D"#8000ff" styl= e=3D"background-color: inherit;"><b id=3D"ydpb36af001yui_3_13_0_rc_1_16_138= 1789421038_18"><br clear=3D"none"></b>No one in this world is pure and perf= ect. If you avoid people for their mistakes you will be alone. So jud= ge less, love and forgive more.</font></span></font></div><div id=3D"ydpb36= af001yui_3_13_0_rc_1_1_1381789421038_7874" class=3D"ydpb36af001yiv381155229= 9ms__id13893"><font color=3D"#0000ff"><span class=3D"ydpb36af001yiv38115522= 99sg"><font color=3D"#8000ff" style=3D"background-color: inherit;">To call = him a dog hardly seems to do him justice though in as much as he had four l= egs, 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)</fo= nt></span></font></div><br clear=3D"none"><span style=3D"color:rgb(128, 0, = 255);" id=3D"ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7867">**Live simply= **Love generously **Care deeply **Speak kindly.</span></div><div id=3D"ydp= b36af001yui_3_13_0_rc_1_1_1381789421038_7866" class=3D"ydpb36af001yiv381155= 2299ms__id13894"><span id=3D"ydpb36af001yui_3_13_0_rc_1_1_1381789421038_786= 5" class=3D"ydpb36af001yiv3811552299sg"><font id=3D"ydpb36af001yui_3_13_0_r= c_1_1_1381789421038_7864" color=3D"#8000ff" style=3D"background-color: inhe= rit;">*** Genuinely rich *** Faithful talent *** Sharing success</font></sp= an></div></div></div></div></body></html> ------=_Part_2008677_1539007214.1575482127452--