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 <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [EMAIL PROTECTED] 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 > > -- Best Regards Kranti Kiran Kumar Parisa M: +91 - 9391 - 438 - 738 +91 - 9849 - 625 - 625