Postgresql 8.3

From: Edgar Enriquez <edgarpostgres(at)yahoo(dot)es>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Postgresql 8.3
Date: 2008-06-18 13:16:39
Message-ID: 541921.23367.qm@web28207.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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.

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message leonel 2008-06-18 13:34:26 Re: Postgresql 8.3
Previous Message Alvaro Herrera 2008-06-18 12:58:55 Re: Copia y restauracion de base de datos de GForge