Can SQL Server and Postgres live together

Question

Hi,

I was wondering if anyone would give me some advice regarding installing SDE with multiple DBMS on the same server (Windows Server 2008).

We currently have SDE 9.2 running with SQL Server 2008 however a colleague would like to try Postgres on the same server.

Could anyone give me any advice before I start installing software, even if its don't do it! or point me in the direction of previous forum post or white papers I may have missed on my search.

Thank in advance.

David

George_Thompson · Answer

As mentioned it is possible to have 2 RDBMS's on the same server (I have them both on my machine for testing), but I would NOT recommend it for a production environment. There are many reasons not to do this.

It would be recommended to keep them on separate machines / VM's.

chessgoh · Answer

Hi DavidEdmunds,

How is the experienced of having SQL and Postgre on same server? Are you facing any problem in terms of administration, performance, upgrade and etc. I am looking at building both DBMs on a same server for production use.

Thanks in advance for the answer.

DavidEdmends · Answer

Thanks Vince,

I'll give it a go and post back to the forum my experience.

Cheers

David