Skip site navigation (1) Skip section navigation (2)

Re: No connection to a PG 8.0 Beta 1 win32 server

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 (view raw or flat)
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















Responses

pgsql-general by date

Next:From: Daniel MartiniDate: 2004-08-24 10:30:55
Subject: Re: pg_dump in stand alone backend
Previous:From: Richard HuxtonDate: 2004-08-24 10:04:48
Subject: Re: pg_dump in stand alone backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group