On Fri, 18 Jan 2008 01:28:38 -0800 (PST)
Jon Hancock <redstarling@gmail.com> wrote:
> 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.
You should only use native packages.
>
> My production target is AMD64 on ubuntu 7.04.
Then why not apt-get install postgresql-8.2?
> My test and staging target is 32 bit ubuntu 7.04 on vmware.
See above.
> My dev environment is OS X 10.5 - I am fine using enterprisedb's
> installer for this.
>
I would think that fink or macports or something would be more
appropriate.
> 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.
8.3 isn't out yet the only reputable source is the release candidate
packages which are for testing only. You can find them at
postgresql.org.
>
> 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.
O.k. that is reasonable. You don't want to have to port twice. However
if you install rc1 be prepared to install rc2 very quickly and the
released version asap after that.
> 2 - basic stored procedures. I don't need the extended language
> options. the native/default language for stored procedures is ok.
Which every version of PostgreSQL has had for as long as I can remember.
> 3 - don't need things like replication or partitioning or oracle
> compatibility.
EnterpriseDB Postgres doesn't have oracle compatibility. That is there
Advanced Server product.
> 4 - I do want a good install structure and decent compile options that
> suites my target production platform (AMD64 on ubuntu 7.04).
>
Then I suggest you use what the debian packager provides you. Check
backports.
Sincerely,
Joshua D. Drake