Greetings!
In an attempt to satisfy our client's requirements for redundancy, we ended up with an unusual (at least to my inexperienced eyes) system configuration. Our client has two buildings that use our application. Each building has an application server and a storage server. All are runnning Windows Server 2003. An iSCSI controller running on a building's storage server is configured to map an image on the D drive of that server to appear as the H drive on the building's application server. So, anything written to the H drive by the application server actually is stored in STORAGE\\d:/DataStorage/data.img. PostgreSQL 8.4 is running on the application server, configured to use the H drive to store data. Therefore, data is actually being stored on the storage server's D drive.
The storage servers for each building also have the task of backing up data for the other building. Symantec's Backup Exec is used for that purpose. But we found that when the backup job that was supposed to back up one building's storage server ran, the PostgreSQL service on that building's application server stopped. We tried excluding the folder containing the image used as the H drive from the backup, but it didn't help.
Has anyone else seen a Backup Exec backup job stop a Postgres service? Can anyone suggest ways to avoid the problem? (I'm already fighting to run PostgreSQL on the storage server instead of the application server. I see no benefit to having the service running on one machine and storing data on the other. If a terrorist blows up the storage server, it will take all of ten minutes to re-install PostgreSQL.)
RobR
