X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 509B29FA999 for ; Mon, 26 Jun 2006 17:44:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 12218-03 for ; Mon, 26 Jun 2006 17:44:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 253909FA6B3 for ; Mon, 26 Jun 2006 17:44:30 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C69961.4F86CE18" Subject: Re: Using PostgreSQL and MIcrosoft SQLServer on the same server X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Mon, 26 Jun 2006 14:44:25 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Using PostgreSQL and MIcrosoft SQLServer on the same server thread-index: AcaZI8oWn3abx4maS12muJKkVHd/gQAOlEWwAACscSA= From: "Benjamin Krajmalnik" To: , =?iso-8859-1?Q?=C9rica_J=2E_B=2E_Viana_Cruz?= , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/240 X-Sequence-Number: 22202 This is a multi-part message in MIME format. ------_=_NextPart_001_01C69961.4F86CE18 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable In addition to what Rodrigo said so eloquently in Portuguese (no fallu = prtugues! ), 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. =20 =20 ________________________________ From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rodrigo Sakai Sent: Monday, June 26, 2006 2:25 PM To: '=C9rica J. B. Viana Cruz'; pgsql-admin@postgresql.org Subject: RES: [ADMIN] Using PostgreSQL and MIcrosoft SQLServer on the = same server =20 Cara amiga brasileira! Como j=E1 respondido pelo Magnus, n=E3o tem = absolutamente nenhum problema! Mas veja que se for um ambiente em = produ=E7=E3o isso pode gerar problemas futuros em rela=E7=E3o ao = desempenho! Abra=E7os! =20 =20 ________________________________ De: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] Em nome de =C9rica J. B. Viana = Cruz Enviada em: segunda-feira, 26 de junho de 2006 10:19 Para: pgsql-admin@postgresql.org Assunto: [ADMIN] Using PostgreSQL and MIcrosoft SQLServer on the same = server =20 Dear colleagues, =20 Good morning and greetings from Brazil!! May anyone help me with a question...=20 =20 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? =20 I searched on the web and on documentation and I could not find out = comments about it. =20 Any help will be appreciated :) =20 Thanks in advance, =20 --=20 =C9rica J. B. Viana Cruz ericaviana@gmail.com=20 ------_=_NextPart_001_01C69961.4F86CE18 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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.=A0 I usually = deploy them in different servers.=A0 That way, the MS SQL Servr has priority = access to the resources on the SQL Server box,, and the PostgreSQL on the = PostgreSQL box.=A0 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.=A0 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@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rodrigo Sakai
Sent: Monday, June 26, = 2006 2:25 PM
To: '=C9rica J. B. Viana = Cruz'; pgsql-admin@postgresql.org
Subject: RES: [ADMIN] = Using PostgreSQL and MIcrosoft SQLServer on the same = server

 

  Cara amiga brasileira! Como = j=E1 respondido pelo Magnus, n=E3o tem absolutamente nenhum problema! Mas = veja que se for um ambiente em produ=E7=E3o isso pode gerar problemas futuros em = rela=E7=E3o ao desempenho!

  = Abra=E7os!

 

 


De: = pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Em nome de =C9rica J. B. Viana Cruz
Enviada em: = segunda-feira, 26 de junho de 2006 10:19
Para: = pgsql-admin@postgresql.org
Assunto: [ADMIN] Using = PostgreSQL and MIcrosoft SQLServer on the same server

 

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,   
--
=C9rica J. B. Viana Cruz
ericaviana@gmail.com =

------_=_NextPart_001_01C69961.4F86CE18--