Re: postgres service can't restart/start
John Scalia <[email protected]> Thu, 5 Dec 2019 10:41:26 -0500
| Newsgroups | gmane.comp.db.postgresql.pgadmin,gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
--Apple-Mail-947D6367-D888-45DD-8729-BAE6E903FFE8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable You rapidly confuse the systemd process if you manually start/stop/restart P= ostgreSQL by hand. Always use the service or systemctl command for doing any= thing. =E2=80=94 Jay Sent from my iPad > On Dec 5, 2019, at 10:31 AM, Pepe TD Vo <[email protected]> wrote: >=20 > =EF=BB=BF > yes I do have a righ systemd service file named 'postgresql-11' and its lo= cated /usr/lib/systemd/system/ >=20 > Here what I did so far after make install. >=20 > =20 >=20 > mkdir /usr/local/pgsql/log >=20 > Run >=20 > ./usr/local/pgsql/bin/pg_ctl =E2=80=93D /postgres_data/pgsql/data =E2=80=93= l /usr/local/pgsql/log/logfile start >=20 > psql >=20 > in the psql shell >=20 > psql# create user replica replication login encrypted password =E2=80=98re= plicauser@=E2=80=99; >=20 > psql# alter user postgres password =E2=80=98password@=E2=80=99; >=20 > =20 >=20 > configure postgresql.conf: >=20 > port =3D 5432 >=20 > unix_socket_directorys =3D =E2=80=99tmp=E2=80=99 >=20 > max_files_per_process =3D 1000 >=20 > listen_addresses =3D =E2=80=98localhost, 192.168.2.122 =E2=80=98 =C3=A0 (= master-server-ip) >=20 > wal_level =3D replica >=20 > max_replication_slots =3D 10 >=20 > archive_mode =3D on >=20 > archive_command =3D =E2=80=98cp =E2=80=93I %p /u02/postgres/main/archive/%= f=E2=80=99 >=20 > max_wal_senders =3D 10 >=20 > wal_keep_segments =3D 64 >=20 > =20 >=20 > for pg_hba.conf, I added: >=20 > local all postgres md5 = =C3=A0 authenticate postgres >=20 > host replication replica 192.##.##.##/32 md5 =C3= =A0 master-server >=20 > host replication replica 192.##.##.##/32 md5 =C3= =A0 slave-server >=20 > =20 >=20 > $ mkdir =E2=80=93p /u02/postgres/main/archive >=20 > $ systemctl restart postgresql >=20 > =3D=3D=3D AUTHENTICATING FOR org.freedesktop.systemd1.manage-units =3D=3D=3D= >=20 > Autehtication is required to manage system services or units. >=20 > Authenticating as: sysmaint >=20 > Password: >=20 > =3D=3D=3D AUTHENTICATION COMPLETE =3D=3D=3D >=20 > Job for postgresql-11.service failed because the control process existed w= ith error code. See =E2=80=9Csystemctl status postgresql-11.service=E2=80=9D= and =E2=80=9Cjournalctl =E2=80=93xe=E2=80=9D for details. >=20 > For the status, it complained about /usr/lib/systemd/system/postgresql-11.= service; disabled; vendor preset: disabled_ >=20 > Active: failed (Result: exit-code) since date: time >=20 > Process:10188 ExecStartPre=3D/usr/pgsql-11/bin/postgresql-11-check-db-dir $= {PGDATA} (code=3Dexisted, status=3D1/FAILURE) >=20 > =20 >=20 > I un-commented data_directory and correct the path to postgresql.conf per S= A suggested and still get the same error above >=20 > data_directory =3D =E2=80=98/postgres_data/pgsql/data/=E2=80=99 --> data= folder is on shared drive. > hba_file =3D =E2=80=98/postgres_data/pgsql/pg_hba.conf=E2=80=99 >=20 > =20 >=20 > still prompt for the user=E2=80=99s password even I am logging as postgres= os user. >=20 > the binary (postgres_home) =3D /usr/local/pgsql/ should owned by root:roo= t, right?=20 >=20 > The problem I think but not sure I am right, I found there=E2=80=99s anoth= er source on /usr/pgql-11/bin existed on the server. When the SA installed t= he 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 s= tart the postgresql service without error until the configuration of pg_hba.= conf and postgresql.conf. The restart service failed. >=20 > Wonder if I can remove /usr/pgql-11 or not but not sure which one is the c= orrected binaries. Comparing with the single node postgres server I did las= t year, the /usr/local/pgsql sounds convinced right binaries one but /usr/pg= sql-11 have more functions. >=20 >=20 > Bach-Nga >=20 > No one in this world is pure and perfect. If you avoid people for their m= istakes 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 h= ad 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 Gingo= ld) >=20 > **Live simply **Love generously **Care deeply **Speak kindly. > *** Genuinely rich *** Faithful talent *** Sharing success >=20 >=20 > On Wednesday, December 4, 2019, 05:59:20 PM EST, Matthew Tice <mjtice@gmai= l.com> wrote: >=20 >=20 > Do you have a systemd service file named `postgres-11`? If so, what are t= he contents of it and the location of the file on the file system? >=20 > 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 passwor= d logged in, even I logged in directly from postgres os user not su from roo= t 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 >=20 > No one in this world is pure and perfect. If you avoid people for their m= istakes 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 h= ad 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 Gingo= ld) >=20 > **Live simply **Love generously **Care deeply **Speak kindly. > *** Genuinely rich *** Faithful talent *** Sharing success >=20 >=20 >> On Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3=ADas S=C3=A1nchez= <[email protected]> wrote: >>=20 >>=20 >> Verify file permission is right, sometimes if you edit a conf file it cha= nges owner and access permission >>=20 >> En 4 de diciembre de 2019 18:55:38 Pepe TD Vo <[email protected]> escribi=C3= =B3: >>=20 >> Hi experts, >>=20 >> I am trying to install Postgresql 11.1 replication master-slave. The con= figure, make and make install went well. Initdb to the shared drive and psq= l are up and running. After configured pg_hba.conf and postgresql.conf, I ca= n'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. >>=20 >> I worked around and add the postgres on pg_hba.conf and using pg_ctl to r= eload the service. Postgres server stopped but can't start, it complained a= bout checkpoint_segments which I have set its to 8. >>=20 >> Working with SA to reconfigure the authenticating and the server reaching= out and getting authenticaion from org.freedesktop.systemd1.nanage-units. H= ow can I by pass this issue and bring the postgres up? >>=20 >>=20 >> Bach-Nga >>=20 >> No one in this world is pure and perfect. If you avoid people for their m= istakes 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 h= ad 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 Gingo= ld) >>=20 >> **Live simply **Love generously **Care deeply **Speak kindly. >> *** Genuinely rich *** Faithful talent *** Sharing success >=20 >=20 --Apple-Mail-947D6367-D888-45DD-8729-BAE6E903FFE8 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D= utf-8"></head><body dir=3D"auto">You rapidly confuse the systemd process if y= ou manually start/stop/restart PostgreSQL by hand. Always use the service or= systemctl command for doing anything.<div><br></div><div>=E2=80=94</div><di= v>Jay<br><br><div dir=3D"ltr">Sent from my iPad</div><div dir=3D"ltr"><br><b= lockquote type=3D"cite">On Dec 5, 2019, at 10:31 AM, Pepe TD Vo <pepevo@y= ahoo.com> wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div= dir=3D"ltr">=EF=BB=BF<div class=3D"ydp15da32bayahoo-style-wrap" style=3D"fo= nt-family: verdana, helvetica, sans-serif; font-size: 16px;"><div style=3D""= ><div dir=3D"ltr" data-setdir=3D"false" style=3D"font-family: verdana, helve= tica, sans-serif; font-size: 16px;"><span style=3D"font-family: Helvetica Ne= ue, Helvetica, Arial, sans-serif;">yes I do have a righ systemd service 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, he= lvetica, sans-serif; font-size: 16px;"><span style=3D"font-family: Helvetica= Neue, Helvetica, Arial, sans-serif;"><br></span></div><div dir=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"co= lor:#1F497D">Here what I did so far after make install.</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span></p>= <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">mkdir /usr/local/= pgsql/log</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Run </span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">./usr/local/pgsql= /bin/pg_ctl =E2=80=93D /postgres_data/pgsql/data =E2=80=93l /usr/local/pgsql/log/logfile start</spa= n></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">psql</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">in the psql shell= </span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">psql# create user= replica replication login encrypted password =E2=80=98replicauser@=E2=80=99;</span><= /p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">psql# alter user p= ostgres password =E2=80=98password@=E2=80=99;</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span></p>= <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">configure postgre= sql.conf:</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">port =3D 5432</sp= an></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">unix_socket_direc= torys =3D =E2=80=99tmp=E2=80=99</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">max_files_per_pro= cess =3D 1000</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">listen_addresses =3D= =E2=80=98localhost, 192.168.2.122 =E2=80=98 </span><span style=3D"font-family:Wingdings;co= lor:#1F497D">=C3=A0</span><span style=3D"color:#1F497D"> (master-server-ip)<= /span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">wal_level =3D rep= lica</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">max_replication_s= lots =3D 10</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">archive_mode =3D o= n</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">archive_command =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, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">max_wal_senders =3D= 10</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">wal_keep_segments= =3D 64</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span></p>= <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">for pg_hba.conf, I= added:</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">local = all postgres &n= bsp; &= nbsp; md5  = ; </span><span style=3D"font-family:Wingdings;color:#1F497D">=C3=A0</s= pan><span style=3D"color:#1F497D"> authenticate postgres</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">host replication replica 192.##.##.##/32 md5 = </span><span style=3D"font-f= amily:Wingdings;color:#1F497D">=C3=A0</span><span style=3D"color:#1F497D"> m= aster-server</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">host &= nbsp; replication replica 192.##.##.##/32 md5 &= nbsp; </span><span style=3D"f= ont-family:Wingdings;color:#1F497D">=C3=A0</span><span style=3D"color:#1F497= D"> slave-server</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span></p>= <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">$ mkdir =E2=80=93= p /u02/postgres/main/archive </span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">$ systemctl resta= rt postgresql</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">=3D=3D=3D AUTHENT= ICATING FOR org.freedesktop.systemd1.manage-units =3D=3D=3D</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Autehtication is r= equired to manage system services or units.</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Authenticating as= : sysmaint</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Password:</span><= /p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">=3D=3D=3D AUTHENT= ICATION COMPLETE =3D=3D=3D</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Job for postgresq= l-11.service failed because the control process existed with error code. See =E2=80=9Csys= temctl 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, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">For the status, i= t complained about /usr/lib/systemd/system/postgresql-11.service; disabled; vendor preset: disa= bled_</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">Active: failed (R= esult: exit-code) since date: time</span></p> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-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, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span></p>= <p class=3D"ydp826525c6MsoNormal" style=3D""><font color=3D"#1f497d">I un-co= mmented 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_direct= ory =3D =E2=80=98/postgres_data/pgsql/data/=E2=80=99 --> data folder i= s on shared drive.</span></div> <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-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, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D"> </span></p>= <p class=3D"ydp826525c6MsoNormal" style=3D"font-family: verdana, helvetica, s= ans-serif; font-size: 16px;"><span style=3D"color:#1F497D">still prompt for t= he 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></div= ><div style=3D"font-family: verdana, helvetica, sans-serif; font-size: 16px;= "><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 problem= I think but not sure I am right, I found there=E2=80=99s another source on /usr/pgql-11/bin exist= ed 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 O= S Patches updated, removed 9.6 and yum the postgresql11-11.1-1PGDG.rhel7.x86_6= 4.rpm successful, configure, make and make install and start the postgresql servic= e without error until the configuration of pg_hba.conf and postgresql.conf.&= nbsp; The restart service failed.</span></div><div style=3D"font-family: ver= dana, helvetica, sans-serif; font-size: 16px;"><span style=3D"color:#1F497D"= ><br></span></div><div style=3D"font-family: verdana, helvetica, 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 postgres= server I did last year, the /usr/local/pgsql sounds convinced right binaries= one but /usr/pgsql-11 have more functions.</span></div> </div><div dir=3D"ltr" data-setdir=3D"false" style=3D"font-family: verdana, h= elvetica, sans-serif; font-size: 16px;"><span style=3D"font-family: Helvetic= a Neue, Helvetica, Arial, sans-serif;"><br></span></div><div dir=3D"ltr" dat= a-setdir=3D"false" style=3D"font-family: verdana, helvetica, sans-serif; fon= t-size: 16px;"><span style=3D"font-family: Helvetica Neue, Helvetica, Arial,= sans-serif;"><br></span></div><div class=3D"ydp15da32basignature" style=3D"= font-family: verdana, helvetica, sans-serif; font-size: 16px;"><div id=3D"yd= p15da32bayui_3_13_0_rc_1_1_1381789421038_7868" class=3D"ydp15da32bayiv381155= 2299ms__id13889"><font color=3D"#0000ff"><b><span class=3D"ydp15da32bayiv381= 1552299sg"><font color=3D"#8000ff" style=3D"background-color: inherit;"></fo= nt></span></b></font><div id=3D"ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7= 874" class=3D"ydp15da32bayiv3811552299ms__id13893"><font id=3D"ydp15da32bayu= i_3_13_0_rc_1_1_1381789421038_7873" color=3D"#0000ff"><font color=3D"#8000ff= "></font><span id=3D"ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7871" class=3D= "ydp15da32bayiv3811552299sg"><font id=3D"ydp15da32bayui_3_13_0_rc_1_1_138178= 9421038_7870" color=3D"#8000ff" style=3D"background-color: inherit;"><b id=3D= "ydp15da32bayui_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 yo= u 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"ydp15da32bayiv3811552299ms__id13893"><font= color=3D"#0000ff"><span class=3D"ydp15da32bayiv3811552299sg"><font color=3D= "#8000ff" style=3D"background-color: inherit;">To call him a dog hardly seem= s to do him justice though in as much as he had four legs, a tail, and barke= d, I admit he was, to all outward appearances. But to those who knew him wel= l, 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"ydp15da32bay= ui_3_13_0_rc_1_1_1381789421038_7867">**Live simply **Love generously **Care d= eeply **Speak kindly.</span></div><div id=3D"ydp15da32bayui_3_13_0_rc_1_1_13= 81789421038_7866" class=3D"ydp15da32bayiv3811552299ms__id13894"><span id=3D"= ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7865" class=3D"ydp15da32bayiv3811= 552299sg"><font id=3D"ydp15da32bayui_3_13_0_rc_1_1_1381789421038_7864" color= =3D"#8000ff" style=3D"background-color: inherit;">*** Genuinely rich *** Fai= thful talent *** Sharing success</font></span></div></div></div> <div style=3D"font-family: verdana, helvetica, sans-serif; font-size= : 16px;"><br></div><div style=3D"font-family: verdana, helvetica, sans-serif= ; 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, sa= ns-serif;font-size:13px;color:#26282a;"> =20 <div> On Wednesday, December 4, 2019, 05:59:20 PM EST, Matthew= Tice <[email protected]> wrote: </div> <div><br></div> <div><br></div> <div><div id=3D"yiv9127801121"><div><div dir=3D"ltr">Do you h= ave a systemd service file named `postgres-11`? If so, what are the co= ntents of it and the location of the file on the file system?</div><br clear= =3D"none"><div class=3D"yiv9127801121yqt5254191273" id=3D"yiv9127801121yqt03= 130"><div class=3D"yiv9127801121gmail_quote"><div class=3D"yiv9127801121gmai= l_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"_blan= k" href=3D"mailto:[email protected]">[email protected]</a>> wrote:<br clear= =3D"none"></div><blockquote class=3D"yiv9127801121gmail_quote" style=3D"marg= in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex= ;"><div><div style=3D"font-family:verdana, helvetica, sans-serif;font-size:1= 6px;"><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 start up the post= gres, it prompts me for password logged in, even I logged in directly from p= ostgres os user not su from root and/or another os user.</div><div dir=3D"lt= r"><div dir=3D"ltr"><pre><code>=3D=3D=3D=3D AUTHENTICATING FOR org.freedeskt= op.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><p= re style=3D"white-space:pre-wrap;color:rgb(0,0,0);font-size:16px;"><code>Pas= sword:</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-siz= e:16px;"><code>Failed to start postgres-11.service: unit not found</code></p= re><pre style=3D"white-space:pre-wrap;color:rgb(0,0,0);font-size:16px;">SA w= orked around with me and still can't start the postgresql service.</pre></di= v></div><div><div id=3D"yiv9127801121gmail-m_-2003649318310386598ydp315cd216= yui_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></f= ont><div id=3D"yiv9127801121gmail-m_-2003649318310386598ydp315cd216yui_3_13_= 0_rc_1_1_1381789421038_7874"><font id=3D"yiv9127801121gmail-m_-2003649318310= 386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7873" color=3D"#0000ff"><fo= nt color=3D"#8000ff"></font><span id=3D"yiv9127801121gmail-m_-20036493183103= 86598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7871"><font id=3D"yiv9127801= 121gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_78= 70" color=3D"#8000ff" style=3D"background-color:inherit;"><b id=3D"yiv912780= 1121gmail-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 i= s 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"yiv9127801121gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1= _1381789421038_7874"><font color=3D"#0000ff"><span><font color=3D"#8000ff" s= tyle=3D"background-color:inherit;">To call him a dog hardly seems to do him j= ustice 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 p= erfect gentleman (Hermione Gingold)</font></span></font></div><br clear=3D"n= one"><span id=3D"yiv9127801121gmail-m_-2003649318310386598ydp315cd216yui_3_1= 3_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"yiv9= 127801121gmail-m_-2003649318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421= 038_7866"><span id=3D"yiv9127801121gmail-m_-2003649318310386598ydp315cd216yu= i_3_13_0_rc_1_1_1381789421038_7865"><font id=3D"yiv9127801121gmail-m_-200364= 9318310386598ydp315cd216yui_3_13_0_rc_1_1_1381789421038_7864" color=3D"#8000= ff" style=3D"background-color:inherit;">*** Genuinely rich *** Faithful tale= nt *** 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_quot= ed_5889472731"> <div style=3D""> =20 <div> On Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3=AD= as S=C3=A1nchez <<a rel=3D"nofollow" shape=3D"rect" ymailto=3D"mailto:isa= [email protected]" target=3D"_blank" href=3D"mailto:isaias.sanchez.l@g= mail.com">[email protected]</a>> wrote: </div> <div><br clear=3D"none"></div> <div><br clear=3D"none"></div> <div><div id=3D"yiv9127801121gmail-m_-2003649318310386598yiv= 7202067243"><div> <div> <div>Verify file permission is right, sometimes if you edit a conf file it c= hanges owner and access permission</div><div><br clear=3D"none"></div> <div id=3D"yiv9127801121gmail-m_-2003649318310386598yiv7202067243aqm-origina= l" style=3D"color:black;"> <div><div style=3D"color:black;"> <p style=3D"color:black;font-size:10pt;font-family:sans-serif;margin:8pt 0px= ;">En 4 de diciembre de 2019 18:55:38 Pepe TD Vo <<a rel=3D"nofollow" sha= pe=3D"rect" ymailto=3D"mailto:[email protected]" target=3D"_blank" href=3D"ma= ilto:[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:1px s= olid rgb(128,128,128);padding-left:0.75ex;"> <div style=3D"font-family:verdana, helvetica, sans-serif;font-size:16px;"><d= iv><div dir=3D"ltr">Hi experts,</div><div dir=3D"ltr"><br clear=3D"none"></d= iv><div dir=3D"ltr">I am trying to install Postgresql 11.1 replication maste= r-slave. The configure, make and make install went well. Initdb t= o the shared drive and psql are up and running. After configured pg_hba.conf= and postgresql.conf, I can't restart the service and/or reload. Error= is:</div><div dir=3D"ltr">ATHENTICATING for org.freedesktop.systemd1.manage= -units ---</div><div dir=3D"ltr">Athentication is required to manage system s= ervices or units.</div><div dir=3D"ltr">authenticating as :user1</div><div d= ir=3D"ltr">Password:</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 an= d add the postgres on pg_hba.conf and using pg_ctl to reload the service.&nb= sp; Postgres 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 an= d the server reaching out and getting authenticaion from org.freedesktop.sys= temd1.nanage-units. How can I by pass this issue and bring the postgre= s up?</div><div dir=3D"ltr"><br clear=3D"none"></div><div dir=3D"ltr"><br cl= ear=3D"none"></div><div dir=3D"ltr"><b id=3D"yiv9127801121gmail-m_-200364931= 8310386598yiv7202067243ydpb36af001yui_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_-2003649318310386598yiv720= 2067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7868"><div id=3D"yiv912780= 1121gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_13= 81789421038_7874"><span style=3D"color:rgb(0,0,255);"><span id=3D"yiv9127801= 121gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_138= 1789421038_7871"><span style=3D"color:rgb(128,0,255);"><b id=3D"yiv912780112= 1gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_16_1381= 789421038_18"><br clear=3D"none"></b>No one in this world is pure and perfec= t. If you avoid people for their mistakes you will be alone. So judge l= ess, love and forgive more.</span></span></span></div><div id=3D"yiv91278011= 21gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_1381= 789421038_7874"><span style=3D"color:rgb(0,0,255);"><span><span style=3D"col= or:rgb(128,0,255);">To call him a dog hardly seems to do him justice though i= n as much as he had four legs, a tail, and barked, I admit he was, to all ou= tward appearances. But to those who knew him well, he was a perfect gentlema= n (Hermione Gingold)</span></span></span></div><br clear=3D"none"><span id=3D= "yiv9127801121gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_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"yiv9127= 801121gmail-m_-2003649318310386598yiv7202067243ydpb36af001yui_3_13_0_rc_1_1_= 1381789421038_7866"><span id=3D"yiv9127801121gmail-m_-2003649318310386598yiv= 7202067243ydpb36af001yui_3_13_0_rc_1_1_1381789421038_7865"><span style=3D"co= lor:rgb(128,0,255);">*** Genuinely rich *** Faithful talent *** Sharing succ= ess</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></body></html>= --Apple-Mail-947D6367-D888-45DD-8729-BAE6E903FFE8--