On 03/28/2018 07:29 PM, Ken Beck wrote: Comments in line.
The current log is 0 length, and indeed empty. I just tried 'sudo pg_ctlcluster 9.3 main start' and got the following error: Error: Config owner (kcb:1000) and data owner (postgres:116) do not match, and config owner is not root
So why is your config owned by you and the data owned by postgres? Your configuration files should be under: /etc/postgresql/9.3/main/ and on my Ubuntu setups anyway is owned by postgres.
Changed to user postgres, tried again and go > Warning: the cluster will not be running as a systemd service. Consider using systemctl: sudo systemctl start [email protected] Removed stale pid file. Next tried the suggestion: sudo systemctl start [email protected], but the system failed to accept the password for user postgres. That is NOT something I changed
My experience with Ubuntu is that the postgres system user does not have a password. So where you using the database postgres user password? For more detail see here:
https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-16-04
during the Ubuntu upgrade process, so that has been a puzzle as well. My main login, user kcb is OK, password still works. So I change back to user kcb and try the suggestion again: kcb: jobs(0)$ sudo systemctl start [email protected] Job for [email protected] failed because the control process exited with error code. See "systemctl status [email protected]" and "journalctl -xe" for details. kcb: jobs(0)$ systemctl status [email protected] ● [email protected] - PostgreSQL Cluster 9.3-main Loaded: loaded (/lib/systemd/system/[email protected]; disabled; vendor preset: enabled) Active: failed (Result: exit-code) since Wed 2018-03-28 19:51:50 MDT; 47s ago Process: 2960 ExecStart=postgresql@%i --skip-systemctl-redirect %i start (code=exited, status= Mar 28 19:51:50 kcb-VirtualBox systemd[1]: Starting PostgreSQL Cluster 9.3-main... Mar 28 19:51:50 kcb-VirtualBox [email protected][2960]: Error: Config owner (kcb:1000) and dat
Again the error with the config owner being you. Seems it would help to track down what copies of the conf files are installed on your machine.
Mar 28 19:51:50 kcb-VirtualBox systemd[1]: [email protected]: Control process exited, Mar 28 19:51:50 kcb-VirtualBox systemd[1]: Failed to start PostgreSQL Cluster 9.3-main. Mar 28 19:51:50 kcb-VirtualBox systemd[1]: [email protected]: Unit entered failed stat Mar 28 19:51:50 kcb-VirtualBox systemd[1]: [email protected]: Failed with result 'exit Is it possible a big problem is that the password for user postgres not longer works for some reason, not sure why. It appears the password can not be rest or changed without knowing the original, and what I thought was the original no longer works.
Remember there are two postgres users in play here, the system user and the database one. Which one are you referring to?
-- Adrian Klaver [email protected]
