Re: postgres service can't restart/start
Pepe TD Vo <[email protected]> Thu, 5 Dec 2019 15:49:09 +0000 (UTC)
| Newsgroups | gmane.comp.db.postgresql.admin,gmane.comp.db.postgresql.pgadmin |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_6125456_885936243.1575560949721
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
the restart doesn't work.=C2=A0 I worked around and using pg_ctl to reload.=
Service stopped and can't start up the service (pg_ctl: could not start se=
rver).=C2=A0 Even start with postgresql-11 with and/out .service.systemctl =
restart postgresql-11
systemctl restart postgresql-11.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 Thursday, December 5, 2019, 10:41:57 AM EST, John Scalia <jayknowsun=
[email protected]> wrote: =20
=20
You rapidly confuse the systemd process if you manually start/stop/restart=
PostgreSQL by hand. Always use the service or systemctl command for doing =
anything.
=E2=80=94Jay
Sent from my iPad
On Dec 5, 2019, at 10:31 AM, Pepe TD Vo <[email protected]> wrote:
=EF=BB=BFyes I do have a righ systemd service file named 'postgresql-11' an=
d its located /usr/lib/systemd/system/
Here what I did so far aftermake install.
=C2=A0
mkdir /usr/local/pgsql/log
Run=20
./usr/local/pgsql/bin/pg_ctl =E2=80=93D/postgres_data/pgsql/data =E2=80=93l=
/usr/local/pgsql/log/logfile start
psql
in the psql shell
psql# create user replicareplication login encrypted password =E2=80=98repl=
icauser@=E2=80=99;
psql# alter user postgrespassword =E2=80=98password@=E2=80=99;
=C2=A0
configure postgresql.conf:
port =3D 5432
unix_socket_directorys =3D =E2=80=99tmp=E2=80=99
max_files_per_process =3D 1000
listen_addresses =3D =E2=80=98localhost,192.168.2.122 =E2=80=98=C2=A0 =C3=
=A0 (master-server-ip)
wal_level =3D replica
max_replication_slots =3D 10
archive_mode =3D on
archive_command =3D =E2=80=98cp =E2=80=93I %p/u02/postgres/main/archive/%f=
=E2=80=99
max_wal_senders =3D 10
wal_keep_segments =3D 64
=C2=A0
for pg_hba.conf, I added:
local=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 postgres=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0md5=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=C3=A0 authenticate pos=
tgres
host=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 replication=C2=A0 replica=C2=A0=C2=A0192=
.##.##.##/32=C2=A0 =C2=A0 =C2=A0 md5=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C3=A0 master-server
host=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0replication=C2=A0 replica=C2=A0=C2=
=A0192.##.##.##/32=C2=A0 =C2=A0 =C2=A0 md5=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C3=A0 slave-serve=
r
=C2=A0
$ mkdir =E2=80=93p/u02/postgres/main/archive=20
$ systemctl restart postgresql
=3D=3D=3D AUTHENTICATING FORorg.freedesktop.systemd1.manage-units =3D=3D=3D
Autehtication is required tomanage system services or units.
Authenticating as: sysmaint
Password:
=3D=3D=3D AUTHENTICATION COMPLETE =3D=3D=3D
Job for postgresql-11.servicefailed because the control process existed wit=
h error code. See =E2=80=9Csystemctlstatus postgresql-11.service=E2=80=9D a=
nd =E2=80=9Cjournalctl =E2=80=93xe=E2=80=9D for details.
For the status, it complained about/usr/lib/systemd/system/postgresql-11.se=
rvice; disabled; vendor preset: disabled_
Active: failed (Result:exit-code) since date: time
Process:10188ExecStartPre=3D/usr/pgsql-11/bin/postgresql-11-check-db-dir ${=
PGDATA}(code=3Dexisted, status=3D1/FAILURE)
=C2=A0
I un-commented=C2=A0data_directory andcorrect the path to postgresql.conf p=
er SA suggested and still get the sameerror above
data_directory =3D=E2=80=98/postgres_data/pgsql/data/=E2=80=99=C2=A0 =C2=A0=
--> data folder is on shared drive.
hba_file =3D=E2=80=98/postgres_data/pgsql/pg_hba.conf=E2=80=99
=C2=A0
still prompt for the user=E2=80=99spassword even I am logging as postgres o=
s user.
the binary (postgres_home) =3D/usr/local/pgsql/=C2=A0 should owned by root:=
root, right?=C2=A0=20
The problem I think but not sureI am right, I found there=E2=80=99s another=
source on /usr/pgql-11/bin existed on theserver.=C2=A0 When the SA install=
ed the OS Patch, the server hadpostgres-9.6.=C2=A0 I can run any date for P=
ostgresql 11.=C2=A0 He applied OSPatches updated, removed 9.6 and yum the p=
ostgresql11-11.1-1PGDG.rhel7.x86_64.rpmsuccessful, configure, make and make=
install and start the postgresql service without error until the configura=
tion of pg_hba.conf and postgresql.conf.=C2=A0 The restart service failed.
Wonder if I can remove /usr/pgql-11 or not but not sure whichone is the cor=
rected binaries.=C2=A0 Comparing with the single node postgresserver I did =
last year, the /usr/local/pgsql sounds convinced right binariesone but /usr=
/pgsql-11 have more functions.
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, 05:59:20 PM EST, Matthew Tice <mjtice@g=
mail.com> wrote: =20
=20
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?
On Wed, Dec 4, 2019 at 1:39 PM Pepe TD Vo <[email protected]> wrote:
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
=20
=20
------=_Part_6125456_885936243.1575560949721
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div class=3D"ydp94a3e34yahoo-style-wrap" style=3D=
"font-family:verdana, helvetica, sans-serif;font-size:16px;"><div><div dir=
=3D"ltr" data-setdir=3D"false">the restart doesn't work. I worked aro=
und and using pg_ctl to reload. Service stopped and can't start up the serv=
ice (pg_ctl: could not start server). Even start with postgresql-11 w=
ith and/out .service.</div><div dir=3D"ltr" data-setdir=3D"false"><span><sp=
an style=3D"color: rgb(31, 73, 125); font-family: verdana, helvetica, sans-=
serif; font-size: 16px;">systemctl restart postgresql-11</span></span><br><=
/div><div dir=3D"ltr" data-setdir=3D"false"><span><span style=3D"color: rgb=
(31, 73, 125); font-family: verdana, helvetica, sans-serif; font-size: 16px=
;">systemctl restart postgresql-11.service</span></span><br></div><div><br>=
</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div class=3D"ydp94a=
3e34signature"><div id=3D"ydp94a3e34yui_3_13_0_rc_1_1_1381789421038_7868" c=
lass=3D"ydp94a3e34yiv3811552299ms__id13889"><font color=3D"#0000ff"><b><spa=
n class=3D"ydp94a3e34yiv3811552299sg"><font color=3D"#8000ff" style=3D"back=
ground-color: inherit;"></font></span></b></font><div id=3D"ydp94a3e34yui_3=
_13_0_rc_1_1_1381789421038_7874" class=3D"ydp94a3e34yiv3811552299ms__id1389=
3"><font id=3D"ydp94a3e34yui_3_13_0_rc_1_1_1381789421038_7873" color=3D"#00=
00ff"><font color=3D"#8000ff"></font><span id=3D"ydp94a3e34yui_3_13_0_rc_1_=
1_1381789421038_7871" class=3D"ydp94a3e34yiv3811552299sg"><font id=3D"ydp94=
a3e34yui_3_13_0_rc_1_1_1381789421038_7870" color=3D"#8000ff" style=3D"backg=
round-color: inherit;"><b id=3D"ydp94a3e34yui_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. If you avoid people for their mistakes you will =
be alone. So judge less, love and forgive more.</font></span></font></div><=
div id=3D"ydp94a3e34yui_3_13_0_rc_1_1_1381789421038_7874" class=3D"ydp94a3e=
34yiv3811552299ms__id13893"><font color=3D"#0000ff"><span class=3D"ydp94a3e=
34yiv3811552299sg"><font color=3D"#8000ff" style=3D"background-color: inher=
it;">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 appear=
ances. 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"ydp94a3e34yui_3_13_0_rc_1_1_1381789421038_7867">*=
*Live simply **Love generously **Care deeply **Speak kindly.</span></div><d=
iv id=3D"ydp94a3e34yui_3_13_0_rc_1_1_1381789421038_7866" class=3D"ydp94a3e3=
4yiv3811552299ms__id13894"><span id=3D"ydp94a3e34yui_3_13_0_rc_1_1_13817894=
21038_7865" class=3D"ydp94a3e34yiv3811552299sg"><font id=3D"ydp94a3e34yui_3=
_13_0_rc_1_1_1381789421038_7864" color=3D"#8000ff" style=3D"background-colo=
r: inherit;">*** Genuinely rich *** Faithful talent *** Sharing success</fo=
nt></span></div></div></div>
<div><br></div><div><br></div>
=20
</div><div id=3D"yahoo_quoted_6417792069" class=3D"yahoo_quoted">
<div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
=20
<div>
On Thursday, December 5, 2019, 10:41:57 AM EST, John Sc=
alia <[email protected]> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id=3D"yiv1424193094"><div>You rapidly confuse the=
systemd process if you manually start/stop/restart PostgreSQL by hand. Alw=
ays use the service or systemctl command for doing anything.<div><br clear=
=3D"none"></div><div>=E2=80=94</div><div>Jay<br clear=3D"none"><br clear=3D=
"none"><div dir=3D"ltr">Sent from my iPad</div><div dir=3D"ltr"><div class=
=3D"yiv1424193094yqt3650275779" id=3D"yiv1424193094yqtfd17629"><br clear=3D=
"none"><blockquote type=3D"cite">On Dec 5, 2019, at 10:31 AM, Pepe TD Vo &l=
t;[email protected]> wrote:<br clear=3D"none"><br clear=3D"none"></blockq=
uote></div></div><div class=3D"yiv1424193094yqt3650275779" id=3D"yiv1424193=
094yqtfd97883"><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div cla=
ss=3D"yiv1424193094ydp15da32bayahoo-style-wrap" style=3D"font-family:verdan=
a, helvetica, sans-serif;font-size:16px;"><div style=3D""><div dir=3D"ltr" =
style=3D"font-family:verdana, helvetica, sans-serif;font-size:16px;"><span =
style=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">yes I d=
o have a righ systemd service file named 'postgresql-11' and its located /u=
sr/lib/systemd/system/</span><br clear=3D"none"></div><div dir=3D"ltr" styl=
e=3D"font-family:verdana, helvetica, sans-serif;font-size:16px;"><span styl=
e=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear=
=3D"none"></span></div><div dir=3D"ltr" style=3D""><p class=3D"yiv142419309=
4ydp826525c6MsoNormal" style=3D"font-family:verdana, helvetica, sans-serif;=
font-size:16px;"><span style=3D"color:#1F497D;">Here what I did so far afte=
r
make install.</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">&nb=
sp;</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">mkd=
ir /usr/local/pgsql/log</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Run=
</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">./u=
sr/local/pgsql/bin/pg_ctl =E2=80=93D
/postgres_data/pgsql/data =E2=80=93l /usr/local/pgsql/log/logfile start</sp=
an></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">psq=
l</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">in =
the psql shell</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">psq=
l# create user replica
replication login encrypted password =E2=80=98replicauser@=E2=80=99;</span>=
</p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">psq=
l# alter user postgres
password =E2=80=98password@=E2=80=99;</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">&nb=
sp;</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">con=
figure postgresql.conf:</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">por=
t =3D 5432</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">uni=
x_socket_directorys =3D =E2=80=99tmp=E2=80=99</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">max=
_files_per_process =3D 1000</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">lis=
ten_addresses =3D =E2=80=98localhost,
192.168.2.122 =E2=80=98 </span><span style=3D"font-family:Wingdings;c=
olor:#1F497D;">=C3=A0</span><span style=3D"color:#1F497D;"> (master-server-=
ip)</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">wal=
_level =3D replica</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">max=
_replication_slots =3D 10</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">arc=
hive_mode =3D on</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">arc=
hive_command =3D =E2=80=98cp =E2=80=93I %p
/u02/postgres/main/archive/%f=E2=80=99</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">max=
_wal_senders =3D 10</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">wal=
_keep_segments =3D 64</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">&nb=
sp;</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">for=
pg_hba.conf, I added:</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">loc=
al
all postgres &=
nbsp; =
md5 &n=
bsp; </span><span style=3D"font-family:Wingdings;color:#1F497D;">=C3=
=A0</span><span style=3D"color:#1F497D;"> authenticate postgres</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">hos=
t
replication replica
192.##.##.##/32 md5  =
; </span><span style=3D"font=
-family:Wingdings;color:#1F497D;">=C3=A0</span><span style=3D"color:#1F497D=
;"> master-server</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">hos=
t
replication replica
192.##.##.##/32 md5 =
</span><span style=3D=
"font-family:Wingdings;color:#1F497D;">=C3=A0</span><span style=3D"color:#1=
F497D;"> slave-server</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">&nb=
sp;</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">$ m=
kdir =E2=80=93p
/u02/postgres/main/archive </span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">$ s=
ystemctl restart postgresql</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">=3D=
=3D=3D AUTHENTICATING FOR
org.freedesktop.systemd1.manage-units =3D=3D=3D</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Aut=
ehtication is required to
manage system services or units.</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Aut=
henticating as: sysmaint</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Pas=
sword:</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">=3D=
=3D=3D AUTHENTICATION COMPLETE =3D=3D=3D</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Job=
for postgresql-11.service
failed because the control process existed with error code. See =E2=80=9Csy=
stemctl
status postgresql-11.service=E2=80=9D and =E2=80=9Cjournalctl =E2=80=93xe=
=E2=80=9D for details.</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">For=
the status, it complained about
/usr/lib/systemd/system/postgresql-11.service; disabled; vendor preset: dis=
abled_</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Act=
ive: failed (Result:
exit-code) since date: time</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Pro=
cess:10188
ExecStartPre=3D/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA}
(code=3Dexisted, status=3D1/FAILURE)</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">&nb=
sp;</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D""><font color=3D"#1=
f497d">I un-commented data_directory and
correct the path to postgresql.conf per SA suggested and still get the same
error above</font></p>
<div dir=3D"ltr" style=3D"font-family:verdana, helvetica, sans-serif;font-s=
ize:16px;"><span style=3D"color:#1F497D;">data_directory =3D
=E2=80=98/postgres_data/pgsql/data/=E2=80=99 --> data folder=
is on shared drive.</span></div>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">hba=
_file =3D
=E2=80=98/postgres_data/pgsql/pg_hba.conf=E2=80=99</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">&nb=
sp;</span></p>
<p class=3D"yiv1424193094ydp826525c6MsoNormal" style=3D"font-family:verdana=
, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">sti=
ll prompt for the user=E2=80=99s
password even I am logging as postgres os user.</span></p>
<div style=3D"font-family:verdana, helvetica, sans-serif;font-size:16px;"><=
span style=3D"color:#1F497D;">the binary (postgres_home) =3D
/usr/local/pgsql/ should owned by root:root, right? </span></di=
v><div style=3D"font-family:verdana, helvetica, sans-serif;font-size:16px;"=
><span style=3D"color:#1F497D;"><br clear=3D"none"></span></div>
<div dir=3D"ltr" style=3D"font-family:verdana, helvetica, sans-serif;font-s=
ize:16px;"><span style=3D"color:#1F497D;">The problem I think but not sure
I am right, I found there=E2=80=99s another source on /usr/pgql-11/bin exis=
ted on the
server. When the SA installed the OS Patch, the server had
postgres-9.6. I can run any date for Postgresql 11. He applied =
OS
Patches updated, removed 9.6 and yum the postgresql11-11.1-1PGDG.rhel7.x86_=
64.rpm
successful, configure, make and make install and start the postgresql servi=
ce without error until the configuration of pg_hba.conf and postgresql.conf=
. The restart service failed.</span></div><div style=3D"font-family:v=
erdana, helvetica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D=
;"><br clear=3D"none"></span></div><div style=3D"font-family:verdana, helve=
tica, sans-serif;font-size:16px;"><span style=3D"color:#1F497D;">Wonder if =
I can remove /usr/pgql-11 or not but not sure which
one is the corrected binaries. Comparing with the single node postgre=
s
server I did last year, the /usr/local/pgsql sounds convinced right binarie=
s
one but /usr/pgsql-11 have more functions.</span></div>
</div><div dir=3D"ltr" style=3D"font-family:verdana, helvetica, sans-serif;=
font-size:16px;"><span style=3D"font-family:Helvetica Neue, Helvetica, Aria=
l, sans-serif;"><br clear=3D"none"></span></div><div dir=3D"ltr" style=3D"f=
ont-family:verdana, helvetica, sans-serif;font-size:16px;"><span style=3D"f=
ont-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear=3D"none=
"></span></div><div class=3D"yiv1424193094ydp15da32basignature" style=3D"fo=
nt-family:verdana, helvetica, sans-serif;font-size:16px;"><div class=3D"yiv=
1424193094ydp15da32bayiv3811552299ms__id13889" id=3D"yiv1424193094ydp15da32=
bayui_3_13_0_rc_1_1_1381789421038_7868"><font color=3D"#0000ff"><b><span cl=
ass=3D"yiv1424193094ydp15da32bayiv3811552299sg"><font color=3D"#8000ff" sty=
le=3D"background-color:inherit;"></font></span></b></font><div class=3D"yiv=
1424193094ydp15da32bayiv3811552299ms__id13893" id=3D"yiv1424193094ydp15da32=
bayui_3_13_0_rc_1_1_1381789421038_7874"><font id=3D"yiv1424193094ydp15da32b=
ayui_3_13_0_rc_1_1_1381789421038_7873" color=3D"#0000ff"><font color=3D"#80=
00ff"></font><span class=3D"yiv1424193094ydp15da32bayiv3811552299sg" id=3D"=
yiv1424193094ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7871"><font id=3D"y=
iv1424193094ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7870" color=3D"#8000=
ff" style=3D"background-color:inherit;"><b id=3D"yiv1424193094ydp15da32bayu=
i_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. If you avoid peop=
le for their mistakes you will be alone. So judge less, love and forgive mo=
re.</font></span></font></div><div class=3D"yiv1424193094ydp15da32bayiv3811=
552299ms__id13893" id=3D"yiv1424193094ydp15da32bayui_3_13_0_rc_1_1_13817894=
21038_7874"><font color=3D"#0000ff"><span class=3D"yiv1424193094ydp15da32ba=
yiv3811552299sg"><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 legs, a tail, and barked, I admit he was, to all outward appearanc=
es. But to those who knew him well, he was a perfect gentleman (Hermione Gi=
ngold)</font></span></font></div><br clear=3D"none"><span id=3D"yiv14241930=
94ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7867" style=3D"color:rgb(128, =
0, 255);">**Live simply **Love generously **Care deeply **Speak kindly.</sp=
an></div><div class=3D"yiv1424193094ydp15da32bayiv3811552299ms__id13894" id=
=3D"yiv1424193094ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7866"><span cla=
ss=3D"yiv1424193094ydp15da32bayiv3811552299sg" id=3D"yiv1424193094ydp15da32=
bayui_3_13_0_rc_1_1_1381789421038_7865"><font id=3D"yiv1424193094ydp15da32b=
ayui_3_13_0_rc_1_1_1381789421038_7864" color=3D"#8000ff" style=3D"backgroun=
d-color:inherit;">*** Genuinely rich *** Faithful talent *** Sharing succes=
s</font></span></div></div></div>
<div style=3D"font-family:verdana, helvetica, sans-serif;font-size:=
16px;"><br clear=3D"none"></div><div style=3D"font-family:verdana, helvetic=
a, sans-serif;font-size:16px;"><br clear=3D"none"></div>
=20
</div><div class=3D"yiv1424193094yahoo_quoted" id=3D"yiv1424193094y=
ahoo_quoted_6407123130">
<div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
=20
<div>
On Wednesday, December 4, 2019, 05:59:20 PM EST, Matthe=
w Tice <[email protected]> wrote:
</div>
<div><br clear=3D"none"></div>
<div><br clear=3D"none"></div>
<div><div id=3D"yiv1424193094"><div><div dir=3D"ltr">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?</div><br c=
lear=3D"none"><div class=3D"yiv1424193094yqt5254191273" id=3D"yiv1424193094=
yqt03130"><div class=3D"yiv1424193094gmail_quote"><div class=3D"yiv14241930=
94gmail_attr" dir=3D"ltr">On Wed, Dec 4, 2019 at 1:39 PM Pepe TD Vo <<a =
rel=3D"nofollow" shape=3D"rect" ymailto=3D"mailto:[email protected]" target=
=3D"_blank" href=3D"mailto:[email protected]">[email protected]</a>> wrote=
:<br clear=3D"none"></div><blockquote class=3D"yiv1424193094gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex;"><div><div style=3D"font-family:verdana, helvetica, sans-seri=
f;font-size:16px;"><div><div dir=3D"ltr">the permission and owner are right=
. to add the authentication into the pg_hba.conf but when I try to st=
art 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 another os user.</d=
iv><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></span></code></pre><=
pre style=3D"white-space:pre-wrap;color:rgb(0,0,0);font-size:16px;"><code>P=
assword:</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);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:16=
px;">SA worked around with me and still can't start the postgresql service.=
</pre></div></div><div><div id=3D"yiv1424193094gmail-m_-2003649318310386598=
ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7868"><font color=3D"#0000ff"><b=
><span><font color=3D"#8000ff" style=3D"background-color:inherit;"></font><=
/span></b></font><div id=3D"yiv1424193094gmail-m_-2003649318310386598ydp315=
cd216yui_3_13_0_rc_1_1_1381789421038_7874"><font id=3D"yiv1424193094gmail-m=
_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7873" color=
=3D"#0000ff"><font color=3D"#8000ff"></font><span id=3D"yiv1424193094gmail-=
m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7871"><fon=
t id=3D"yiv1424193094gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1=
_1_1381789421038_7870" color=3D"#8000ff" style=3D"background-color:inherit;=
"><b id=3D"yiv1424193094gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_r=
c_1_16_1381789421038_18">Bach-Nga<br clear=3D"none"><br clear=3D"none"></b>=
No one in this world is pure and perfect. If you avoid people for the=
ir mistakes you will be alone. So judge less, love and forgive more.</font>=
</span></font></div><div id=3D"yiv1424193094gmail-m_-2003649318310386598ydp=
315cd216yui_3_13_0_rc_1_1_1381789421038_7874"><font color=3D"#0000ff"><span=
><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 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></s=
pan></font></div><br clear=3D"none"><span id=3D"yiv1424193094gmail-m_-20036=
49318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7867" style=3D"col=
or:rgb(128,0,255);">**Live simply **Love generously **Care deeply **Speak k=
indly.</span></div><div id=3D"yiv1424193094gmail-m_-2003649318310386598ydp3=
15cd216yui_3_13_0_rc_1_1_1381789421038_7866"><span id=3D"yiv1424193094gmail=
-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7865"><fo=
nt id=3D"yiv1424193094gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_=
1_1_1381789421038_7864" color=3D"#8000ff" style=3D"background-color:inherit=
;">*** Genuinely rich *** Faithful talent *** Sharing success</font></span>=
</div></div></div>
<div><br clear=3D"none"></div><div><br clear=3D"none"></div>
=20
</div><div id=3D"yiv1424193094gmail-m_-2003649318310386598yahoo_quo=
ted_5889472731">
<div style=3D"">
=20
<div>
On Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3=
=ADas S=C3=A1nchez <<a rel=3D"nofollow" shape=3D"rect" ymailto=3D"mailto=
:[email protected]" target=3D"_blank" href=3D"mailto:isaias.sanche=
[email protected]">[email protected]</a>> wrote:
</div>
<div><br clear=3D"none"></div>
<div><br clear=3D"none"></div>
<div><div id=3D"yiv1424193094gmail-m_-2003649318310386598yi=
v7202067243"><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"yiv1424193094gmail-m_-2003649318310386598yiv7202067243aqm-origin=
al" 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 <<a rel=3D"nofollow" s=
hape=3D"rect" ymailto=3D"mailto:[email protected]" target=3D"_blank" href=3D=
"mailto:[email protected]">[email protected]</a>> escribi=C3=B3:</p>
<div id=3D"yiv1424193094gmail-m_-2003649318310386598yiv7202067243yqt09702">=
<blockquote type=3D"cite" style=3D"margin:0px 0px 0px 0.75ex;border-left:1p=
x solid rgb(128,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"><=
/div><div dir=3D"ltr">I am trying to install Postgresql 11.1 replication ma=
ster-slave. The configure, make and make install went well. Ini=
tdb to the shared drive and psql are up and running. After configured pg_hb=
a.conf and postgresql.conf, I can't restart the service and/or reload. =
; Error is:</div><div dir=3D"ltr">ATHENTICATING for org.freedesktop.systemd=
1.manage-units ---</div><div dir=3D"ltr">Athentication is required to manag=
e system services or units.</div><div dir=3D"ltr">authenticating as :user1<=
/div><div dir=3D"ltr">Password:</div><div dir=3D"ltr">-- ATHENTICATION COMP=
LETE --</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 wo=
rked 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 a=
bout 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 a=
nd bring the postgres up?</div><div dir=3D"ltr"><br clear=3D"none"></div><d=
iv dir=3D"ltr"><br clear=3D"none"></div><div dir=3D"ltr"><b id=3D"yiv142419=
3094gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_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><div id=3D"yiv1424193094gmail-m_-=
2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_=
7868"><div id=3D"yiv1424193094gmail-m_-2003649318310386598yiv7202067243ydpb=
36af001yui_3_13_0_rc_1_1_1381789421038_7874"><span style=3D"color:rgb(0,0,2=
55);"><span id=3D"yiv1424193094gmail-m_-2003649318310386598yiv7202067243ydp=
b36af001yui_3_13_0_rc_1_1_1381789421038_7871"><span style=3D"color:rgb(128,=
0,255);"><b id=3D"yiv1424193094gmail-m_-2003649318310386598yiv7202067243ydp=
b36af001yui_3_13_0_rc_1_16_1381789421038_18"><br clear=3D"none"></b>No one =
in this world is pure and perfect. If you avoid people for their mist=
akes you will be alone. So judge less, love and forgive more.</span></span>=
</span></div><div id=3D"yiv1424193094gmail-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 =
hardly seems to do him justice though in as much as he had four legs, a tai=
l, and barked, I admit 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 clear=3D"none"><span id=3D"yiv1424193094gmail-m_-200364931=
8310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7867" sty=
le=3D"color:rgb(128,0,255);">**Live simply **Love generously **Care deeply =
**Speak kindly.</span></div><div id=3D"yiv1424193094gmail-m_-20036493183103=
86598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7866"><span id=
=3D"yiv1424193094gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_=
13_0_rc_1_1_1381789421038_7865"><span style=3D"color:rgb(128,0,255);">*** G=
enuinely 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></div></blockquote></div></div></div></div></div>
</div>
</div></div></blockquote></div></div></div></div></div>
</div>
</div></body></html>
------=_Part_6125456_885936243.1575560949721--