pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Benjamin Krajmalnik <kraj@illumen.com>
To: rodrigo.sakai@zanthus.com.br
To: Érica J. B. Viana Cruz <ericaviana@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Using PostgreSQL and MIcrosoft SQLServer on the same server
Date: Mon, 26 Jun 2006 14:44:25 -0600
Message-ID: <BF337097BDD9D849A2F4B818DDB279870293A0@stash.stackdump.local> (raw)

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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rodrigo Sakai
Sent: Monday, June 26, 2006 2:25 PM
To: 'Érica 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á 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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Em nome de Érica 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,    
-- 
Érica J. B. Viana Cruz
ericaviana@gmail.com 

view thread (4+ messages)  latest in thread

Message-ID: <BF337097BDD9D849A2F4B818DDB279870293A0@stash.stackdump.local>
Permalink:  ../BF337097BDD9D849A2F4B818DDB279870293A0@stash.stackdump.local/
Also on:    postgresql.org/message-id/BF337097BDD9D849A2F4B818DDB279870293A0@stash.stackdump.local

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kraj@illumen.com, rodrigo.sakai@zanthus.com.br, ericaviana@gmail.com
  Subject: Re: Using PostgreSQL and MIcrosoft SQLServer on the same server
  In-Reply-To: <BF337097BDD9D849A2F4B818DDB279870293A0@stash.stackdump.local>
  References: <BF337097BDD9D849A2F4B818DDB279870293A0@stash.stackdump.local>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox