Logging in as console crashes the database - Mailing list pgsql-general

From Rob Richardson
Subject Logging in as console crashes the database
Date
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D013E287E@server.rad-con.local
Whole thread Raw
Responses Re: Logging in as console crashes the database  (John R Pierce <pierce@hogranch.com>)
Re: Logging in as console crashes the database  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
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
 

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: How can I run an external program from a stored procedure?
Next
From: Eliot Gable
Date:
Subject: Re: cannot assign non-composite value to a row variable