From: | Secrétariat <ets(at)rolland-fr(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: No connection to a PG 8.0 Beta 1 win32 server |
Date: | 2004-08-24 10:29:45 |
Message-ID: | 000c01c489c5$47046710$0a00a8c0@lrp43008 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello !
I've corrected my win32 pg_hba.conf, it contains :
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.0.0 255.255.255.0 md5
but I can't connect from my W2k client at IP 192.168.0.11 !
My postgresql.conf contains :
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------
# - Connection Settings -
#listen_addresses = 'localhost' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
tcpip_socket = true
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
I create (in bin) the script reload.bat to reload the service :
@echo.
@C:\WINDOWS\system32\net.exe stop pgsql-8.0-beta1
@echo.
@C:\WINDOWS\system32\net.exe start pgsql-8.0-beta1
pause
With "tcpip_socket = true" the script reload.bat stop the service but can't
start !?
So I can't connect from the W2k client ...
With "#tcpip_socket = true" the script reload.bat stop and start the
service.
But can't connect from the W2k client .
I define NT user variables :
PGDATA=C:\Program Files\PostgreSQL\8.0-beta1\data
PGPORT=5432
No change.
I don't understand what happen ...
Luc
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Martini | 2004-08-24 10:30:55 | Re: pg_dump in stand alone backend |
Previous Message | Richard Huxton | 2004-08-24 10:04:48 | Re: pg_dump in stand alone backend |