In addition to what Rodrigo said so eloquently
in Portuguese (no fallu prtugues! <vbg>), the only issue you will
experience is a performance hit. It is not a good idea to have 2 separate
database servers running on the same set of drive spindles. I usually deploy
them in different servers. That way, the MS SQL Servr has priority access to
the resources on the SQL Server box,, and the PostgreSQL on the PostgreSQL
box. The other thing to take into account is that SQL Server needs lots of memory
to operate, whereas from my experience PostgreSQL is a lot better with
resources. Depending on the amount of memory on the box, PostgreSQl may not
have enough left for it by SQL Server to run effectively. From:
pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Rodrigo Sakai Cara amiga brasileira! Como já
respondido pelo Magnus, não tem absolutamente nenhum problema! Mas veja que se
for um ambiente em produção isso pode gerar problemas futuros em relação ao
desempenho! Abraços! De: pgsql-admin-owner@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] Em
nome de Érica J. B. Viana Cruz Dear
colleagues,
Good morning and greetings from Brazil!!
May anyone help me with a question... I'm
working on a project and we are supposed to use Microsoft SQLServer and
PostgreSQL on the same server. There was any problem or risk on this? Anyone
has worked on the same situation?
I searched on the web and on documentation and I could not find out comments
about it.
Any help will be appreciated :) Thanks
in advance, |