We have a customer who is running PostgreSQL 8.4 on a Windows Server 2003 box. The Postgres service is set up to store data on the computer's H drive, which is actually an iSCSI connection to a folder of a disk drive on a separate computer. The same computer that runs PostgreSQL also runs the Kepware OPC server. If a user needs to connect remotely to this computer to change something in the OPC server, he has to connect using "mstsc /admin". More often than not, when a user connects remotely using the /admin option, PostgreSQL will crash. The only indication of a problem left in the log file is a message saying that error 128 happened, which is a problem with a child process. It does not say which process, or what the problem was.
The only reference we were able to find on the Web for this problem said that it went away when the user upgraded from 8.3.1 to 8.4. That was why we did the same upgrade. For us, the problem still exists.
Has anyone else seen and fixed this problem?
RobR, remaining mystified about why that customer has such as wierd database configuration