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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
