Re: postgres service can't restart/start
Pepe TD Vo <[email protected]> Wed, 4 Dec 2019 20:38:59 +0000 (UTC)
| Newsgroups | gmane.comp.db.postgresql.admin,gmane.comp.db.postgresql.pgadmin |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_5865978_156960457.1575491939668
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
the permission and owner are right.=C2=A0 to add the authentication into th=
e pg_hba.conf but when I try to start up the postgres, it prompts me for pa=
ssword logged in, even I logged in directly from postgres os user not su fr=
om root and/or another os user.=3D=3D=3D=3D AUTHENTICATING FOR org.freedesk=
top.systemd1.manage-units =3D=3D=3D
Authentication is required to manage system services or units.
Authenticating as: user1Password:=3D=3D=3D=3D AUTHENTICATION COMPLETE =3D=
=3D=3D=3DFailed to start postgres-11.service: unit not foundSA worked aroun=
d with me and still can't start the postgresql service.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 Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3=ADas S=C3=A1nch=
ez <[email protected]> wrote: =20
=20
Verify file permission is right, sometimes if you edit a conf file it chan=
ges owner and access permission
En 4 de diciembre de 2019 18:55:38 Pepe TD Vo <[email protected]> escribi=C3=
=B3:
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
=20
------=_Part_5865978_156960457.1575491939668
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div class=3D"ydp315cd216yahoo-style-wrap" style=
=3D"font-family:verdana, helvetica, sans-serif;font-size:16px;"><div><div d=
ir=3D"ltr" data-setdir=3D"false">the permission and owner are right. =
to add the authentication into the pg_hba.conf but when I try to start up t=
he postgres, it prompts me for password logged in, even I logged in directl=
y from postgres os user not su from root and/or another os user.</div><div =
dir=3D"ltr" data-setdir=3D"false"><div dir=3D"ltr" data-setdir=3D"false"><p=
re><code>=3D=3D=3D=3D AUTHENTICATING FOR org.freedesktop.systemd1.manage-un=
its =3D=3D=3D
Authentication is required to manage system services or units.
Authenticating as: user1</code></pre><pre><code><span><pre style=3D"white-s=
pace: pre-wrap; color: rgb(0, 0, 0); font-size: 16px;"><code>Password:</cod=
e></pre></span><span><pre style=3D"white-space: pre-wrap; color: rgb(0, 0, =
0); font-size: 16px;"><code>=3D=3D=3D=3D AUTHENTICATION COMPLETE =3D=3D=3D=
=3D</code></pre><pre style=3D"white-space: pre-wrap; color: rgb(0, 0, 0); f=
ont-size: 16px;"><code>Failed to start postgres-11.service: unit not found<=
/code></pre><pre style=3D"white-space: pre-wrap; color: rgb(0, 0, 0); font-=
size: 16px;">SA worked around with me and still can't start the postgresql =
service.</pre></span></code></pre></div></div><div class=3D"ydp315cd216sign=
ature"><div id=3D"ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7868" class=3D=
"ydp315cd216yiv3811552299ms__id13889"><font color=3D"#0000ff"><b><span clas=
s=3D"ydp315cd216yiv3811552299sg"><font color=3D"#8000ff" style=3D"backgroun=
d-color: inherit;"></font></span></b></font><div id=3D"ydp315cd216yui_3_13_=
0_rc_1_1_1381789421038_7874" class=3D"ydp315cd216yiv3811552299ms__id13893">=
<font id=3D"ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7873" color=3D"#0000=
ff"><font color=3D"#8000ff"></font><span id=3D"ydp315cd216yui_3_13_0_rc_1_1=
_1381789421038_7871" class=3D"ydp315cd216yiv3811552299sg"><font id=3D"ydp31=
5cd216yui_3_13_0_rc_1_1_1381789421038_7870" color=3D"#8000ff" style=3D"back=
ground-color: inherit;"><b id=3D"ydp315cd216yui_3_13_0_rc_1_16_138178942103=
8_18">Bach-Nga<br clear=3D"none"><br clear=3D"none"></b>No one in this worl=
d is pure and perfect. If you avoid people for their mistakes you wil=
l be alone. So judge less, love and forgive more.</font></span></font></div=
><div id=3D"ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7874" class=3D"ydp31=
5cd216yiv3811552299ms__id13893"><font color=3D"#0000ff"><span class=3D"ydp3=
15cd216yiv3811552299sg"><font color=3D"#8000ff" style=3D"background-color: =
inherit;">To call him a dog hardly seems to do him justice though in as muc=
h as he had four legs, a tail, and barked, I admit he was, to all outward a=
ppearances. But to those who knew him well, he was a perfect gentleman (Her=
mione Gingold)</font></span></font></div><br clear=3D"none"><span style=3D"=
color:rgb(128, 0, 255);" id=3D"ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7=
867">**Live simply **Love generously **Care deeply **Speak kindly.</span></=
div><div id=3D"ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7866" class=3D"yd=
p315cd216yiv3811552299ms__id13894"><span id=3D"ydp315cd216yui_3_13_0_rc_1_1=
_1381789421038_7865" class=3D"ydp315cd216yiv3811552299sg"><font id=3D"ydp31=
5cd216yui_3_13_0_rc_1_1_1381789421038_7864" color=3D"#8000ff" style=3D"back=
ground-color: inherit;">*** Genuinely rich *** Faithful talent *** Sharing =
success</font></span></div></div></div>
<div><br></div><div><br></div>
=20
</div><div id=3D"yahoo_quoted_5889472731" class=3D"yahoo_quoted">
<div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
=20
<div>
On Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3=
=ADas S=C3=A1nchez <[email protected]> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id=3D"yiv7202067243"><div>
<div>
<div>Verify file permission is right, sometimes if you edit a conf file it =
changes owner and access permission</div><div><br clear=3D"none"></div>
<div id=3D"yiv7202067243aqm-original" style=3D"color:black;">
<div class=3D"yiv7202067243aqm-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]> es=
cribi=C3=B3:</p>
<div class=3D"yiv7202067243yqt8631889837" id=3D"yiv7202067243yqt09702"><blo=
ckquote class=3D"yiv7202067243gmail_quote" type=3D"cite" style=3D"margin:0 =
0 0 0.75ex;border-left:1px solid #808080;padding-left:0.75ex;">
<div class=3D"yiv7202067243ydpb36af001yahoo-style-wrap" style=3D"font-famil=
y:verdana, helvetica, sans-serif;font-size:16px;"><div><div dir=3D"ltr">Hi =
experts,</div><div dir=3D"ltr"><br clear=3D"none"></div><div dir=3D"ltr">I =
am trying to install Postgresql 11.1 replication master-slave. The co=
nfigure, make and make install went well. Initdb to the shared drive =
and psql are up and running. After configured pg_hba.conf and postgresql.co=
nf, I can't restart the service and/or reload. Error is:</div><div di=
r=3D"ltr">ATHENTICATING for org.freedesktop.systemd1.manage-units ---</div>=
<div dir=3D"ltr">Athentication is required to manage system services or uni=
ts.</div><div dir=3D"ltr">authenticating as :user1</div><div dir=3D"ltr">Pa=
ssword:</div><div dir=3D"ltr">-- ATHENTICATION COMPLETE --</div><div dir=3D=
"ltr">Failed to start psotgres-11.service: unit no found.</div><div dir=3D"=
ltr"><br clear=3D"none"></div><div dir=3D"ltr">I worked around and add the =
postgres on pg_hba.conf and using pg_ctl to reload the service. Postg=
res server stopped but can't start, it complained about checkpoint_segments=
which I have set its to 8.</div><div dir=3D"ltr"><br clear=3D"none"></div>=
<div dir=3D"ltr">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=
?</div><div dir=3D"ltr"><br clear=3D"none"></div><div dir=3D"ltr"><br clear=
=3D"none"></div><div dir=3D"ltr"><b id=3D"yiv7202067243ydpb36af001yui_3_13_=
0_rc_1_16_1381789421038_18" style=3D"background-color:inherit;color:rgb(128=
, 0, 255);">Bach-Nga</b><br clear=3D"none"></div><div class=3D"yiv720206724=
3ydpb36af001signature"><div class=3D"yiv7202067243ydpb36af001yiv3811552299m=
s__id13889" id=3D"yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7=
868"><div class=3D"yiv7202067243ydpb36af001yiv3811552299ms__id13893" id=3D"=
yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7874"><span style=
=3D"color:#0000ff;"><span class=3D"yiv7202067243ydpb36af001yiv3811552299sg"=
id=3D"yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7871"><span =
style=3D"color:#8000ff;"><b id=3D"yiv7202067243ydpb36af001yui_3_13_0_rc_1_1=
6_1381789421038_18"><br clear=3D"none"></b>No one in this world is pure and=
perfect. If you avoid people for their mistakes you will be alone. S=
o judge less, love and forgive more.</span></span></span></div><div class=
=3D"yiv7202067243ydpb36af001yiv3811552299ms__id13893" id=3D"yiv7202067243yd=
pb36af001yui_3_13_0_rc_1_1_1381789421038_7874"><span style=3D"color:#0000ff=
;"><span class=3D"yiv7202067243ydpb36af001yiv3811552299sg"><span style=3D"c=
olor:#8000ff;">To call him a dog hardly seems to do him justice though in a=
s much as he had four legs, a tail, and barked, I admit he was, to all outw=
ard appearances. But to those who knew him well, he was a perfect gentleman=
(Hermione Gingold)</span></span></span></div><br clear=3D"none"><span id=
=3D"yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7867" style=3D"=
color:rgb(128, 0, 255);">**Live simply **Love generously **Care deeply **Sp=
eak kindly.</span></div><div class=3D"yiv7202067243ydpb36af001yiv3811552299=
ms__id13894" id=3D"yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_=
7866"><span class=3D"yiv7202067243ydpb36af001yiv3811552299sg" id=3D"yiv7202=
067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7865"><span style=3D"color=
:#8000ff;">*** Genuinely rich *** Faithful talent *** Sharing success</span=
></span></div></div></div></div></blockquote></div>
</div>
</div>
</div><div><br clear=3D"none"></div>
</div></div></div></div>
</div>
</div></body></html>
------=_Part_5865978_156960457.1575491939668--