Re: Postgresql 8.3

Edgar Enriquez wrote:
> Hola lista, este es mi primer mensaje y es para comentarles que vengo de instalar postgres 8.3.3 en windows y en linux ubuntu 8.04 para povarla pero no logro conectarme des de otra pc, ya cambie los archivos de configuración pg_hba para dejarlo asi:
>
>
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
> host all all 192.168.100.0 255.255.255.0 md5
> y el fichero postgres.config esta asi:
>
>
> #------------------------------------------------------------------------------
> # CONNECTIONS AND AUTHENTICATION
> #------------------------------------------------------------------------------
>
> # - Connection Settings -
>
> #listen_addresses = 'localhost' # what IP address(es) to listen on;
> listen_addresses = '*'
>
> # 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). You might
> # also need to raise shared_buffers to support more connections.
> #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_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)
> #password_encryption = on
> #db_user_namespace = off
>
> # Kerberos and GSSAPI
> #krb_server_keyfile = '' # (change requires restart)
> #krb_srvname = 'postgres' # (change requires restart, Kerberos only)
> #krb_server_hostname = '' # empty string matches any keytab entry
> # (change requires restart, Kerberos only)
> #krb_caseins_users = off # (change requires restart)
> #krb_realm = '' # (change requires restart)
>
> # - 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 defaultSin embargo no puedo conectarme ni via pgAdminIII ni por JODBC, cuando utilizo la direccion 192.168.1.126, solo puedo hacerlo si utilizo 'localhost', desactive el firewall del cliente y del servidor para estar seguro
>
> Gracias por su ayuda
>
>
>
> ______________________________________________
> Enviado desde Correo Yahoo! La bandeja de entrada más inteligente.
>

y... reiniciaste postgresql ??