無法以 ADO-ODBC聯上Win的pg 小弟在NTFS-Win2K上裝好pg8.03及pgodbc8.0後，進pgAdmin開了一個 測試的資料庫，及Create一個Table及用Insert加了幾筆資料到這個 table中，並用Select看過這個表的新資料也沒問題。 我也看過 ..\postgre\8.0\data\pg_hba.conf中也有 host all all 127.0.0.1/32 md5 可是我進Delphi以Ado-ODBC聯時就出現 Could not connect to Server Could not Connect to remote server 這是怎麼回事？試了好久了。 我在資庫網查了好久，我的ODBC設定應該也沒問題，如下 DataSource=>test_pg DataBaseName=>testdb Server=>192.168.1.10 userName=>postgres port=>5432 password=>XXXXXX 真快瘋了。 那位前輩幫個忙吧。小弟感激不盡。 發表人 - kevin2004 於 2005/07/13 19:50:39

------
Kevin

小弟正瘋狂的把pgHelp中所有的文章及資料全印出來在奮戰中， 快油盡燈枯了。有人救命嗎？ Kevin

------
Kevin

將 Server 端的 pg_hba.conf 設定檔 把 host all all 127.0.0.1/32 md5 改成 host all all 0.0.0.0 0.0.0.0 md5 重新啟動 PostgreSQL 就可以了. 雪龍 http://bestlong.no-ip.com/ 學海無涯覺無盡，勤做筆記防失憶

------
http://blog.bestlong.idv.tw/
http://www.bestlong.idv.tw/
http://delphi-ktop.bestlong.idv.tw/

md5 改成 password 試試 -- hagar.

謝謝兩位前輩。小弟試過以下，均失敗了。 ==>host all all 0.0.0.0 0.0.0.0 md5 ==>host all postgres 127.0.0.1/32 md5 ==>host all postgres 127.0.0.1/32 123456 //123456為postgres的密碼 小弟也進過pgAdmin下過grant all 給public，而且小弟的ODBC的userName為postgres，也以postgres重新登錄過。 小弟只在pg的機械上設過 pg_hba.conf，而沒有改pg_ident.conf及postgresql.conf這兩個檔。 而且小弟改過pg_hba.conf後均有Stop pg service及reStart Service 為何Delphi-Ado-MS-OLE Privider for ODBC聯不上pg？懇請前輩們提攜後學。謝謝。 Kevin

------
Kevin

而且小弟在 Delphi-AdoConnection1的提供者發現了一個新的 『PostgreSQL OLE DB Provider』的項目，不知道這個要如何設？是否可以用這個來聯pg？ 小弟初學pg，凡事皆不懂，可是還真是很有興趣。先謝謝各位前輩的指點。 Kevin

------
Kevin

小弟找到這一篇 http://delphi.ktop.com.tw/topic.php?topic_id=24931 裏密面有講到 postgresql.conf 中要設 port=5432 //這有找到 tcpip_socket=true //這行沒找到，改過了也不行 Kevin 發表人 - kevin2004 於 2005/07/14 21:50:25

------
Kevin

總之，要如何由Delphi-Ado聯上Win-pg？不用ODBC也沒關係，只要聯上就好。 Kevin

------
Kevin

PostgreSQL Server 的作業系統為何 ? 若是 XP SP2 請關閉內建防火牆或開放 5432 Port. 雪龍 http://bestlong.no-ip.com/ 學海無涯覺無盡，勤做筆記防失憶

------
http://blog.bestlong.idv.tw/
http://www.bestlong.idv.tw/
http://delphi-ktop.bestlong.idv.tw/

看文件就要看 PostgreSQL 8.X 版本的文件 將設定檔 postgresql.conf 請修改或加入 listen_addresses = '*' 雪龍 http://bestlong.no-ip.com/ 學海無涯覺無盡，勤做筆記防失憶 發表人 - bestlong 於 2005/07/14 22:59:16

------
http://blog.bestlong.idv.tw/
http://www.bestlong.idv.tw/
http://delphi-ktop.bestlong.idv.tw/

謝謝前輩回覆。 小弟是用Win2K，是用Pccillin但防火牆未啟動。 postgresql.conf的listen_addresses被Mark掉了，但我打開及設為'*'了也不行。 我有照『PostgreSQL實務應用』這本書講的用BDE-Administrator去接，也是這個ErrorMsg。 我有去資庫網找了好久，有一篇講的ErrorMsg跟我的完全一樣，他的解 決的辦法是在啟動pg時要傳入 -i 參數給postmaster，可是我看了老半天 postgresql.conf沒有看到如何設啟動參數的地方。 而且好像很多Win-PG接Delphi-Ado-ODBC大都很順利的，為何我弄了好久起不來。 Kevin

