Re: invalid connection type "listen_addresses='*' - Mailing list pgsql-general
From | Paul Jungwirth |
---|---|
Subject | Re: invalid connection type "listen_addresses='*' |
Date | |
Msg-id | CA+6hpamN-7zJBiM94FxKDE9vdJS-Ys-ShMtXq_OrS72y8ga1Qw@mail.gmail.com Whole thread Raw |
In response to | invalid connection type "listen_addresses='*' (Aram Fingal <fingal@multifactorial.com>) |
List | pgsql-general |
> 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.
pgsql-general by date: