Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ictNm-0005Tm-Vf for pgsql-admin@arkaria.postgresql.org; Thu, 05 Dec 2019 15:49:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ictNl-0005wm-It for pgsql-admin@arkaria.postgresql.org; Thu, 05 Dec 2019 15:49:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ictNk-0005wd-SA for pgsql-admin@lists.postgresql.org; Thu, 05 Dec 2019 15:49:33 +0000 Received: from sonic303-2.consmr.mail.bf2.yahoo.com ([74.6.131.41]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ictNd-0004rJ-4b for pgsql-admin@postgresql.org; Thu, 05 Dec 2019 15:49:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1575560963; bh=NStj6LE9whlQ+/jk6AAqZLZreSqw9p02IvXgR7Xy050=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=h7Gk/4M1gj9ZvWybpZuMW04ekVOhx+V+IlYNHz/EMIdUjwKbcHPTon/wOY75GvnCfr8s8fGwEt4VDvt98EDVBeZLqQMbIxp0BWjfognwlBp5U8uPhDZQFH7g5wkUiH8vwjyer/Z5Pewsxp104hGAe0zTH6W69dnrnC+MbK7JvgfFsDMGPfX9knVMj7e6m2rxQLDTY5Bsz4z9Izlpi/FDvXHWIEqurO1IFn+Fwd/22iqeMw+m2qoRfidQt5bWOZBp/Xx9gC1JY0WB7AdhXwIL2yZEuLNiIipM1QJcMIwkQl0kD9bEA7IUjAasfDGYm7bIvo86BHCK3SXU/Txi4AGZIg== X-YMail-OSG: RQh6UFoVM1mXEuqUGWoGo8Pob9yLmphKoeldsVeq.A.9FfGk8jCLfhBXo8cjumP .vW1x1DXI.YX0pBO8saxmYV8Mf_azJZVYQ8buo8XAYdz33mDYvdx6qkjaF_Rw6HGsG6JlGXEy2cL xBvOtWqEP8l.xLKCsk4SHPHAqiArVGwEIHLUPaulpUHpCrFClnvVqHSA8nIBhrWvUrmou_m7CAHf KTlr8ro7M1NPQimWRH5Yt2i1Ats_9Jss6eN41HpLBUtW8vsjtwMpkdH0RY41YKdcAkrJrsKX33b6 3lnitx6T1RlRo433LGg7LUhj.ZP7Gkzw_oz3GH_nPmPRKPQ_8VIsAo__8jIPYn1v7y2hVMfOsCfm h_s4HT5UHHqfGk11OtgEOD0VGWC6pvjX92tH6OAeeW1Ptg.cTq3qMQo7rQB4fHTwJq.FEBMqH.C_ XUVKWfVrx1QbljJFWnuEpMmg6AMwSE7OPwwqFZ3jQpdl5tqaeRO4V9zG74TceL2rJqh9f5bHqU2x HQVvvE8jHQ76xxJmdm0w_Nj8rJYYqpTGfk1gchcoKey0r_pkFq8o4J0SpnJGWOI8GwNXK.jG8nm9 ycvKzffx_TG3i._JqBivXPmRw4g.gOMJ759ashGMupIRDFb9Vp60k90sT3ZKrDZ9ZuzYwN9JKC_0 U.68ezs5lBut0nyCKXx2CSFjUvVAEjaeKzjxQPEqY53NkplVY4owV3r_5HGDRWjtnJleHxr.Lp19 T0Ee4M4TBO2fWGKXZGYrLCsGYCQwZllQp8TRPnR2hxMk6blksG.s3Jq.8r12ZlUeoav1Yb6SOrbq RlvB0TQaXWYgZfMBZhiRw9OMggf5NpjEyOJ7mmhS0eKbv6gl7iGGKaaFQyB_LqGEVr.p2aSE_AjJ YncIegqrI.i3j8V9kscnQ_T_ldLqasrCmVmo1x.EUlVRr9gAOLAwUfjg4CyZ7STVvaFqrzM10Cpf Qd9eR7MTfuBP924jr.KwuRQhq9o_jvB3YJzmDbH1_nYxL7B6X1wcimtbqdUz7.2L9xFhwTulWrX0 5NtptwGuNwOZR71Z3REqXJn1ojuq83E0DkGYD070jNlslG88GrKiaZ56FNDixJHdMnwIQXtsM0ba OsnT_fDY6Ypcb_.qDL9pk3rV_1nfNTmv6w1MKecN.dYGX7Eme6dWQM.fk2QNaVhdTh8IG8vs.48r 5PhOP46KgmAqRXw4BkEcTJcj.dF5Z6OzbIIhNMkhHvgynMeWLgzpWHlA9ajNosnO_rNQkkOP5yS1 IUheOXeUnDwAl_sOujA4IO_FDRz7SOkzMserTM.UFoVhlTJrlaMLaBmud6SOlQ5lg520becF_vUY JBtuV_umFiOBxuHAorHgYLpehfrf4y52iwXrRWK6oGQrj Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.bf2.yahoo.com with HTTP; Thu, 5 Dec 2019 15:49:23 +0000 Date: Thu, 5 Dec 2019 15:49:09 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: John Scalia Cc: Matthew Tice , Pgsql-admin , PgAdmin Support List , =?UTF-8?Q?Isa=C3=ADas_S=C3=A1nchez?= Message-ID: <932710129.6125457.1575560949725@mail.yahoo.com> In-Reply-To: References: <1614372602.2615961.1575559892661@mail.yahoo.com> Subject: Re: postgres service can't restart/start MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6125456_885936243.1575560949721" X-Mailer: WebService/1.1.14728 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 Content-Length: 39196 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_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 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 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 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 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 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 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
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.
systemctl restart postgresql-11
<= /div>
systemctl restart postgresql-11.service

=

Bach-Nga

No one in this world = is pure and perfect.  If you avoid people for their mistakes you will = be alone. So judge less, love and forgive more.
<= div id=3D"ydp94a3e34yui_3_13_0_rc_1_1_1381789421038_7874" class=3D"ydp94a3e= 34yiv3811552299ms__id13893">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)

