Thread: which version ?

which version ?

From
MP TORRE
Date:
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 use rpms to install on redhat


mpaule

-------------------------------------------------------------------------------------------
TORRE  MPaule
Observatoire Oceanologique -OOV
PROOF Base de Données/Web
Quai de la Darse, BP8,Cas. Nicolas
06238 VILLEFRANCHE sur MER
FRANCE
TEL (33)4.93.76.38.77
FAX (33)4.93.76.38.73


Re: which version ?

From
"Scott Marlowe"
Date:
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.