Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread Bruce Momjian
Jeff Trout wrote: > iirc, didn't some big us govt group move to PG from Informix? I > think Bruce mentioned something once about that.. US National Weather Service changed 170 weather sites from Informix to Postgres. Postgres worked well for them. -- Bruce Momjian <[EMAIL PROTECTED]>

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread Trent Shipley
In answering the question, it might help to have information on two background items. The first item is the politics of the situation. I gather from Chad Hendren's post that an individual in the top-8-OEM-customer enterprise is advocating for Postgresql. The second item is the existing tech

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread Jeff Trout
On Nov 28, 2007, at 6:11 PM, Jeff Larsen wrote: I can't offer much in the way of a case study, but I am an Informix customer that has been doing an informal feasibility study on switching to PostgreSQL. I've learned a ton from the high quality PG docs and from the PG mailing lists. I switched a

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread David Fetter
On Wed, Nov 28, 2007 at 11:11:07PM -0700, Gregory Williamson wrote: > * There is no equivalent of a "synonym"; a view can be used to fake this > sometimes > but where Informix lets you create a synonym to a table in another > database / > instance, PostgreSQL doesn't. dblink can be use

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Gregory Williamson
Chad -- <...> > > Have you seen any studies (either by Sun or others) that compares > PostgresSQL to other commercial database software (Informix, Oracle, > Sybase,etc.)? I am interested seeing a feature by feature comparison of > PostgresSQL and Informix. > Hope this ain't too late! I can'

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/28/07 17:11, Jeff Larsen wrote: [snip] > > Lastly on the Informix side, they have more advanced online > backup/restore tools. It's similar to PG PITR backup but does not > depend on file-system level backup tools. The option I use (called > ont

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Jeff Larsen
On Nov 28, 2007 9:32 AM, Chad Hendren <[EMAIL PROTECTED]> wrote: > I have a large OEM customer (one of the top 8 for Sun worldwide) that is > considering embedding PostgreSQL into the core of their primary product > instead of Informix. He is trying to build his case for this change. > Do we have

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Erik Jones
On Nov 28, 2007, at 9:32 AM, Chad Hendren wrote: PostgreSQL Team, I have a large OEM customer (one of the top 8 for Sun worldwide) that is considering embedding PostgreSQL into the core of their primary product instead of Informix. He is trying to build his case for this change. Do we h

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Jutta Horstmann
Hi Merlin, Chad, Merlin Moncure schrieb: > there was a very excellent case study, written by cc'd person, that is > unhappily not available at the moment. see: > http://archives.postgresql.org/pgsql-advocacy/2005-08/msg00147.php Thank you :-) The link in the post is not up to date. The linked c

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Merlin Moncure
On Nov 28, 2007 10:32 AM, Chad Hendren <[EMAIL PROTECTED]> wrote: > PostgreSQL Team, > > I have a large OEM customer (one of the top 8 for Sun worldwide) that is > considering embedding PostgreSQL into the core of their primary product > instead of Informix. He is trying to build his case for this

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread mgainty
: VFVWRKJVZCMHVIBGDADRZFSQHYUCDDJBLVLMH To: Sent: Wednesday, November 28, 2007 10:32 AM Subject: [GENERAL] PostgresSQL vs. Informix > PostgreSQL Team, > > I have a large OEM customer (one of the top 8 for Sun worldwide) that is > considering embedding PostgreSQL into the core of their pri

[GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Chad Hendren
PostgreSQL Team, I have a large OEM customer (one of the top 8 for Sun worldwide) that is considering embedding PostgreSQL into the core of their primary product instead of Informix. He is trying to build his case for this change. Do we have anything that I can forward to him (something like