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(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 - http://www.commandprompt.com/