Re: postgres service can't restart/start

From: Matthew Tice <mjtice(at)gmail(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Cc: 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 23:01:10
Message-ID: CA+taBv8qSRoMEFLVTwyx=TujhY6D4Puche7Pmkbo9U0fZdKGzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support 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(at)yahoo(dot)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(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 :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
>
>
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Pepe TD Vo 2019-12-05 15:31:32 Re: postgres service can't restart/start
Previous Message Jose Mercedes Venegas Acevedo 2019-12-04 21:42:06 Re: Error al instalar

Browse pgsql-admin by date

  From Date Subject
Next Message soumik.bhattacharjee 2019-12-05 09:47:35 RE: Postgres and Java Microservices Multithreading
Previous Message Pepe TD Vo 2019-12-04 20:38:59 Re: postgres service can't restart/start