Error connecting to remote socket

Поиск
Список
Период
Сортировка
От Sunny
Тема Error connecting to remote socket
Дата
Msg-id 1115402951.498584.300190@z14g2000cwz.googlegroups.com
обсуждение исходный текст
Список pgsql-general
Hi,


I am new to PosGreSql and have problem connecting to PostGreSql from a
machine with pslodbc driver. I don't know what is wrong but in my
simple code to connect to the database using ODBCConnection from the
server machine, it does not send out error message when I specify the
server as 'localhost' but when I set the server as 'Dbsvr' in the
connection string then it sent out ODBC error that it could not connect

to data source, could not connect ot remote socket. I would appreciate
if anyone can enlighten me. My postgresql.conf is below:


"


#-----------------------------­------------------------------­----------------

# 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 = '*' # what IP interface(s) to listen on;
                                # defaults to localhost, '*' = any
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_connection­s = 2
#unix_socket_directory = 'software-labs.net'
#unix_socket_group = 'software-labs.net'
#unix_socket_permissions = 0777 # octal
#rendezvous_name = ''           # defaults to the computer name
#tcpip_socket = true
# - Security & Authentication -


#authentication_timeout = 60    # 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false


"
Thank you in advance,


Sunny


В списке pgsql-general по дате отправления:

Предыдущее
От: Susemail
Дата:
Сообщение: Connecting to Postgres using Rekall
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: pg_ctl bug or feature?