Re: postgres service can't restart/start

the restart doesn't work.  I worked around and using pg_ctl to reload. Service stopped and can't start up the service (pg_ctl: could not start server).  Even start with postgresql-11 with and/out .service.systemctl restart postgresql-11
systemctl restart postgresql-11.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 Thursday, December 5, 2019, 10:41:57 AM EST, John Scalia <jayknowsunix(at)gmail(dot)com> wrote:

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(at)yahoo(dot)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 aftermake 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 replicareplication login encrypted password ‘replicauser(at)’;

psql# alter user postgrespassword ‘password(at)’;

 

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 FORorg.freedesktop.systemd1.manage-units ===

Autehtication is required tomanage system services or units.

Authenticating as: sysmaint

Password:

=== AUTHENTICATION COMPLETE ===

Job for postgresql-11.servicefailed because the control process existed with error code. See “systemctlstatus 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:10188ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA}(code=existed, status=1/FAILURE)

 

I un-commented data_directory andcorrect the path to postgresql.conf per SA suggested and still get the sameerror 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’spassword 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 sureI am right, I found there’s another source on /usr/pgql-11/bin existed on theserver.  When the SA installed the OS Patch, the server hadpostgres-9.6.  I can run any date for Postgresql 11.  He applied OSPatches updated, removed 9.6 and yum the postgresql11-11.1-1PGDG.rhel7.x86_64.rpmsuccessful, 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 whichone is the corrected binaries.  Comparing with the single node postgresserver I did last year, the /usr/local/pgsql sounds convinced right binariesone 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(at)gmail(dot)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(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: user1Password:==== AUTHENTICATION COMPLETE ====Failed to start postgres-11.service: unit not foundSA 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 :user1Password:-- 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