Skip site navigation (1) Skip section navigation (2)

Re: Postgresql suitable replacement (Win 1GB /

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Sanjay Jain <sminni_news(at)minisoftindia(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Postgresql suitable replacement (Win 1GB /
Date: 2005-04-17 13:49:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-advocacy
On Sun, 17 Apr 2005, Sanjay Jain wrote:

> Hi,
> We have a system so far on oracle + PB (so far 18 sites)
> we want to port it to Postgres + dotnet
> for mass deployment


> 1. it will be in use at 50+ sites


> 2. Each site will have 1GB database (as per oracle)

Not a problem

>    some tables have upwards on 1M rows

Not a problem

> 3. Each site will have 10-20 users


> 4. Application will be on a Dotnet platform

No problem:

> 5. There will be a 2 tier replication
>      only for committed data transfer asynchronously

Could we get more description on this?

> 6. It will be a totally WinXP/2003 (server) /
>                               Win98+ (Workstation) environment

No problem

> 7. Sites will not have skilled personnel and all admin
>      will have to be done remotedly over slow dial up links
>      or by sending updates on media

Well as long as you set it up correctly this shouldn't be a problem :)

> 8. Its a commercial application

No problem

> Is Postgres a wise choice ?

It seems like PostgreSQL can solve your requirements but I am curious
about #5 above.


Joshua D. Drake
Command Prompt, Inc.
Your PostgreSQL Solution Provider

> Regards
> Sanjay Jain
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly

Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator -

In response to


pgsql-advocacy by date

Next:From: Sanjay JainDate: 2005-04-17 15:30:07
Subject: Re: Postgresql suitable replacement (Win 1GB /
Previous:From: Sanjay JainDate: 2005-04-17 13:47:55
Subject: Postgresql suitable replacement (Win 1GB / 100GB + dotnet + replication)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group