From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
---|---|
To: | Aram Fingal <fingal(at)multifactorial(dot)com>, Postgres-General General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: invalid connection type "listen_addresses='*' |
Date: | 2014-07-10 20:54:53 |
Message-ID: | A76B25F2823E954C9E45E32FA49D70EC9199AF46@mail.corp.perceptron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Aram Fingal
Sent: Thursday, July 10, 2014 4:40 PM
To: Postgres-General General
Subject: [GENERAL] invalid connection type "listen_addresses='*'
I just tried to set up a PostgreSQL server on an existing instillation of Ubuntu 13.10 server but I am getting an error trying to start the server and I am not finding anything relevant to the error searching the web.
Here's what I did to install:
$ sudo apt-get install postgresql
$ sudo apt-get install postgresql-contrib
I set a password for the postgres user and edited the pg_hba.conf file as follows:
<skipping a bunch of comments>
# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL
# listen on a non-local interface via the listen_addresses
# configuration parameter, or via the -i or -h command line switches.
listen_addresses='*'
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database superuser can access the database using some other method.
# Noninteractive access to all databases is required during automatic
# maintenance (custom daily cronjobs, replication, and similar tasks).
#
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all all md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
Then I try to restart the server:
$ sudo /etc/init.d/postgresql restart
* Restarting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output:
2014-07-10 16:34:39 EDT LOG: invalid connection type "listen_addresses='*'"
2014-07-10 16:34:39 EDT CONTEXT: line 75 of configuration file "/etc/postgresql/9.1/main/pg_hba.conf"
2014-07-10 16:34:39 EDT FATAL: could not load pg_hba.conf
Adam,
"listen_addresses='*'" parameter doesn't belong in pg_hba.conf
This parameter should be in postgresql.conf
Regards,
Igor Neyman
From | Date | Subject | |
---|---|---|---|
Next Message | Aram Fingal | 2014-07-10 21:10:15 | Re: invalid connection type "listen_addresses='*' |
Previous Message | Paul Jungwirth | 2014-07-10 20:53:18 | Re: invalid connection type "listen_addresses='*' |