Re: PostgreSQL 8.1 to 8.3

["Kranti K K Parisa™" <kranti(dot)parisa(at)gmail(dot)com>]

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(at)gallo(dot)ucsf(dot)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(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org on behalf of Ray Stell
Sent: Sat 4/12/2008 1:56 PM
To: Kranti K K Parisa?
Cc: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)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