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 <[email protected]> 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 > <[email protected]> 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 <[email protected]> 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 >> <[email protected]> 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 <[email protected]> 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 > >
