Re: Postgresql suitable replacement (Win 1GB /

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

O.k.

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

O.k.

> 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

O.k.

> 4. Application will be on a Dotnet platform

No problem:

http://www.go-mono.com/postgresql.html


> 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.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.
http://www.commandprompt.com/
Your PostgreSQL Solution Provider




>
> Regards
> Sanjay Jain
> www.minisoftindia.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.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 - http://www.commandprompt.com/