pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing PostgreSQL and MIcrosoft SQLServer on the same server
4+ messages / 4 participants
[nested] [flat]
* Using PostgreSQL and MIcrosoft SQLServer on the same server
@ 2006-06-26 13:18 Érica J. B. Viana Cruz <ericaviana@gmail.com>
2006-06-26 13:26 ` Re: Using PostgreSQL and MIcrosoft SQLServer on the same server Magnus Hagander <mha@sollentuna.net>
0 siblings, 1 reply; 4+ messages in thread
From: Érica J. B. Viana Cruz @ 2006-06-26 13:18 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Using PostgreSQL and MIcrosoft SQLServer on the same server
2006-06-26 13:18 Using PostgreSQL and MIcrosoft SQLServer on the same server Érica J. B. Viana Cruz <ericaviana@gmail.com>
@ 2006-06-26 13:26 ` Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 4+ messages in thread
From: Magnus Hagander @ 2006-06-26 13:26 UTC (permalink / raw)
To: Érica J. B. Viana Cruz <ericaviana@gmail.com>; pgsql-admin
> 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 :)
Should work fine. Just make sure you limit how much memory SQL Server i allowed to use (using Enterprise Manager, properties on the server node). If not, SQL Server will grab all memory on the machine and there will be none left for PostgreSQL or the kernel cache.
//Magnus
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Using PostgreSQL and MIcrosoft SQLServer on the same server
@ 2006-06-26 20:44 Benjamin Krajmalnik <kraj@illumen.com>
2006-07-12 02:45 ` Re: Using PostgreSQL and MIcrosoft SQLServer on the same server Paul S <plabrh1@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Benjamin Krajmalnik @ 2006-06-26 20:44 UTC (permalink / raw)
To: rodrigo.sakai@zanthus.com.br; Érica J. B. Viana Cruz <ericaviana@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Using PostgreSQL and MIcrosoft SQLServer on the same server
2006-06-26 20:44 Re: Using PostgreSQL and MIcrosoft SQLServer on the same server Benjamin Krajmalnik <kraj@illumen.com>
@ 2006-07-12 02:45 ` Paul S <plabrh1@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Paul S @ 2006-07-12 02:45 UTC (permalink / raw)
To: pgsql-admin
I would have to agree with Benjamin here. With the money you save by
running Postgres, you can buy another server. :)
Regards,
Paul
On 6/26/06, Benjamin Krajmalnik <kraj@illumen.com> wrote:
>
> 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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-07-12 02:45 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-26 13:18 Using PostgreSQL and MIcrosoft SQLServer on the same server Érica J. B. Viana Cruz <ericaviana@gmail.com>
2006-06-26 13:26 ` Magnus Hagander <mha@sollentuna.net>
2006-06-26 20:44 Re: Using PostgreSQL and MIcrosoft SQLServer on the same server Benjamin Krajmalnik <kraj@illumen.com>
2006-07-12 02:45 ` Paul S <plabrh1@gmail.com>
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