Re: trouble connecting to DB - Mailing list pgsql-novice

From Lacey Powers
Subject Re: trouble connecting to DB
Date
Msg-id 4A66602D.7030704@commandprompt.com
Whole thread Raw
In response to Re: trouble connecting to DB  ("tgs" <tgstambaugh@q.com>)
List pgsql-novice
Hello Terry,

What are your Windows Firewall/Other Firewall/Antivirus settings?

It would be worthwhile to check them, because they may be causing trouble.

Additionally, this may help.

http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows

Lacey
 
Thanks for the reply Thomas.  Yes, per my prior post I'm using Windows XP Pro.  I have verified the installer gave the postgres user full control on all the subdirectories, and also manually added it for the two parents, (8.4, and postgresql).
 
I've changed the debug level to 'debug5' to  try to see what's going on - as per the prior post I'm getting alternating log entries...

incomplete startup packet

could not receive data from client: An operation was attempted on something that is not a socket.

...repeatedly until the service times out.  When that happens, there are several instances of postgreql.exe running, but the service is not recognized as running.  Attempting to stop the service results in the message 'Service is not started', and I have to manually kill the processes and delete the leftover postmaster.pid file to start again.  I'm really stuck on this one.

Thanks,

Terry S. in AZ

 

 

 

 


-- 
Lacey Powers

The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 104
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-novice by date:

Previous
From: Lacey Powers
Date:
Subject: Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.
Next
From: Michael Wood
Date:
Subject: Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.