Re: invalid connection type "listen_addresses='*'

> listen_addresses='*'

I'm pretty sure that listen_addresses belongs in postgresql.conf, not
pg_hba.conf.

Paul




On Thu, Jul 10, 2014 at 1:40 PM, Aram Fingal <fingal@multifactorial.com> wrote:
>
> I just tried to set up a PostgreSQL server on an existing instillation of Ubuntu 13.10 server but I am getting an
errortrying 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
checkthe 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
>



--
_________________________________
Pulchritudo splendor veritatis.