Hi, Some major differences between these versions are: PostgreSQL 9.0 - Streaming Replication and Hot Standby (latest is 9.0.10) PostgreSQL 9.1 - Synchronous Replication (latest is 9.1.6) PostgreSQL 9.2 - Cascading Replication (latest is 9.2.1) PostgreSQL 9.3 - (not yet release version: Multiple-master replication)
Also here is a link about PostgreSQL Feature Matrix per version: http://www.emblocsoft.com/PostgreSQL/PostgreSQL-Feature-Matrix Could you share what issues you have about '9.1, basic "show table" in hive failed' so we might be of help. With Regards TC On 6 Nov 2012, at 6:03 PM, Alexander Lorenz wrote: > Hi, > > I don't know what exactly was the major changes between 9.0.x and 9.1.x, but > when you've a good experience with 9.0.x, use it :) > For 9.1.x, it would be great to get a log or stack trace to see whats going > wrong there. > > best, > Alex > > On Nov 6, 2012, at 9:53 AM, rohithsharma <rohithsharm...@huawei.com> wrote: > >> Hi Lorenz, >> >> Thanks for you fast reply :-) >> >>>> Postgres 9x I personally wouldn't choose. >> Can you please tell what is the problem using 9x version with hive.? >> >> I tried with 9.0.7, it was successfully integrated and functionality also >> fine. But when I changed to 9.1, basic "show table" in hive failed. >> >> I was wondering what is the major change between 9.0.7 to 9.1.4.? >> >> >> Regards >> Rohith Sharma K S >> >> -----Original Message----- >> From: Alexander Lorenz [mailto:wget.n...@gmail.com] >> Sent: Tuesday, November 06, 2012 12:40 PM >> To: user@hive.apache.org; rohithsharm...@huawei.com >> Subject: Re: Which is the postgres version is compatible for hive-trunk..? >> >> Hey Rohith, >> >> last time I used psql was with postgresql-8.4-701.jdbc4.jar, and was working >> great. But I guess all 8.x version should work. Postgres 9x I personally >> wouldn't choose. >> >> best, >> Alex >> >> On Nov 6, 2012, at 5:29 AM, rohithsharma <rohithsharm...@huawei.com> wrote: >> >>> Hi Guys, >>> >>> I am planning to use postgres as metastore with Hive. Can anyone point me >>> which is the postgres version is compatible with Hive..? >>> >>> >>> >>> Regards >>> >>> Rohith Sharma K S >>> >> >> -- >> Alexander Alten-Lorenz >> http://mapredit.blogspot.com >> German Hadoop LinkedIn Group: http://goo.gl/N8pCF >> > > -- > Alexander Alten-Lorenz > http://mapredit.blogspot.com > German Hadoop LinkedIn Group: http://goo.gl/N8pCF >