------
Kevin

[PostgreSQL 實務應用] 這本書所講解的 PostgreSQL 版本應該試 7.X 的版本.    請再重新確認一次    設定檔 postgresql.conf 內容

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The '=' is optional.) White space may be used. Comments are introduced
# with '#' 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.
#
# Please note that re-commenting a setting is NOT sufficient to revert it
# to the default value, unless you restart the postmaster.
#
# 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.
#
# This file is read on postmaster startup and when the postmaster
# receives a SIGHUP. If you edit the file on a running system, you have 
# to SIGHUP the postmaster for the changes to take effect, or use 
# "pg_ctl reload". Some settings, such as listen_address, require
# a postmaster shutdown and restart to take effect.    #---------------------------------------------------------------------------
# FILE LOCATIONS
#---------------------------------------------------------------------------    # The default values of these variables are driven from the -D command line
# switch or PGDATA environment variable, represented here as ConfigDir.
# data_directory = 'ConfigDir'                # use data in another directory
# hba_file = 'ConfigDir/pg_hba.conf'        # the host-based authentication file
# ident_file = 'ConfigDir/pg_ident.conf'  # the IDENT configuration file    # If external_pid_file is not explicitly set, no extra pid file is written.
# external_pid_file = '(none)'                # write an extra pid file    #---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------    # - Connection Settings -    #listen_addresses = 'localhost'        # what IP interface(s) to listen on; 
                                # defaults to localhost, '*' = any
listen_addresses = '*'
port = 5432
max_connections = 100
        # note: increasing max_connections costs about 500 bytes of shared
        # memory per connection slot, in addition to costs from shared_buffers
        # and max_locks_per_transaction.
#superuser_reserved_connections = 2
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777        # octal
#rendezvous_name = ''                # defaults to the computer name    # - Security & Authentication -    #authentication_timeout = 60        # 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false    #---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------    # - Memory -    shared_buffers = 1000                # min 16, at least max_connections*2, 8KB each
#work_mem = 1024                # min 64, size in KB
#maintenance_work_mem = 16384        # min 1024, size in KB
#max_stack_depth = 2048                # min 100, size in KB    # - Free Space Map -    #max_fsm_pages = 20000                # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000        # min 100, ~50 bytes each    # - Kernel Resource Usage -    #max_files_per_process = 1000        # min 25
#preload_libraries = ''    # - Cost-Based Vacuum Delay -    #vacuum_cost_delay = 0                # 0-1000 milliseconds
#vacuum_cost_page_hit = 1        # 0-10000 credits
#vacuum_cost_page_miss = 10        # 0-10000 credits
#vacuum_cost_page_dirty = 20        # 0-10000 credits
#vacuum_cost_limit = 200        # 0-10000 credits    # - Background writer -    #bgwriter_delay = 200                # 10-10000 milliseconds between rounds
#bgwriter_percent = 1                # 0-100% of dirty buffers in each round
#bgwriter_maxpages = 100        # 0-1000 buffers max per round    #---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------    # - Settings -    #fsync = true                        # turns forced synchronization on or off
#wal_sync_method = fsync        # the default varies across platforms:
                                # fsync, fdatasync, fsync_writethrough,
                                # open_sync, open_datasync
#wal_buffers = 8                # min 4, 8KB each
#commit_delay = 0                # range 0-100000, in microseconds
#commit_siblings = 5                # range 1-1000    # - Checkpoints -    #checkpoint_segments = 3        # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 300        # range 30-3600, in seconds
#checkpoint_warning = 30        # 0 is off, in seconds    # - Archiving -    #archive_command = ''                # command to use to archive a logfile segment    #---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------    # - Planner Method Configuration -    #enable_hashagg = true
#enable_hashjoin = true
#enable_indexscan = true
#enable_mergejoin = true
#enable_nestloop = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true    # - Planner Cost Constants -    #effective_cache_size = 1000        # typically 8KB each
#random_page_cost = 4                # units are one sequential page fetch cost
#cpu_tuple_cost = 0.01                # (same)
#cpu_index_tuple_cost = 0.001        # (same)
#cpu_operator_cost = 0.0025        # (same)    # - Genetic Query Optimizer -    #geqo = true
#geqo_threshold = 12
#geqo_effort = 5                # range 1-10
#geqo_pool_size = 0                # selects default based on effort
#geqo_generations = 0                # selects default based on effort
#geqo_selection_bias = 2.0        # range 1.5-2.0    # - Other Planner Options -    #default_statistics_target = 10        # range 1-1000
#from_collapse_limit = 8
#join_collapse_limit = 8        # 1 disables collapsing of explicit JOINs    #---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------    # - Where to Log -    log_destination = 'stderr'        # Valid values are combinations of stderr,
                                # syslog and eventlog, depending on
                                # platform.    # This is relevant when logging to stderr:
