Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id CECF42E007C for ; Mon, 14 Apr 2008 17:29:46 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82818-02 for ; Mon, 14 Apr 2008 17:29:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.185]) by developer.postgresql.org (Postfix) with ESMTP id 63D242E0030 for ; Mon, 14 Apr 2008 17:29:35 -0300 (ADT) Received: by ti-out-0910.google.com with SMTP id y6so541881tia.5 for ; Mon, 14 Apr 2008 13:29:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=UJsheM4IMbE/13fT8jAVzGLYkROrPrcf9JSdE0qFb5Q=; b=iysIpz9IG4SRSMnbDjh1kcapgySVKu7gPMJjt7LBxCHh0NId7gMJ5SuWew/8a1H32YDP9hm83e1ML2Ynod4xS1SSxkFGLcO1F5zMkcrduMSQC3AqHM1Pw8CQpEZAbuxwIuDZyM0gCZ2Le5UEmk8+YnGIHsYVQ/ii7D0G5eA2Q+w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=KXYOJ0/ZAA0VRqMExmopBWRKHBF6YBcjoRGOdofM7x4kMV1zEDaUWPthSZsKM0STzP40V21cYHrLJHgWVMaplCOJtuFjD51ibEz0gv73K3V6oF3CzjlKTdggAAGWyj03enSC/53TqVpL/2MtAmdV4lfFktlusOx4gUEVmfWuxh4= Received: by 10.110.47.7 with SMTP id u7mr514289tiu.58.1208204974019; Mon, 14 Apr 2008 13:29:34 -0700 (PDT) Received: by 10.110.49.5 with HTTP; Mon, 14 Apr 2008 13:29:33 -0700 (PDT) Message-ID: <4478b4ac0804141329x2fb001d8qacfb4b1d47edde9e@mail.gmail.com> Date: Tue, 15 Apr 2008 01:59:33 +0530 From: "=?WINDOWS-1252?Q?Kranti_K_K_Parisa=99?=" To: "Tena Sakai" Subject: Re: PostgreSQL 8.1 to 8.3 Cc: "Ray Stell" , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3861_2210872.1208204973984" References: <4478b4ac0804121208x7fdd8419pf3f9675c397f62e3@mail.gmail.com> <20080412192353.GA3188@cns.vt.edu> <4478b4ac0804121247t3019cb67jc212c304edc805cf@mail.gmail.com> <20080412200850.GA4098@cns.vt.edu> <4478b4ac0804121320w1a6bfceehd0a4c7fbe8abb970@mail.gmail.com> <20080412205650.GA18337@cns.vt.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/127 X-Sequence-Number: 28891 ------=_Part_3861_2210872.1208204973984 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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/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 ------=_Part_3861_2210872.1208204973984 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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/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
------=_Part_3861_2210872.1208204973984--