Re: postgres service can't restart/start

Поиск
Список
Период
Сортировка
От Pepe TD Vo
Тема Re: postgres service can't restart/start
Дата
Msg-id 1484135128.5865979.1575491939671@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: postgres service can't restart/start  (Isaías Sánchez <isaias.sanchez.l@gmail.com>)
Ответы Re: postgres service can't restart/start
Re: postgres service can't restart/start
Список 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: 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 success


On Wednesday, December 4, 2019, 02:36:21 PM EST, Isaías Sánchez <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ó:

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 :user1
Password:
-- 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bimal
Дата:
Сообщение: Is there a list of config change for ver 10 & 11 to achieve PCI-DSScompliance
Следующее
От: Matthew Tice
Дата:
Сообщение: Re: postgres service can't restart/start