Re: postgres service can't restart/start

--0000000000002c49460598e8c242
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Do you have a systemd service file named `postgres-11`?  If so, what are
the contents of it and the location of the file on the file system?

On Wed, Dec 4, 2019 at 1:39 PM Pepe TD Vo <[email protected]> wrote:

> the permission and owner are right.  to add the authentication into the
> pg_hba.conf but when I try to start up the postgres, it prompts me for
> password logged in, even I logged in directly from postgres os user not s=
u
> from root and/or another os user.
>
> =3D=3D=3D=3D AUTHENTICATING FOR org.freedesktop.systemd1.manage-units =3D=
=3D=3D
> Authentication is required to manage system services or units.
> Authenticating as: user1
>
> Password:
>
> =3D=3D=3D=3D AUTHENTICATION COMPLETE =3D=3D=3D=3D
>
> Failed to start postgres-11.service: unit not found
>
> SA worked around with me and still can't start the postgresql service.
>
>
>
> *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 mor=
e.
> 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
>
>
> On Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3=ADas S=C3=A1nchez=
 <
> [email protected]> wrote:
>
>
> 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=
=C3=B3:
>
> 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 a=
nd
> 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 complain=
ed
> 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
>
>
>

--0000000000002c49460598e8c242
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Do you have a systemd service file named `postgres-11`?=C2=
=A0 If so, what are the contents of it and the location of the file on the =
file system?</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"=
gmail_attr">On Wed, Dec 4, 2019 at 1:39 PM Pepe TD Vo &lt;<a href=3D"mailto=
:[email protected]">[email protected]</a>&gt; wrote:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div><div style=3D"font-family:verdana,h=
elvetica,sans-serif;font-size:16px"><div><div dir=3D"ltr">the permission an=
d owner are right.=C2=A0 to add the authentication into the pg_hba.conf but=
 when I try to start up the postgres, it prompts me for password logged in,=
 even I logged in directly from postgres os user not su from root and/or an=
other os user.</div><div dir=3D"ltr"><div dir=3D"ltr"><pre><code>=3D=3D=3D=
=3D AUTHENTICATING FOR org.freedesktop.systemd1.manage-units =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:</code></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);font-size:16px"><code>Fa=
iled 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 wit=
h me and still can&#39;t start the postgresql service.</pre></span></code><=
/pre></div></div><div><div id=3D"gmail-m_-2003649318310386598ydp315cd216yui=
_3_13_0_rc_1_1_1381789421038_7868"><font color=3D"#0000ff"><b><span><font c=
olor=3D"#8000ff" style=3D"background-color:inherit"></font></span></b></fon=
t><div id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_13817=
89421038_7874"><font id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_13_=
0_rc_1_1_1381789421038_7873" color=3D"#0000ff"><font color=3D"#8000ff"></fo=
nt><span id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_138=
1789421038_7871"><font id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_1=
3_0_rc_1_1_1381789421038_7870" color=3D"#8000ff" style=3D"background-color:=
inherit"><b id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_16=
_1381789421038_18">Bach-Nga<br clear=3D"none"><br clear=3D"none"></b>No one=
 in this world is pure and perfect.=C2=A0 If you avoid people for their mis=
takes you will be alone. So judge less, love and forgive more.</font></span=
></font></div><div id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_=
rc_1_1_1381789421038_7874"><font color=3D"#0000ff"><span><font color=3D"#80=
00ff" style=3D"background-color:inherit">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)</font></span></font></div><br=
 clear=3D"none"><span style=3D"color:rgb(128,0,255)" id=3D"gmail-m_-2003649=
318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7867">**Live simply =
**Love generously **Care deeply **Speak kindly.</span></div><div id=3D"gmai=
l-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7866"><s=
pan id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_13817894=
21038_7865"><font id=3D"gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_r=
c_1_1_1381789421038_7864" color=3D"#8000ff" style=3D"background-color:inher=
it">*** Genuinely rich *** Faithful talent *** Sharing success</font></span=
></div></div></div>
        <div><br></div><div><br></div>
       =20
        </div><div id=3D"gmail-m_-2003649318310386598yahoo_quoted_588947273=
1">
            <div style=3D"font-family:&quot;Helvetica Neue&quot;,Helvetica,=
Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
               =20
                <div>
                    On Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3=
