Обсуждение: PostgreSQL 8.1 to 8.3

Hi,

We are using PostgreSQL 8.1 version.
What are the advantages and performance improvement we would get if we move to 8.3.
And how easy the transition would be.
What are the steps to migrate the data from 8.1 to 8.3
Can i do that?
Will my jdbc code already written to access the data from 8.1 will work for 8.3 also?

Please reply soon.

--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625

On Sun, Apr 13, 2008 at 12:38:01AM +0530, Kranti K K Parisa? wrote:
> Hi,
>
> We are using PostgreSQL 8.1 version.
> What are the advantages and performance improvement we would get if we move
> to 8.3.

http://www.postgresql.org/docs/8.3/static/release.html

Hi Ray,

Thanks for the reply.
Will look into that.




--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625

On Sun, Apr 13, 2008 at 01:17:45AM +0530, Kranti K K Parisa? wrote:
> Will look into that.

There were some list rumblings when 8.3 was released about this
feature:

Non-character data types are no longer automatically cast to TEXT (Peter, Tom)

so, apps will need to be checked for this use.

Upgrade is a straight forwared process, but does require dump/restore/downtime:
http://www.postgresql.org/docs/8.3/interactive/install-upgrading.html
seemless in my experience.

That means, we have to get the values into specific data types than the general string variables?




--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625

On Sun, Apr 13, 2008 at 01:50:51AM +0530, Kranti K K Parisa? wrote:
> That means, we have to get the values into specific data types than the
> general string variables?

no, no.  Apps can't assume a automatic cast to text.  Read the release notes:
 http://www.postgresql.org/docs/8.3/static/release-8-3.html
 E.2.2.1. General

Hi,

I consider myself poor, inexperienced postgres
administrator (which is not really my job, but
we cannot afford a dba), but I moved from 8.2.3
to 8.3.0 about a month ago.  It took some planning
and reading, but with the preparation I did, it
went pretty smooth.  Just my 2 bits as a first-
hand experience.

Also in a recent linux magazine (I don't know if
that's your platform or not, but...) there was
this article: http://www.linux-mag.com/id/5679
which may be a good source of information.

Hope this helps.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Ray Stell
Sent: Sat 4/12/2008 1:56 PM
To: Kranti K K Parisa?
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PostgreSQL 8.1 to 8.3

On Sun, Apr 13, 2008 at 01:50:51AM +0530, Kranti K K Parisa? wrote:
> That means, we have to get the values into specific data types than the
> general string variables?

no, no.  Apps can't assume a automatic cast to text.  Read the release notes:
 http://www.postgresql.org/docs/8.3/static/release-8-3.html
 E.2.2.1. General

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hi Tena,

Thanks very much for your info.
I have installed PostgreSQL 8.3 on 5431 port, and on the same machine 8.1 is running on 5432 port.
i have taken the backup file from 8.1 and restored into 8.3 using pgadminIII tool. I got he db into 8.3. As i am using hibernate everything looks fine.

How ever need to test more.

Regards, Kranti




--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625