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 [email protected][19645]: The PostgreSQL server failed
to start. Please check the log output:
Jan 18 17:59:15 16sv [email protected][19645]: 2018-01-18 17:59:15 WIB
[19651-1] LOG: invalid authentication method "turst"
Jan 18 17:59:15 16sv [email protected][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 [email protected][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]: [email protected]: 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 [email protected] has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit [email protected] has failed.
--
-- The result is failed.
Jan 18 17:59:15 16sv systemd[1]: [email protected]: Unit entered
failed state.
Jan 18 17:59:15 16sv systemd[1]: [email protected]: 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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
