Failed to start PostgreSQL Cluster 9.5-main

Bug #1744035 reported by Pintér Attila
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
postgresql-9.5 (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

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.

Revision history for this message
Pintér Attila (attila-pinter-nuke) wrote :

False alarm, I messed up... Sorry guys!

Changed in postgresql-9.5 (Ubuntu):
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.