Re: postgres service can't restart/start
Pepe TD Vo <[email protected]> Thu, 5 Dec 2019 15:31:32 +0000 (UTC)
| Newsgroups | gmane.comp.db.postgresql.pgadmin,gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_2615960_952051169.1575559892656
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
yes I do have a righ systemd service file named 'postgresql-11' and its loc=
ated /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
------=_Part_2615960_952051169.1575559892656
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div class=3D"ydp15da32bayahoo-style-wrap" style=
=3D"font-family: verdana, helvetica, sans-serif; font-size: 16px;"><div sty=
le=3D""><div dir=3D"ltr" data-setdir=3D"false" style=3D"font-family: verdan=
a, helvetica, sans-serif; font-size: 16px;"><span style=3D"font-family: Hel=
vetica Neue, Helvetica, Arial, sans-serif;">yes I do have a righ systemd se=
rvice file named 'postgresql-11' and its located /usr/lib/systemd/system/</=
span><br></div><div dir=3D"ltr" data-setdir=3D"false" style=3D"font-family:=
verdana, helvetica, sans-serif; font-size: 16px;"><span style=3D"font-fami=
ly: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></span></div><div di=
r=3D"ltr" data-setdir=3D"false" style=3D""><p class=3D"ydp826525c6MsoNormal=
" style=3D"font-family: verdana, helvetica, sans-serif; font-size: 16px;"><=
span style=3D"color:#1F497D">Here what I did so far after
make install.</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span><=
/p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">mkdir /usr/loc=
al/pgsql/log</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Run </span></p=
>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">./usr/local/pg=
sql/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"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">psql</span></p=
>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">in the psql sh=
ell</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">psql# create u=
ser replica
replication login encrypted password =E2=80=98replicauser@=E2=80=99;</span>=
</p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">psql# alter us=
er postgres
password =E2=80=98password@=E2=80=99;</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span><=
/p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">configure post=
gresql.conf:</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">port =3D 5432<=
/span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">unix_socket_di=
rectorys =3D =E2=80=99tmp=E2=80=99</span></p>
<p class=3D"ydp826525c6MsoNormal" 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"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">listen_address=
es =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"ydp826525c6MsoNormal" 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"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">max_replicatio=
n_slots =3D 10</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">archive_mode =
=3D on</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">archive_comman=
d =3D =E2=80=98cp =E2=80=93I %p
/u02/postgres/main/archive/%f=E2=80=99</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">max_wal_sender=
s =3D 10</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">wal_keep_segme=
nts =3D 64</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span><=
/p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">for pg_hba.con=
f, I added:</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">local &nb=
sp;
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"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">host
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"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">host &nbs=
p;
replication replica
192.##.##.##/32 md5 =
</span><span style=3D=
"font-family:Wingdings;color:#1F497D">=C3=A0</span><span style=3D"color:#1F=
497D"> slave-server</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span><=
/p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">$ mkdir =E2=80=
=93p
/u02/postgres/main/archive </span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">$ systemctl re=
start postgresql</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">=3D=3D=3D AUTH=
ENTICATING FOR
org.freedesktop.systemd1.manage-units =3D=3D=3D</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Autehtication =
is required to
manage system services or units.</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Authenticating=
as: sysmaint</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Password:</spa=
n></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">=3D=3D=3D AUTH=
ENTICATION COMPLETE =3D=3D=3D</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Job for postgr=
esql-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"ydp826525c6MsoNormal" 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"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Active: failed=
(Result:
exit-code) since date: time</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Process:10188
ExecStartPre=3D/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA}
(code=3Dexisted, status=3D1/FAILURE)</span></p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span><=
/p>
<p class=3D"ydp826525c6MsoNormal" style=3D""><font color=3D"#1f497d">I un-c=
ommented data_directory and
correct the path to postgresql.conf per SA suggested and still get the same
error above</font></p>
<div style=3D"font-family: verdana, helvetica, sans-serif; font-size: 16px;=
" dir=3D"ltr" data-setdir=3D"false"><span style=3D"color:#1F497D">data_dire=
ctory =3D
=E2=80=98/postgres_data/pgsql/data/=E2=80=99 --> data folder=
is on shared drive.</span></div>
<p class=3D"ydp826525c6MsoNormal" 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"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span><=
/p>
<p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica,=
sans-serif; font-size: 16px;"><span style=3D"color:#1F497D">still prompt f=
or 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: 16p=
x;"><span style=3D"color:#1F497D"><br></span></div>
<div style=3D"font-family: verdana, helvetica, sans-serif; font-size: 16px;=
" dir=3D"ltr" data-setdir=3D"false"><span style=3D"color:#1F497D">The probl=
em 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: =
verdana, helvetica, sans-serif; font-size: 16px;"><span style=3D"color:#1F4=
97D"><br></span></div><div style=3D"font-family: verdana, helvetica, sans-s=
erif; font-size: 16px;"><span style=3D"color:#1F497D">Wonder if I can remov=
e /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" data-setdir=3D"false" style=3D"font-family: verdana,=
helvetica, sans-serif; font-size: 16px;"><span style=3D"font-family: Helve=
tica Neue, Helvetica, Arial, sans-serif;"><br></span></div><div dir=3D"ltr"=
data-setdir=3D"false" style=3D"font-family: verdana, helvetica, sans-serif=
; font-size: 16px;"><span style=3D"font-family: Helvetica Neue, Helvetica, =
Arial, sans-serif;"><br></span></div><div class=3D"ydp15da32basignature" st=
yle=3D"font-family: verdana, helvetica, sans-serif; font-size: 16px;"><div =
id=3D"ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7868" class=3D"ydp15da32ba=
yiv3811552299ms__id13889"><font color=3D"#0000ff"><b><span class=3D"ydp15da=
32bayiv3811552299sg"><font color=3D"#8000ff" style=3D"background-color: inh=
erit;"></font></span></b></font><div id=3D"ydp15da32bayui_3_13_0_rc_1_1_138=
1789421038_7874" class=3D"ydp15da32bayiv3811552299ms__id13893"><font id=3D"=
ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7873" color=3D"#0000ff"><font co=
lor=3D"#8000ff"></font><span id=3D"ydp15da32bayui_3_13_0_rc_1_1_13817894210=
38_7871" class=3D"ydp15da32bayiv3811552299sg"><font id=3D"ydp15da32bayui_3_=
13_0_rc_1_1_1381789421038_7870" color=3D"#8000ff" style=3D"background-color=
: inherit;"><b id=3D"ydp15da32bayui_3_13_0_rc_1_16_1381789421038_18">Bach-N=
ga<br clear=3D"none"><br clear=3D"none"></b>No one in this world is pure an=
d 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"=
ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7874" class=3D"ydp15da32bayiv381=
1552299ms__id13893"><font color=3D"#0000ff"><span class=3D"ydp15da32bayiv38=
11552299sg"><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 Gingol=
d)</font></span></font></div><br clear=3D"none"><span style=3D"color:rgb(12=
8, 0, 255);" id=3D"ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7867">**Live =
simply **Love generously **Care deeply **Speak kindly.</span></div><div id=
=3D"ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7866" class=3D"ydp15da32bayi=
v3811552299ms__id13894"><span id=3D"ydp15da32bayui_3_13_0_rc_1_1_1381789421=
038_7865" class=3D"ydp15da32bayiv3811552299sg"><font id=3D"ydp15da32bayui_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 style=3D"font-family: verdana, helvetica, sans-serif; font-siz=
e: 16px;"><br></div><div style=3D"font-family: verdana, helvetica, sans-ser=
if; font-size: 16px;"><br></div>
=20
</div><div id=3D"yahoo_quoted_6407123130" 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, 05:59:20 PM EST, Matthe=
w Tice <[email protected]> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id=3D"yiv9127801121"><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"yiv9127801121yqt5254191273" id=3D"yiv9127801121=
yqt03130"><div class=3D"yiv9127801121gmail_quote"><div class=3D"yiv91278011=
21gmail_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"yiv9127801121gmail_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"yiv9127801121gmail-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"yiv9127801121gmail-m_-2003649318310386598ydp315=
cd216yui_3_13_0_rc_1_1_1381789421038_7874"><font id=3D"yiv9127801121gmail-m=
_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7873" color=
=3D"#0000ff"><font color=3D"#8000ff"></font><span id=3D"yiv9127801121gmail-=
m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7871"><fon=
t id=3D"yiv9127801121gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1=
_1_1381789421038_7870" color=3D"#8000ff" style=3D"background-color:inherit;=
"><b id=3D"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv9127801121gmail-m_-2003649318310386598ydp3=
15cd216yui_3_13_0_rc_1_1_1381789421038_7866"><span id=3D"yiv9127801121gmail=
-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7865"><fo=
nt id=3D"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv912780=
1121gmail-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"yiv9127801121gmail-m_-=
2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_=
7868"><div id=3D"yiv9127801121gmail-m_-2003649318310386598yiv7202067243ydpb=
36af001yui_3_13_0_rc_1_1_1381789421038_7874"><span style=3D"color:rgb(0,0,2=
55);"><span id=3D"yiv9127801121gmail-m_-2003649318310386598yiv7202067243ydp=
b36af001yui_3_13_0_rc_1_1_1381789421038_7871"><span style=3D"color:rgb(128,=
0,255);"><b id=3D"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv9127801121gmail-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"yiv9127801121gmail-m_-20036493183103=
86598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7866"><span id=
=3D"yiv9127801121gmail-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></body></html>
------=_Part_2615960_952051169.1575559892656--