Re: postgres service can't restart/start

2019-12-05 Thread 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 i

Re: postgres service can't restart/start

2019-12-05 Thread 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 wrote: > >  > yes I do have a righ systemd service file named 'pos

Re: postgres service can't restart/start

2019-12-05 Thread 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 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 p

Re: postgres service can't restart/start

2019-12-04 Thread 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 wrote: > the permission and owner are right. to add the authentication into the > pg_hba.conf but when I try to

Re: postgres service can't restart/start

2019-12-04 Thread 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.syst

Re: postgres service can't restart/start

2019-12-04 Thread 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 escribió: Hi experts, I am trying to install Postgresql 11.1 replication master-slave. The configure, make and make install went well. Ini