Re: pg_hba esta ok, pero sale error

ok gracias, este hilo ya fue cerrado. Hay otro hilo similar que trata de la conf que deberia tomar postgresql para cuando la configuración del SO por defecto es IPv6. Espero tu ayuda ahi.

>________________________________
> De: Lazaro Rubén García Martinez <lgarciam(at)vnz(dot)uci(dot)cu>
>Para: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>; "pgsql-es-ayuda(at)postgresql(dot)org" <pgsql-es-ayuda(at)postgresql(dot)org>
>CC: "alvherre(at)alvh(dot)no-ip(dot)org" <alvherre(at)alvh(dot)no-ip(dot)org>; "jaime(at)2ndquadrant(dot)com" <jaime(at)2ndquadrant(dot)com>
>Enviado: lunes 21 de noviembre de 2011 13:20
>Asunto: RE: [pgsql-es-ayuda] pg_hba esta ok, pero sale error
>
>
>
>Revisa esta línea:
>host   
all            
all            
0.0.0.0/32              
md5
> 
>No debería ser 0.0.0.0/0 ?
> 
>Saludos.
> 
>De:pgsql-es-ayuda-owner(at)postgresql(dot)org
[mailto:pgsql-es-ayuda-owner(at)postgresql(dot)org] En nombre de Alejandro
Carrillo
>Enviado el: sábado, 19 de noviembre de 2011 01:14
>Para: pgsql-es-ayuda(at)postgresql(dot)org
>CC: alvherre(at)alvh(dot)no-ip(dot)org; jaime(at)2ndquadrant(dot)com
>Asunto: [pgsql-es-ayuda] pg_hba esta ok, pero sale error
> 
>Buenas
tardes,
> 
>Me esta
saliendo el siguiente error "FATAL:  no hay una l?nea en pg_hba.conf
para ?::1?, usuario ?postgres?, base de datos ?postgres?, SSL inactivo"
>Reviso el
archivo pg_hba.conf y aparentemente es correcto:
>
># TYPE  DATABASE       
USER           
ADDRESS                
METHOD
>
># IPv4 local connections:
>host   
all            
all            
127.0.0.1/32            trust
># IPv6 local connections:
>#host   
all            
all            
::1/128                
trust
>host   
all            
all            
0.0.0.0/32              
md5
># Allow replication connections from localhost, by a user with the
># replication privilege.
>#host    replication    
postgres       
127.0.0.1/32           
trust
>#host    replication    
postgres        ::1/128                
trust
> 
>El
archivo postgresql.conf aparentemente esta ok:
> 
>
># The default values of these variables are driven from the -D command-line
># option or PGDATA environment variable, represented here as ConfigDir.
>
>#data_directory = 'ConfigDir'        # use data
in another directory
>               
    # (change requires restart)
>#hba_file = 'ConfigDir/pg_hba.conf'    # host-based
authentication file
>               
    # (change requires restart)
>#ident_file = 'ConfigDir/pg_ident.conf'    # ident configuration
file
>               
    # (change requires restart)
>
># If external_pid_file is not explicitly set, no extra PID file is written.
>#external_pid_file = '(none)'        # write an
extra PID file
>               
    # (change requires restart)
>
>
>#------------------------------------------------------------------------------
># CONNECTIONS AND AUTHENTICATION
>#------------------------------------------------------------------------------
>
># - Connection Settings -
>
>listen_addresses = '*'        # what IP
address(es) to listen on;
>               
    # comma-separated list of addresses;
>               
    # defaults to 'localhost', '*' = all
>               
    # (change requires restart)
>#port = 5432           
    # (change requires restart)
>max_connections = 100            #
(change requires restart)
># Note:  Increasing max_connections costs ~400 bytes of shared memory per
># connection slot, plus lock space (see max_locks_per_transaction).
>#superuser_reserved_connections = 3    # (change requires
restart)
>#unix_socket_directory = ''        # (change
requires restart)
>#unix_socket_group = ''           
# (change requires restart)
>#unix_socket_permissions = 0777        # begin
with 0 to use octal notation
>               
    # (change requires restart)
>#bonjour = off           
    # advertise server via Bonjour
>               
    # (change requires restart)
>#bonjour_name = ''            #
defaults to the computer name
>               
    # (change requires restart)
>
># - Security and Authentication -
>
>#authentication_timeout = 1min        # 1s-600s
>#ssl = off           
    # (change requires restart)
>#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH'    # allowed
SSL ciphers
>               
    # (change requires restart)
>#ssl_renegotiation_limit = 512MB    # amount of data between
renegotiations
>#password_encryption = on
>#db_user_namespace = off
>
># Kerberos and GSSAPI
>#krb_server_keyfile = ''
>#krb_srvname = 'postgres'        # (Kerberos
only)
>#krb_caseins_users = off
>
># - TCP Keepalives -
># see "man 7 tcp" for details
>
>#tcp_keepalives_idle = 0        # TCP_KEEPIDLE,
in seconds;
>               
    # 0 selects the system default
>#tcp_keepalives_interval = 0        #
TCP_KEEPINTVL, in seconds;
>               
    # 0 selects the system default
>#tcp_keepalives_count = 0        # TCP_KEEPCNT;
>               
    # 0 selects the system default
> 
>¿Que
puede estar sucediendo?
>
>