Re: FATAL: pg_hba.conf ::1

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Fredy Ganga (GMAIL ACCOUNT)" <fredy(dot)ganga(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: FATAL: pg_hba.conf ::1
Date: 2010-06-02 20:04:47
Message-ID: AANLkTinxNkH9z6l84X-3UgAgsLdCXHRAPBIdobodE_kG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jun 1, 2010 at 7:55 AM, Fredy Ganga (GMAIL ACCOUNT)
<fredy(dot)ganga(at)gmail(dot)com> wrote:
> Hello:
>
> I have been testing streaming replication on postgresql 9, and now i have
> this messages in pg_log on salve.
> pg_log:
> 2010-06-01 09:13:58 CLT LOG:  el sistema de bases de datos fue interrumpido;
> última vez en funcionamiento en 2010-06-01 09:00:17 CLT
> 2010-06-01 09:13:58 CLT LOG:  entering standby mode
> 2010-06-01 09:13:58 CLT LOG:  redo comienza en 0/10000020
> 2010-06-01 09:13:58 CLT LOG:  registro de longitud cero en 0/100000A8
> 2010-06-01 09:13:58 CLT LOG:  streaming replication successfully connected
> to primary
> 2010-06-01 09:13:59 CLT FATAL:  el sistema de base de datos está iniciándose
> 2010-06-01 09:14:00 CLT FATAL:  el sistema de base de datos está iniciándose
> 2010-06-01 09:14:00 CLT LOG:  consistent recovery state reached at
> 0/11000000
> 2010-06-01 09:14:00 CLT LOG:  database system is ready to accept read only
> connections
> 2010-06-01 09:14:01 CLT FATAL:  no hay una línea en pg_hba.conf para «::1»,
> usuario «postgres», base de datos «postgres», SSL inactivo
> 2010-06-01 09:14:02 CLT FATAL:  no hay una línea en pg_hba.conf para «::1»,
> usuario «postgres», base de datos «postgres», SSL inactivo
>
> IPV6????
> My pg_hba on slave:
> # TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD
> # IPv4 local connections:
> host    all             all             127.0.0.1/32            md5
> #host replication postgres 192.168.XXX.XX/16 trust
> host all all 192.168.XXX.XX/16 trust
> # IPv6 local connections:
> #host    all             all             ::1/128                 md5
> ENVIRONMENT:
> DB: Postgresql 9
> Master: Windows XP
> Slave: Windows 2008 Server
> Maybe this problem is'nt important to the replication process.. but... i
> would like to resolve it...
> Thanks for your help.

Looks like it's trying to use IPv6 and there's no entries for IPv6 in
your pg_hba.conf to math.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-06-02 20:44:30 Re: Exception while accessing database
Previous Message Scott Marlowe 2010-06-02 20:03:01 Re: Installing PostgreSQL