Re: postgres service can't restart/start

Поиск
Список
Период
Сортировка
От Matthew Tice
Тема Re: postgres service can't restart/start
Дата
Msg-id CA+taBv8qSRoMEFLVTwyx=TujhY6D4Puche7Pmkbo9U0fZdKGzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgres service can't restart/start  (Pepe TD Vo <pepevo@yahoo.com>)
Ответы Re: postgres service can't restart/start  (Pepe TD Vo <pepevo@yahoo.com>)
Re: postgres service can't restart/start  (Pepe TD Vo <pepevo@yahoo.com>)
Список pgsql-admin
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 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 по дате отправления:

Предыдущее
От: Pepe TD Vo
Дата:
Сообщение: Re: postgres service can't restart/start
Следующее
От:
Дата:
Сообщение: RE: Postgres and Java Microservices Multithreading