Bonjour à tous,
tout d'abord j'ai déjà posté un post mais une autre personne est venu y mettre ses problemes donc forcement on a répondu à ces questions cela dit cela m'a aidé un peu mais je suis toujours aussi perdu.

Je travaille sous linux red hat 7.3 j'ai installé postgresql qui marche, j'ai crée une base de donnée nommé GDBASE avec pgsql(sans interface graphique) cela marche, mais je souhaite utiliser pgAccess(interface graphique), donc je l'ai installé il démarre mais je ne peu me connecter l'erreur est la suivante :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
Error trying to connect database 'GDBASE' on host localhost
PostgreSQL error message:Connection to database failes could'nt open socket:connection refused
Mon fichier pg_hda.conf est écrit ainsi :
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
 
# Put your actual configuration here
# ==================================
#
# This default configuration allows any local user to connect with any
# PostgreSQL username, over either UNIX domain sockets or IP.
# GDBASE
# If you want to allow non-local connections, you wilpostmasterl need to add more
# "host" records. Also, remember IP connections are only enabled if you
# start the postmaster with the -i option.
#
# CAUTION: if you are on a multiple-user machine, the default
# configuration is probably too liberal for you. Change it to use
# something other than "trust" authentication.
#
# TYPE     DATABASE   USER  IP_ADDRESS      MASK                AUTH_TYPE  AUTH_ARGUMENT
#local       all       all                                       trust
#host        all       all   127.0.0.1       255.0.0.0           trust
#local       all       postgres   192.101.0.0     255.255.255.0       trust
 
# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)
 
local all ident sameuser
Le fichier postgresql.conf :
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
 
#
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form
#
#   name = value
#
# (The `=' is optional.) White space is collapsed, comments are
# introduced by `#' anywhere on a line.  The complete list of option
# names and allowed values can be found in the PostgreSQL
# documentation.  The commented-out settings shown in this file
# represent the default values.
 
# Any option can also be given as a command line switch to the
# postmaster, e.g., 'postmaster -c log_connections=on'. Some options
# can be changed at run-time with the 'SET' SQL command.
 
 
#========================================================================
 
 
#
# Connection Parameters
#
tcpip_socket = true
#ssl = true
 
#max_connections = 32
#superuser_reserved_connections = 2
 
port = 5432
#hostname_lookup = true
#show_source_port = false
 
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
 
#virtual_host = ''
 
#krb_server_keyfile = ''
 
 
#
# Shared Memory Size
#
#shared_buffers = 64 # min max_connections*2 or 16,8KB each
#max_fsm_relations = 1000    # min 10, fsm is free space map, ~40 bytes
#max_fsm_pages = 10000      # min 1000, fsm is free space map,~6bytes
#max_locks_per_transaction = 64 # min 10
#wal_buffers = 8            # min 4,typically 8KB each
 
#
# Non-shared Memory Sizes
#
#sort_mem = 1024             # min 64,size in KB
#vacuum_mem = 8192          # min 1024,size in KB
 
 
#
# Write-ahead log (WAL)
#
#wal_files = 0 # range 0-64
#wal_sync_method = fsync   # the default varies across platforms:
#      # fsync, fdatasync, open_sync, or open_datasync
#wal_debug = 0             # range 0-16
#commit_delay = 0          # range 0-100000
#commit_siblings = 5       # range 1-1000
#checkpoint_segments = 3   # in logfile segments (16MB each), min 1
#checkpoint_timeout = 300  # in seconds, range 30-3600
#fsync = true
 
 
#
# Optimizer Parameters
#
#enable_seqscan = true
#enable_indexscan = true
#enable_tidscan = true
#enable_sort = true
#enable_nestloop = true
#enable_mergejoin = true
#enable_hashjoin = true
 
#ksqo = false
 
#effective_cache_size = 1000  # default in 8k pages
#random_page_cost = 4
#cpu_tuple_cost = 0.01
#cpu_index_tuple_cost = 0.001
#cpu_operator_cost = 0.0025
 
 
#
# GEQO Optimizer Parameters
#
#geqo = true
#geqo_selection_bias = 2.0 # range 1.5-2.0
#geqo_threshold = 11
#geqo_pool_size = 0        # default based on #tables in query, range 128-1024
#geqo_effort = 1
#geqo_generations = 0
#geqo_random_seed = -1     # auto-compute seed
 
 
#
# Debug display
#
#silent_mode = false
 
#log_connections = false
#log_timestamp = false
#log_pid = false
 
#debug_level = 0 # range 0-16
 
#debug_print_query = false
#debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
 
# requires USE_ASSERT_CHECKING
#debug_assertions = true
 
 
#
# Syslog
#
# requires ENABLE_SYSLOG
#syslog = 0 # range 0-2
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
 
 
#
# Statistics
#
#show_parser_stats = false
#show_planner_stats = false
#show_executor_stats = false
#show_query_stats = false
 
# requires BTREE_BUILD_STATS
#show_btree_build_stats = false
 
 
#
# Access statistics collection
#
#stats_start_collector = true
#stats_reset_on_server_start = true
#stats_command_string = false
#stats_row_level = false
#stats_block_level = false
 
 
#
# Lock Tracing
#
#trace_notify = false
 
# requires LOCK_DEBUG
#trace_locks = false
#trace_userlocks = false
#trace_lwlocks = false
#debug_deadlocks = false
#trace_lock_oidmin = 16384
#trace_lock_table = 0
 
 
#
# Misc
#
#dynamic_library_path = '$libdir'
#australian_timezones = false
#authentication_timeout = 60    # min 1, max 600
#deadlock_timeout = 1000
#default_transaction_isolation = 'read committed'
#max_expr_depth = 10000         # min 10
#max_files_per_process = 1000   # min 25
#password_encryption = false
#sql_inheritance = true
#transform_null_equals = false
Je sais qu'il y a de nombreux postes sur ce sujet mais même en les étudiant je n'arrive pas à régler mon problème et cela dure depuis un petit moment, je suis vraiment novice autant en postgresql qu'en pgaccess, alors s'il ya quelqu'un qui peut me dire ce que j'ai fait en + ou ce que je n'ai pas fait je lui en serai vraiment reconnaissant...

Merci d'avance