Error connecting to remote socket

From: "Sunny" <sunny076(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error connecting to remote socket
Date: 2005-05-06 18:09:11
Message-ID: 1115402951.498584.300190@z14g2000cwz.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2005-05-06 18:11:25 Re: Slony v. DBMirror
Previous Message Jim C. Nasby 2005-05-06 18:07:32 Re: Slony v. DBMirror