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_connections = 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
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 |