Bonjour

Apres avoir suivi la doc de Postgresql, j'ai les fichiers suivants :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
# -----------------------------
# PostgreSQL configuration file
# -----------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------
data_directory = '/media/databases/pgsql/data/'		# use data in another directory
					# (change requires restart)
hba_file = '/media/databases/pgsql/data/pg_hba.conf'	# host-based authentication file
					# (change requires restart)
ident_file = '/media/databases/pgsql/data/pg_ident.conf'	# ident configuration file
					# (change requires restart)
 
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
 
# - Connection Settings -
 
listen_addresses = 'localhost, 192.168.10.2'		# what IP address(es) to listen on;
port = 5432				# (change requires restart)
max_connections = 100			# (change requires restart)
 
# - Security and Authentication -
 
authentication_timeout = 1min		# 1s-600s
ssl = on				# (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
 
# RESOURCE USAGE (except WAL)
#------------------------------------------------------------------------------
 
# - Memory -
 
shared_buffers = 24MB			# min 128kB or max_connections*16kB
max_fsm_pages = 153600			# min max_fsm_relations*16, 6 bytes each
#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------
 
# - Where to Log -
 
log_destination = 'syslog'		# Valid values are combinations of
log_rotation_age = 1d			# Automatic rotation of logfiles will
log_rotation_size = 5MB		# Automatic rotation of logfiles will 
# These are relevant when logging to syslog:
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
# - When to Log -
client_min_messages = notice		# values in order of decreasing detail:
log_min_messages = notice		# values in order of decreasing detail:
log_error_verbosity = default		# terse, default, or verbose messages
log_min_error_statement = error	# values in order of decreasing detail:
log_min_duration_statement = 0	# -1 is disabled, 0 logs all statements
log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on
log_hostname = on
log_line_prefix = '%u %d %h'			# special values:
 
# - Locale and Formatting -
 
datestyle = 'iso, dmy'
lc_messages = 'fr_FR.UTF-8'			# locale for system error message
lc_monetary = 'fr_FR.UTF-8'			# locale for monetary formatting
lc_numeric = 'fr_FR.UTF-8'			# locale for number formatting
lc_time = 'fr_FR.UTF-8'				# locale for time formatting
 
# default configuration for text search
default_text_search_config = 'pg_catalog.french'
et :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
local   all         all                               md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               reject
 
# IPv4 local workstation connections:
hostssl    all         all         192.168.1.2/32      md5
hostssl    all         all         192.168.2.2/32      md5
Mais quand j'essaie de me connecter a partir de 192.168.1.2, j'obtiens :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
#$: psql -U postgres -h 192.168.10.2 -W
Mot de passe pour l'utilisateur postgres : 
psql: erreur SSL : sslv3 alert handshake failure
FATAL:  aucune entrée dans pg_hba.conf pour l'hôte « 192.168.1.2 », utilisateur « postgres »,
base de données « postgres », SSL inactif
J'ai pas mal googueule mais rien trouve d'utile a mon probleme..
Si quelqu'un a une solution, je suis preneur.

-> postgresql 8.3 sur 192.168.10.2
-> postgresql 9.0 sur 192.168.1.2

Merci