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 <lgarc...@vnz.uci.cu> >Para: Alejandro Carrillo <faster...@yahoo.es>; "pgsql-es-ayuda@postgresql.org" ><pgsql-es-ayuda@postgresql.org> >CC: "alvhe...@alvh.no-ip.org" <alvhe...@alvh.no-ip.org>; >"ja...@2ndquadrant.com" <ja...@2ndquadrant.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-ow...@postgresql.org [mailto:pgsql-es-ayuda-ow...@postgresql.org] En nombre de Alejandro Carrillo >Enviado el: sábado, 19 de noviembre de 2011 01:14 >Para: pgsql-es-ayuda@postgresql.org >CC: alvhe...@alvh.no-ip.org; ja...@2ndquadrant.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? > >