=ADas S=C3=A1nchez &lt;<a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a>&gt; wrote:
                </div>
                <div><br></div>
                <div><br></div>
                <div><div id=3D"gmail-m_-2003649318310386598yiv7202067243">=
<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"gmail-m_-2003649318310386598yiv7202067243aqm-original" style=3D"=
color:black">

<div><div style=3D"color:black">
<p style=3D"color:black;font-size:10pt;font-family:sans-serif;margin:8pt 0p=
x">En 4 de diciembre de 2019 18:55:38 Pepe TD Vo &lt;<a href=3D"mailto:pepe=
[email protected]" target=3D"_blank">[email protected]</a>&gt; escribi=C3=B3:</p>
<div id=3D"gmail-m_-2003649318310386598yiv7202067243yqt09702"><blockquote t=
ype=3D"cite" style=3D"margin:0px 0px 0px 0.75ex;border-left:1px solid rgb(1=
28,128,128);padding-left:0.75ex">
<div style=3D"font-family:verdana,helvetica,sans-serif;font-size:16px"><div=
><div dir=3D"ltr">Hi experts,</div><div dir=3D"ltr"><br clear=3D"none"></di=
v><div dir=3D"ltr">I am trying to install Postgresql 11.1 replication maste=
r-slave.=C2=A0 The configure, make and make install went well.=C2=A0 Initdb=
 to the shared drive and psql are up and running. After configured pg_hba.c=
onf and postgresql.conf, I can&#39;t restart the service and/or reload.=C2=
=A0 Error is:</div><div dir=3D"ltr">ATHENTICATING for org.freedesktop.syste=
md1.manage-units ---</div><div dir=3D"ltr">Athentication is required to man=
age system services or units.</div><div dir=3D"ltr">authenticating as :user=
1</div><div dir=3D"ltr">Password:</div><div dir=3D"ltr">-- ATHENTICATION CO=
MPLETE --</div><div dir=3D"ltr">Failed to start psotgres-11.service: unit n=
o 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 reloa=
d the service.=C2=A0 Postgres server stopped but can&#39;t start, it compla=
ined 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 reconfigu=
re the authenticating and the server reaching out and getting authenticaion=
 from org.freedesktop.systemd1.nanage-units.=C2=A0 How can I by pass this i=
ssue 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"gma=
il-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_16_1381789=
421038_18" style=3D"background-color:inherit;color:rgb(128,0,255)">Bach-Nga=
</b><br clear=3D"none"></div><div><div id=3D"gmail-m_-2003649318310386598yi=
v7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7868"><div id=3D"gmai=
l-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_138178942=
1038_7874"><span style=3D"color:rgb(0,0,255)"><span id=3D"gmail-m_-20036493=
18310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7871"><s=
pan style=3D"color:rgb(128,0,255)"><b id=3D"gmail-m_-2003649318310386598yiv=
7202067243ydpb36af001yui_3_13_0_rc_1_16_1381789421038_18"><br clear=3D"none=
"></b>No one in this world is pure and perfect.=C2=A0 If you avoid people f=
or their mistakes you will be alone. So judge less, love and forgive more.<=
/span></span></span></div><div id=3D"gmail-m_-2003649318310386598yiv7202067=
243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7874"><span style=3D"color:rg=
b(0,0,255)"><span><span style=3D"color:rgb(128,0,255)">To call him a dog ha=
rdly 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 k=
new him well, he was a perfect gentleman (Hermione Gingold)</span></span></=
span></div><br clear=3D"none"><span id=3D"gmail-m_-2003649318310386598yiv72=
02067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7867" style=3D"color:rgb=
(128,0,255)">**Live simply **Love generously **Care deeply **Speak kindly.<=
/span></div><div id=3D"gmail-m_-2003649318310386598yiv7202067243ydpb36af001=
yui_3_13_0_rc_1_1_1381789421038_7866"><span id=3D"gmail-m_-2003649318310386=
598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7865"><span styl=
e=3D"color:rgb(128,0,255)">*** Genuinely rich *** Faithful talent *** Shari=
ng success</span></span></div></div></div></div></blockquote></div>
</div>
</div>


</div><div><br clear=3D"none"></div>
</div></div></div></div>
            </div>
        </div></div></blockquote></div>

--0000000000002c49460598e8c242--