I am a fairly new user of postgres and am starting with the very
latest 8.3rc1.
I need to figure out the pros/cons of compiling from the source of
postgres.org or the install package from enterprisedb.
My production target is AMD64 on ubuntu 7.04.
My test and staging target is 32 bit ubuntu 7.04 on vmware.
My dev environment is OS X 10.5 - I am fine using enterprisedb's
installer for this.
I have not found a reputable ubuntu package for the latest 8.3 so I
suppose I'm left to compile from source if I don't go with
enterprisedb.
My needs are simple:
1 - I need full text search, This is the main reason I'm going
straight to 8.3 and not bothering with integrating it myself.
2 - basic stored procedures. I don't need the extended language
options. the native/default language for stored procedures is ok.
3 - don't need things like replication or partitioning or oracle
compatibility.
4 - I do want a good install structure and decent compile options that
suites my target production platform (AMD64 on ubuntu 7.04).
Any opinions on this?
thanks, Jon
So will I end up with a relatively bloated install if I use
enterprisedb on my production server?
I do notice the default install of enterprisedb on ubuntu puts things
under /opt/enterprisedb. This is different than the install
instruction for postgres.org source and is different from standard
ubuntu practice. But if this isn't a problem, I can live with it.