Re: postgres service can't restart/start

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: Pgsql-admin <pgsql-admin(at)postgresql(dot)org>, PgAdmin Support List <pgadmin-support(at)lists(dot)postgresql(dot)org>, Isaías Sánchez <isaias(dot)sanchez(dot)l(at)gmail(dot)com>
Subject: Re: postgres service can't restart/start
Date: 2019-12-04 20:38:59
Message-ID: 1484135128.5865979.1575491939671@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin

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: user1Password:==== AUTHENTICATION COMPLETE ====Failed to start postgres-11.service: unit not foundSA 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 success

On Wednesday, December 4, 2019, 02:36:21 PM EST, Isaías Sánchez <isaias(dot)sanchez(dot)l(at)gmail(dot)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(at)yahoo(dot)com> 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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Jose Mercedes Venegas Acevedo 2019-12-04 21:42:06 Re: Error al instalar
Previous Message Isaías Sánchez 2019-12-04 19:36:15 Re: postgres service can't restart/start

Browse pgsql-admin by date

  From Date Subject
Next Message Matthew Tice 2019-12-04 23:01:10 Re: postgres service can't restart/start
Previous Message Bimal 2019-12-04 19:43:08 Is there a list of config change for ver 10 & 11 to achieve PCI-DSS compliance