redirect_stderr = true    # Enable capturing of stderr into log files.
# These are only relevant if redirect_stderr is true:
#log_directory = 'pg_log'   # Directory where log files are written.
                            # May be specified absolute or relative to PGDATA
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
                            # May include strftime() escapes
#log_truncate_on_rotation = false  # If true, any existing log file of the 
                            # same name as the new log file will be truncated
                            # rather than appended to.  But such truncation
                            # only occurs on time-driven rotation,
                            # not on restarts or size-driven rotation.
                            # Default is false, meaning append to existing 
                            # files in all cases.
#log_rotation_age = 1440    # Automatic rotation of logfiles will happen after
                            # so many minutes.  0 to disable.
#log_rotation_size = 10240  # Automatic rotation of logfiles will happen after
                            # so many kilobytes of log output.  0 to disable.    # 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:
                                #   debug5, debug4, debug3, debug2, debug1,
                                #   log, notice, warning, error    #log_min_messages = notice        # Values, in order of decreasing detail:
                                #   debug5, debug4, debug3, debug2, debug1,
                                #   info, notice, warning, error, log, fatal,
                                #   panic    #log_error_verbosity = default        # terse, default, or verbose messages    #log_min_error_statement = panic # Values in order of increasing severity:
                                 #   debug5, debug4, debug3, debug2, debug1,
                                 #   info, notice, warning, error, panic(off)
                                 
#log_min_duration_statement = -1 # -1 is disabled, in milliseconds.    #silent_mode = false                 # DO NOT USE without syslog or redirect_stderr    # - What to Log -    #debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
#log_connections = false
#log_disconnections = false
#log_duration = false
log_line_prefix = '%t '                # e.g. '<%u%%%d> ' 
                                # %u=user name %d=database name
                                # %r=remote host and port
                                # %p=PID %t=timestamp %i=command tag
                                # %c=session id %l=session line number
                                # %s=session start timestamp %x=transaction id
                                # %q=stop here in non-session processes
                                # %%='%'
#log_statement = 'none'                # none, mod, ddl, all
#log_hostname = false    #---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------    # - Statistics Monitoring -    #log_parser_stats = false
#log_planner_stats = false
#log_executor_stats = false
#log_statement_stats = false    # - Query/Index Statistics Collector -    #stats_start_collector = true
#stats_command_string = false
#stats_block_level = false
#stats_row_level = false
#stats_reset_on_server_start = true    #---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------    # - Statement Behavior -    #search_path = '$user,public'        # schema names
#default_tablespace = ''        # a tablespace name, or '' for default
#check_function_bodies = true
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = false
#statement_timeout = 0                # 0 is disabled, in milliseconds    # - Locale and Formatting -    #datestyle = 'iso, mdy'
#timezone = unknown                # actually, defaults to TZ environment setting
#australian_timezones = false
#extra_float_digits = 0                # min -15, max 2
#client_encoding = sql_ascii        # actually, defaults to database encoding    # These settings are initialized by initdb -- they might be changed
lc_messages = 'Chinese_Taiwan'                # locale for system error message strings
lc_monetary = 'Chinese_Taiwan'                # locale for monetary formatting
lc_numeric = 'Chinese_Taiwan'                # locale for number formatting
lc_time = 'Chinese_Taiwan'                        # locale for time formatting    # - Other Defaults -    #explain_pretty_print = true
#dynamic_library_path = '$libdir'    #---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------    #deadlock_timeout = 1000        # in milliseconds
#max_locks_per_transaction = 64        # min 10, ~200*max_connections bytes each    #---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------    # - Previous Postgres Versions -    #add_missing_from = true
#regex_flavor = advanced        # advanced, extended, or basic
#sql_inheritance = true
#default_with_oids = true    # - Other Platforms & Clients -    #transform_null_equals = false

