Re: postgres service can't restart/start
Isaías Sánchez <[email protected]> Wed, 04 Dec 2019 20:36:15 +0100
| Newsgroups | gmane.comp.db.postgresql.pgadmin,gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. ------------16ed269bc3d70bd27c2f055a95 Content-Type: text/plain; format=flowed; charset="UTF-8" Content-Transfer-Encoding: 8bit Verify file permission is right, sometimes if you edit a conf file it changes owner and access permission En 4 de diciembre de 2019 18:55:38 Pepe TD Vo <[email protected]> escribió: > Hi experts, > > I am trying to install Postgresql 11.1 replication master-slave. The > configure, make and make install went well. Initdb to the shared drive and > psql are up and running. After configured pg_hba.conf and postgresql.conf, > I can't restart the service and/or reload. Error is: > ATHENTICATING for org.freedesktop.systemd1.manage-units --- > Athentication is required to manage system services or units. > authenticating as :user1 > Password: > -- ATHENTICATION 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 > reload the service. Postgres server stopped but can't start, it complained > about checkpoint_segments which I have set its to 8. > > Working with SA to reconfigure the authenticating and the server reaching > out and getting authenticaion from org.freedesktop.systemd1.nanage-units. > How can I by pass this issue and bring the postgres up? > > > 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 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 **Love generously **Care deeply **Speak kindly. > *** Genuinely rich *** Faithful talent *** Sharing success ------------16ed269bc3d70bd27c2f055a95 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.= w3.org/TR/html4/loose.dtd"> <html> <body> <div dir=3D"auto"> <div dir=3D"auto">Verify file permission is right, sometimes if you edit a = conf file it changes owner and access permission</div><div dir=3D'auto'><br= ></div> <div id=3D"aqm-original" style=3D"color: black;"> <!-- body start --> <div class=3D"aqm-original-body"><div style=3D"color: black;"> <p style=3D"color: black; font-size: 10pt; font-family: sans-serif; margin:= 8pt 0;">En 4 de diciembre de 2019 18:55:38 Pepe TD Vo <[email protected]= > escribi=C3=B3:</p> <blockquote type=3D"cite" class=3D"gmail_quote" style=3D"margin: 0 0 0 0.75= ex; border-left: 1px solid #808080; padding-left: 0.75ex;"> <div class=3D"ydpb36af001yahoo-style-wrap" style=3D"font-family:verdana, he= lvetica, sans-serif;font-size:16px;"><div><div dir=3D"ltr" data-setdir=3D"f= alse">Hi experts,</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><di= v dir=3D"ltr" data-setdir=3D"false">I am trying to install Postgresql 11.1 = replication master-slave. The configure, make and make install went w= ell. Initdb to the shared drive and psql are up and running. After co= nfigured pg_hba.conf and postgresql.conf, I can't restart the service and/o= r reload. Error is:</div><div dir=3D"ltr" data-setdir=3D"false">ATHEN= TICATING for org.freedesktop.systemd1.manage-units ---</div><div dir=3D"ltr= " data-setdir=3D"false">Athentication is required to manage system services= or units.</div><div dir=3D"ltr" data-setdir=3D"false">authenticating as :u= ser1</div><div dir=3D"ltr" data-setdir=3D"false">Password:</div><div dir=3D= "ltr" data-setdir=3D"false">-- ATHENTICATION COMPLETE --</div><div dir=3D"l= tr" data-setdir=3D"false">Failed to start psotgres-11.service: unit no foun= d.</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" d= ata-setdir=3D"false">I worked around and add the postgres on pg_hba.conf an= d using pg_ctl to reload the service. Postgres server stopped but can= 't start, it complained about checkpoint_segments which I have set its to 8= .</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" da= ta-setdir=3D"false">Working with SA to reconfigure the authenticating and t= he server reaching out and getting authenticaion from org.freedesktop.syste= md1.nanage-units. How can I by pass this issue 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_1381789421038_18" style=3D"background-c= olor: inherit; color: rgb(128, 0, 255);">Bach-Nga</b><br></div><div class= =3D"ydpb36af001signature"><div id=3D"ydpb36af001yui_3_13_0_rc_1_1_138178942= 1038_7868" class=3D"ydpb36af001yiv3811552299ms__id13889"><div id=3D"ydpb36a= f001yui_3_13_0_rc_1_1_1381789421038_7874" class=3D"ydpb36af001yiv3811552299= ms__id13893"><span style=3D"color: #0000ff;"><span id=3D"ydpb36af001yui_3_1= 3_0_rc_1_1_1381789421038_7871" class=3D"ydpb36af001yiv3811552299sg"><span s= tyle=3D"color: #8000ff;"><b id=3D"ydpb36af001yui_3_13_0_rc_1_16_13817894210= 38_18"><br clear=3D"none"></b>No one in this world is pure and perfect.&nbs= p; If you avoid people for their mistakes you will be alone. So judge less,= love and forgive more.</span></span></span></div><div id=3D"ydpb36af001yui= _3_13_0_rc_1_1_1381789421038_7874" class=3D"ydpb36af001yiv3811552299ms__id1= 3893"><span style=3D"color: #0000ff;"><span class=3D"ydpb36af001yiv38115522= 99sg"><span style=3D"color: #8000ff;">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 ad= mit he was, to all outward appearances. But to those who knew him well, he = was a perfect gentleman (Hermione Gingold)</span></span></span></div><br cl= ear=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 dee= ply **Speak kindly.</span></div><div id=3D"ydpb36af001yui_3_13_0_rc_1_1_138= 1789421038_7866" class=3D"ydpb36af001yiv3811552299ms__id13894"><span id=3D"= ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7865" class=3D"ydpb36af001yiv381= 1552299sg"><span style=3D"color: #8000ff;">*** Genuinely rich *** Faithful = talent *** Sharing success</span></span></div></div></div></div></blockquot= e> </div> </div> <!-- body end --> </div><div dir=3D"auto"><br></div> </div></body> </html> ------------16ed269bc3d70bd27c2f055a95--