Re: postgres service can't restart/start

[Pepe TD Vo <pepevo@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> 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