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@xxxxxxxxx> wrote:
the permission and owner are right. to add the authentication into the pg_hba.conf but when I try to start up the postgres, it prompts me for password logged in, even I logged in directly from postgres os user not su from root and/or another os user.==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units === Authentication is required to manage system services or units. Authenticating as: user1
Password:
==== AUTHENTICATION COMPLETE ====
Failed to start postgres-11.service: unit not found
SA worked around with me and still can't start the postgresql service.Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing successOn Wednesday, December 4, 2019, 02:36:21 PM EST, Isaías Sánchez <isaias.sanchez.l@xxxxxxxxx> wrote:Verify file permission is right, sometimes if you edit a conf file it changes owner and access permissionEn 4 de diciembre de 2019 18:55:38 Pepe TD Vo <pepevo@xxxxxxxxx> escribió:
Hi experts,I am trying to install Postgresql 11.1 replication master-slave. The configure, make and make install went well. Initdb to the shared drive 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:ATHENTICATING for org.freedesktop.systemd1.manage-units ---Athentication is required to manage system services or units.authenticating as :user1Password:-- ATHENTICATION COMPLETE --Failed to start psotgres-11.service: unit no found.I worked around and add the postgres on pg_hba.conf and using pg_ctl to reload the service. Postgres server stopped but can't start, it complained about checkpoint_segments which I have set its to 8.Working with SA to reconfigure the authenticating and the server reaching out and getting authenticaion from org.freedesktop.systemd1.nanage-units. How can I by pass this issue and bring the postgres up?Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success