*= *Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


=20
=20
On Thursday, December 5, 2019, 10:41:57 AM EST, John Sc= alia <jayknowsunix@gmail.com> wrote:


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.

=E2=80=94
Jay

Sent from my iPad

On Dec 5, 2019, at 10:31 AM, Pepe TD Vo &l= t;pepevo@yahoo.com> wrote:

=EF=BB=BF
yes I d= o have a righ systemd service file named 'postgresql-11' and its located /u= sr/lib/systemd/system/

Here what I did so far afte= r make install.

&nb= sp;

mkd= ir /usr/local/pgsql/log

Run=

./u= sr/local/pgsql/bin/pg_ctl =E2=80=93D /postgres_data/pgsql/data =E2=80=93l /usr/local/pgsql/log/logfile start

psq= l

in = the psql shell

psq= l# create user replica replication login encrypted password =E2=80=98replicauser@=E2=80=99;=

psq= l# alter user postgres password =E2=80=98password@=E2=80=99;

&nb= sp;

con= figure postgresql.conf:

por= t =3D 5432

uni= x_socket_directorys =3D =E2=80=99tmp=E2=80=99

max= _files_per_process =3D 1000

lis= ten_addresses =3D =E2=80=98localhost, 192.168.2.122 =E2=80=98  =C3=A0 (master-server-= ip)

wal= _level =3D replica

max= _replication_slots =3D 10

arc= hive_mode =3D on

arc= hive_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

&nb= sp;

for= pg_hba.conf, I added:

loc= al       all              postgres    &= nbsp;                    =        md5            &n= bsp;  =C3= =A0 authenticate postgres

hos= t       replication  replica   192.##.##.##/32      md5       = ;        =C3=A0 master-server

hos= t       replication  replica   192.##.##.##/32      md5      =          =C3=A0 slave-server

&nb= sp;

$ m= kdir =E2=80=93p /u02/postgres/main/archive

$ s= ystemctl restart postgresql

=3D= =3D=3D AUTHENTICATING FOR org.freedesktop.systemd1.manage-units =3D=3D=3D

Aut= ehtication is required to manage system services or units.

Aut= henticating as: sysmaint

Pas= sword:

=3D= =3D=3D AUTHENTICATION COMPLETE =3D=3D=3D

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.

For= the status, it complained about /usr/lib/systemd/system/postgresql-11.service; disabled; vendor preset: dis= abled_

Act= ive: failed (Result: exit-code) since date: time

Pro= cess:10188 ExecStartPre=3D/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=3Dexisted, status=3D1/FAILURE)

&nb= sp;

I un-commented data_directory and correct the path to postgresql.conf per SA suggested and still get the same error above

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

&nb= sp;

sti= ll prompt for the user=E2=80=99s password even I am logging as postgres os user.

<= span style=3D"color:#1F497D;">the binary (postgres_home) =3D /usr/local/pgsql/  should owned by root:root, right? 

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.

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.


Bach-Nga

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.
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)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing succes= s


=20
=20
On Wednesday, December 4, 2019, 05:59:20 PM EST, Matthe= w Tice <mjtice@gmail.com> wrote:


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

On Wed, Dec 4, 2019 at 1:39 PM Pepe TD Vo <pepevo@yahoo.com> wrote= :
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.
=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
<= pre style=3D"white-space:pre-wrap;color:rgb(0,0,0);font-size:16px;">P= assword:
=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.=
<= /span>
Bach-Nga

= 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.
=
To call him a = dog hardly seems to do him justice though in as much as he had four legs, a= tail, and barked, I admit he was, to all outward appearances. But to those= who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak k= indly.
*** Genuinely rich *** Faithful talent *** Sharing success=


=20
=20
On Wednesday, December 4, 2019, 02:36:21 PM EST, Isa=C3= =ADas S=C3=A1nchez <isaias.sanchez.l@gmail.com> wrote:


Verify file permission is right, sometimes if you edit a conf file it = changes owner and access permission

En 4 de diciembre de 2019 18:55:38 Pepe TD Vo <pepevo@yahoo.com> escribi=C3=B3:

=
<= div>
Hi experts,

<= /div>
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:
ATHENTICATING for org.freedesktop.systemd= 1.manage-units ---
Athentication is required to manag= e system services or units.
authenticating as :user1<= /div>
Password:
-- ATHENTICATION COMP= LETE --
Failed to start psotgres-11.service: unit no = found.

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.
<= br clear=3D"none">
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?


= Bach-Nga

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.
=
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)=

**Live simply **Love generously **Care deeply = **Speak kindly.
*** G= enuinely rich *** Faithful talent *** Sharing success

------=_Part_6125456_885936243.1575560949721--