invalid connection type "listen_addresses='*'

Поиск
Список
Период
Сортировка
От Aram Fingal
Тема invalid connection type "listen_addresses='*'
Дата
Msg-id 5F75098E-8DEF-49FE-9699-74E0314EA0AB@multifactorial.com
обсуждение исходный текст
Ответы Re: invalid connection type "listen_addresses='*'
Re: invalid connection type "listen_addresses='*'
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Should I partition this table?
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Should I partition this table?