> 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@xxxxxxxxxxxxxxxxxx> wrote: > > 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 > -- _________________________________ Pulchritudo splendor veritatis.
