Postgres parando no Windows

Question

Eu tenho um Postgres 9.2 em execução no Windows 7 como um serviço. Todos os dias o banco de dados parece parar e às vezes ele começa a rodar novamente sozinho e às vezes eu preciso reiniciar o serviço. Não há muita informação de log, eu não tenho um antivírus, firewall instalado neste computador. Eu tentei melhorar as informações de log, mas isso não ajudou muito.

Não encontrei o mesmo problema na internet ou aqui no serverfault.

Existem algumas informações de registro:

2016-09-08 06:25:27 BRT [desconhecido] LOG: XX000: não pôde receber dados

from client: unrecognized winsock error 10061
2016-09-08 06:25:27 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 06:25:27 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 06:25:27 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 06:55:39 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 06:55:39 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 06:55:39 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 06:55:39 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 07:15:25 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 07:15:25 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 07:15:25 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 07:15:25 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 10:59:20 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 10:59:20 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 10:59:20 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 10:59:20 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 11:14:55 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 11:14:55 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 11:14:55 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 11:14:55 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 11:16:08 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 11:16:08 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831
2016-09-08 11:16:08 BRT [unknown] LOG:  XX000: could not receive data from client: unrecognized winsock error 10061
2016-09-08 11:16:08 BRT [unknown] LOCATION:  pq_recvbuf, src\backend\libpq\pqcomm.c:831

Se eu deixar o PgAdmin III aberto com as janelas de status do servidor, recebo essas mensagens também.

Alguma dica?

Obrigado

    

Answer 1

Primeiro, execute o servidor de produção em uma máquina de desktop, é uma prática ruim. Eu recomendo que você migre para um servidor dedicado com um sistema operacional de servidor, como servidor Windows, Linux, etc.

Sobre o seu erro ^[1] , parece que você está com um erro de rede:

Connection refused.

No connection could be made because the target computer actively refused it. This usually results from trying to connect to a service that is inactive on the foreign host—that is, one with no server application running.

Dê uma olhada aqui ^[2] para mais detalhes.

Considere minha sugestão se você já desistiu de resolver seus problemas de rede.

Espero que ajude.

Referências:

1. link
2. link