設定檔 pg_hba.conf 內容

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description.  A short synopsis
# follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access.  Records take one of these forms:
#
# local      DATABASE  USER  METHOD  [OPTION]
# host       DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTION]
# hostssl    DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTION]
# hostnossl  DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTION]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain socket,
# "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an
# SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.
#
# DATABASE can be "all", "sameuser", "samegroup", a database name, or
# a comma-separated list thereof.
#
# USER can be "all", a user name, a group name prefixed with " ", or
# a comma-separated list thereof.  In both the DATABASE and USER fields
# you can also write a file name prefixed with "@" to include names from
# a separate file.
#
# CIDR-ADDRESS specifies the set of hosts the record matches.
# It is made up of an IP address and a CIDR mask that is an integer
# (between 0 and 32 (IPv6) or 128(IPv6) inclusive) that specifies
# the number of significant bits in the mask.  Alternatively, you can write
# an IP address and netmask in separate columns to specify the set of hosts.
#
# METHOD can be "trust", "reject", "md5", "crypt", "password",
# "krb4", "krb5", "ident", or "pam".  Note that "password" sends passwords
# in clear text; "md5" is preferred since it sends encrypted passwords.
#
# OPTION is the ident map or the name of the PAM service, depending on METHOD.
#
# Database and user names containing spaces, commas, quotes and other special
# characters must be quoted. Quoting one of the keywords "all", "sameuser" or
# "samegroup" makes the name lose its special character, and just match a
# database or username with that name.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal.  If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect.  You can use
# "pg_ctl reload" to do that.    # Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL listen
# on a non-local interface via the listen_addresses configuration parameter,
# or via the -i or -h command line switches.
#        # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD    # IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         0.0.0.0/0       md5
# IPv6 local connections:
#host    all         all         ::1/128               md5

雪龍 http://bestlong.no-ip.com/ 學海無涯覺無盡，勤做筆記防失憶

------
http://blog.bestlong.idv.tw/
http://www.bestlong.idv.tw/
http://delphi-ktop.bestlong.idv.tw/

接上篇... 設定檔修改好後, 將 PostgreSQL 8.0 重新啟動或是 Reload Configuration 一次. 先在同一台電腦使用 pgAdmin III 作測試, 先連接位址：localhost 使用帳號：postgres 若可以登入 再連接一次同一台電腦的 IP 位址：192.168.X.X 使用帳號：postgres 若可以登入 到其他的電腦同樣使用 pgAdmin III 作遠端連接測試 連接 PostgreSQL DB 所在的電腦 IP 位址：192.168.X.X 使用帳號：postgres 以上都沒問題的話. 再確認 ADO-ODBC 連結有沒有問題. 雪龍 http://bestlong.no-ip.com/ 學海無涯覺無盡，勤做筆記防失憶

------
http://blog.bestlong.idv.tw/
http://www.bestlong.idv.tw/
http://delphi-ktop.bestlong.idv.tw/

誤會小弟的意思了 小弟的意思是改成如下: host all all 0.0.0.0 0.0.0.0 password host all postgres 127.0.0.1/32 password 是用關鍵字 password, 不是真地把 password 的內容打出來 md5 關鍵字的意思是把密碼做 md5 編碼再傳至 Server 做驗證 除非您先把密碼 123456 以 md5 的方式編碼來能成功驗證登入 其它關鍵字像是 trust 表示用不用密碼都可以登入 您可以試試 -- hagar. 發表人 - hagar 於 2005/07/15 07:05:21

謝謝兩位前輩的幫忙，小弟再試試。 為了這個困擾的問題，小弟竟然出現了幾根白髮。 不經一番寒澈骨，怎得梅花撲鼻香。 雖然還在努力中，但真有點回首來時路的感覺.. Kevin 發表人 - kevin2004 於 2005/07/15 07:18:35

------
Kevin

抱歉現在才回，小弟這兩天白天黑夜在趕老板交辦的工作，半夜回家後 才能試。承各位前輩熱心指點，今天總算給我試出來聯上去了，我還試者把Paradox及Access的資料轉移到pg上，當然還是有幾個表有點問題，不過這 應該是parados/access/pg-create-sql些須差異造成的。試到現在總算出 來了，小弟真有點油盡燈枯的感覺，真要先去睡一下，明日再來報告測試 結果。 再次謝謝各位前輩幫忙。小弟感激不盡。多了個Win-pg真是亂亂好用， 亂亂過癮之事。 Kevin

------
Kevin