SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-15-2008, 08:35 PM
| ||||
| ||||
 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      |
|
04-15-2008, 08:35 PM
| |||
| |||
| Re: PostgreSQL 8.1 to 8.3 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin |
|
04-15-2008, 08:35 PM
| |||
| |||
| Re: PostgreSQL 8.1 to 8.3 Hi Ray, Thanks for the reply. Will look into that. On Sun, Apr 13, 2008 at 12:53 AM, Ray Stell <stellr@cns.vt.edu> wrote: > 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 > -- Best Regards Kranti Kiran Kumar Parisa M: +91 - 9391 - 438 - 738 +91 - 9849 - 625 - 625 |
|
04-15-2008, 08:35 PM
| |||
| |||
| Re: PostgreSQL 8.1 to 8.3 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/i...upgrading.html seemless in my experience. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin |
|
04-15-2008, 08:35 PM
| |||
| |||
| Re: PostgreSQL 8.1 to 8.3 That means, we have to get the values into specific data types than the general string variables? On Sun, Apr 13, 2008 at 1:38 AM, Ray Stell <stellr@cns.vt.edu> wrote: > 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/i...upgrading.html > seemless in my experience. > -- Best Regards Kranti Kiran Kumar Parisa M: +91 - 9391 - 438 - 738 +91 - 9849 - 625 - 625 |
|
04-15-2008, 08:35 PM
| |||
| |||
| Re: 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/s...lease-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 |
|
04-15-2008, 08:35 PM
| |||
| |||
| Re: PostgreSQL 8.1 to 8.3 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/s...lease-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 |
|
04-15-2008, 08:35 PM
| ||||
| ||||
| Re: PostgreSQL 8.1 to 8.3 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 On Tue, Apr 15, 2008 at 1:54 AM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote: > 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/s...lease-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 > > -- Best Regards Kranti Kiran Kumar Parisa M: +91 - 9391 - 438 - 738 +91 - 9849 - 625 - 625 |
Linear Mode
