Обсуждение: postgres service can't restart/start

Поиск
Список
Период
Сортировка

postgres service can't restart/start

От
Pepe TD Vo
Дата:
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

Re: postgres service can't restart/start

От
Isaías Sánchez
Дата:
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

Re: postgres service can't restart/start

От
Isaías Sánchez
Дата:
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

Re: postgres service can't restart/start

От
Pepe TD Vo
Дата:
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

Re: postgres service can't restart/start

От
Pepe TD Vo
Дата:
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

Re: postgres service can't restart/start

От
Matthew Tice
Дата:
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

Re: postgres service can't restart/start

От
Matthew Tice
Дата:
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

Re: postgres service can't restart/start

От
Pepe TD Vo
Дата:
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

Re: postgres service can't restart/start

От
Pepe TD Vo
Дата:
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

Re: postgres service can't restart/start

От
John Scalia
Дата:
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

Re: postgres service can't restart/start

От
John Scalia
Дата:
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

Re: postgres service can't restart/start

От
Pepe TD Vo
Дата:
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@gmail.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@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

Re: postgres service can't restart/start

От
Pepe TD Vo
Дата:
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@gmail.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@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