Public bug reported:
OS Release:
taiga@16sv:~$ sudo lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial
Postgre version:
taiga@16sv:~$ sudo apt-cache policy postgresql
postgresql:
Installed: 9.5+173ubuntu0.1
Candidate: 9.5+173ubuntu0.1
Version table:
*** 9.5+173ubuntu0.1 500
500 http://id.archive.ubuntu.com/ubuntu xenial-updates/main amd64
Packages
500 http://id.archive.ubuntu.com/ubuntu xenial-updates/main i386
Packages
500 http://security.ubuntu.com/ubuntu xenial-security/main amd64
Packages
500 http://security.ubuntu.com/ubuntu xenial-security/main i386 Packages
100 /var/lib/dpkg/status
9.5+173 500
500 http://id.archive.ubuntu.com/ubuntu xenial/main amd64 Packages
500 http://id.archive.ubuntu.com/ubuntu xenial/main i386 Packages
Expected behavior:
Start properly postgresql service after installation and be able to connect to
it with psql command from the postgres account.
What happened
Failed to start the service with the following error:
Jan 18 17:59:15 16sv postgresql@9.5-main[19645]: The PostgreSQL server failed
to start. Please check the log output:
Jan 18 17:59:15 16sv postgresql@9.5-main[19645]: 2018-01-18 17:59:15 WIB
[19651-1] LOG: invalid authentication method "turst"
Jan 18 17:59:15 16sv postgresql@9.5-main[19645]: 2018-01-18 17:59:15 WIB
[19651-2] CONTEXT: line 90 of configuration file
"/etc/postgresql/9.5/main/pg_hba.conf"
Jan 18 17:59:15 16sv postgresql@9.5-main[19645]: 2018-01-18 17:59:15 WIB
[19651-3] FATAL: could not load pg_hba.conf
Jan 18 17:59:15 16sv systemd[1]: postgresql@9.5-main.service: Control process
exited, code=exited status=1
Jan 18 17:59:15 16sv systemd[1]: Failed to start PostgreSQL Cluster 9.5-main.
-- Subject: Unit postgresql@9.5-main.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql@9.5-main.service has failed.
--
-- The result is failed.
Jan 18 17:59:15 16sv systemd[1]: postgresql@9.5-main.service: Unit entered
failed state.
Jan 18 17:59:15 16sv systemd[1]: postgresql@9.5-main.service: Failed with
result 'exit-code'.
Jan 18 17:59:15 16sv sudo[19642]: pam_unix(sudo:session): session closed for
user root
Jan 18 17:59:21 16sv sudo[19656]: taiga : TTY=pts/0 ; PWD=/home/taiga ;
USER=root ; COMMAND=/bin/journalctl -xe
Jan 18 17:59:21 16sv sudo[19656]: pam_unix(sudo:session): session opened for
user root by apinter(uid=0)
FIX:
line 90 of configuration file "/etc/postgresql/9.5/main/pg_hba.conf" change the
"turst" typo to "trust.
** Affects: postgresql-9.5 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1744035
Title:
Failed to start PostgreSQL Cluster 9.5-main
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-9.5/+bug/1744035/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
