Re: which version ?

On Wed, 2004-08-11 at 02:38, MP TORRE wrote:
> Hello everybody
>
> I have to work with postgresql, but I don't know which stable version using :
>
> the technical definition environnement is :
> - development on windows 200 pro (I saw cygwin and v7.42 or v7.4.3 are
> available)
> - server on redhat ent v3 ( postgresql installed is in v7.3.6-1)
> - application server : orion (java) (for tests) + php test (php4)
> - pgadmin III and phpPgAdmin
>
> I need to do interface with web application I have to developp in order to
> use postgis too.
>
> Could you give me advice about a stable version working with a jdbc driver,
> accepted by postgis and suporting large objects ?
> More thanks in advance

I'd run 7.4.x (latest version) if it was up to me. 7.3.x is the oldest
version I'd consider putting into production on a new product, and only
if there was some issue running some tool I had against 7.4.

jdbc works pretty well in 7.4, as does postgis. all versions going
pretty far back support large objects, but I'm not a fan of large
objects, preferring to store binary things in the file system.