pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John Scalia <jayknowsunix@gmail.com>
To: Pepe TD Vo <pepevo@yahoo.com>
Cc: Matthew Tice <mjtice@gmail.com>
Cc: Pgsql-admin <pgsql-admin@postgresql.org>
Cc: PgAdmin Support List <pgadmin-support@lists.postgresql.org>
Cc: Isaías Sánchez <isaias.sanchez.l@gmail.com>
Subject: Re: postgres service can't restart/start
Date: Thu, 5 Dec 2019 10:41:26 -0500
Message-ID: <D4E0A7C6-5D24-4C5B-B378-43D972E9AFAC@gmail.com> (raw)
In-Reply-To: <1614372602.2615961.1575559892661@mail.yahoo.com>
References: <1614372602.2615961.1575559892661@mail.yahoo.com>

You rapidly confuse the systemd process if you manually start/stop/restart PostgreSQL by hand. Always use the service or systemctl command for doing anything.

—
Jay

Sent from my iPad

> On Dec 5, 2019, at 10:31 AM, Pepe TD Vo <pepevo@yahoo.com> wrote:
> 
> 
> yes I do have a righ systemd service file named 'postgresql-11' and its located /usr/lib/systemd/system/
> 
> Here what I did so far after make install.
> 
>  
> 
> mkdir /usr/local/pgsql/log
> 
> Run
> 
> ./usr/local/pgsql/bin/pg_ctl –D /postgres_data/pgsql/data –l /usr/local/pgsql/log/logfile start
> 
> psql
> 
> in the psql shell
> 
> psql# create user replica replication login encrypted password ‘replicauser@’;
> 
> psql# alter user postgres password ‘password@’;
> 
>  
> 
> configure postgresql.conf:
> 
> port = 5432
> 
> unix_socket_directorys = ’tmp’
> 
> max_files_per_process = 1000
> 
> listen_addresses = ‘localhost, 192.168.2.122 ‘  à (master-server-ip)
> 
> wal_level = replica
> 
> max_replication_slots = 10
> 
> archive_mode = on
> 
> archive_command = ‘cp –I %p /u02/postgres/main/archive/%f’
> 
> max_wal_senders = 10
> 
> wal_keep_segments = 64
> 
>  
> 
> for pg_hba.conf, I added:
> 
> local       all              postgres                                 md5               à authenticate postgres
> 
> host       replication  replica   192.##.##.##/32      md5               à master-server
> 
> host       replication  replica   192.##.##.##/32      md5               à slave-server
> 
>  
> 
> $ mkdir –p /u02/postgres/main/archive
> 
> $ systemctl restart postgresql
> 
> === AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
> 
> Autehtication is required to manage system services or units.
> 
> Authenticating as: sysmaint
> 
> Password:
> 
> === AUTHENTICATION COMPLETE ===
> 
> Job for postgresql-11.service failed because the control process existed with error code. See “systemctl status postgresql-11.service” and “journalctl –xe” for details.
> 
> For the status, it complained about /usr/lib/systemd/system/postgresql-11.service; disabled; vendor preset: disabled_
> 
> Active: failed (Result: exit-code) since date: time
> 
> Process:10188 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=existed, status=1/FAILURE)
> 
>  
> 
> I un-commented data_directory and correct the path to postgresql.conf per SA suggested and still get the same error above
> 
> data_directory = ‘/postgres_data/pgsql/data/’   --> data folder is on shared drive.
> hba_file = ‘/postgres_data/pgsql/pg_hba.conf’
> 
>  
> 
> still prompt for the user’s password even I am logging as postgres os user.
> 
> the binary (postgres_home) = /usr/local/pgsql/  should owned by root:root, right? 
> 
> The problem I think but not sure I am right, I found there’s another source on /usr/pgql-11/bin existed on the server.  When the SA installed the OS Patch, the server had postgres-9.6.  I can run any date for Postgresql 11.  He applied OS Patches updated, removed 9.6 and yum the postgresql11-11.1-1PGDG.rhel7.x86_64.rpm successful, configure, make and make install and start the postgresql service without error until the configuration of pg_hba.conf and postgresql.conf.  The restart service failed.
> 
> Wonder if I can remove /usr/pgql-11 or not but not sure which one is the corrected binaries.  Comparing with the single node postgres server I did last year, the /usr/local/pgsql sounds convinced right binaries one but /usr/pgsql-11 have more functions.
> 
> 
> 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, 05:59:20 PM EST, Matthew Tice <mjtice@gmail.com> wrote:
> 
> 
> 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
> 
> 

view thread (7+ messages)  latest in thread

Message-ID: <D4E0A7C6-5D24-4C5B-B378-43D972E9AFAC@gmail.com>
Permalink:  ../D4E0A7C6-5D24-4C5B-B378-43D972E9AFAC@gmail.com/
Also on:    postgresql.org/message-id/D4E0A7C6-5D24-4C5B-B378-43D972E9AFAC@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jayknowsunix@gmail.com, pepevo@yahoo.com, mjtice@gmail.com, pgadmin-support@lists.postgresql.org, isaias.sanchez.l@gmail.com
  Subject: Re: postgres service can't restart/start
  In-Reply-To: <D4E0A7C6-5D24-4C5B-B378-43D972E9AFAC@gmail.com>
  References: <1614372602.2615961.1575559892661@mail.yahoo.com> <D4E0A7C6-5D24-4C5B-B378-43D972E9AFAC@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox