Re: trouble connecting to DB

Поиск
Список
Период
Сортировка
От Lacey Powers
Тема Re: trouble connecting to DB
Дата
Msg-id 4A66602D.7030704@commandprompt.com
обсуждение исходный текст
Ответ на Re: trouble connecting to DB  ("tgs" <tgstambaugh@q.com>)
Список 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 по дате отправления:

Предыдущее
От: Lacey Powers
Дата:
Сообщение: Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.
Следующее
От: Michael Wood
Дата:
Сообщение: Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.