Re: PostgreSQL 8.1 to 8.3 - Mailing list pgsql-admin

From Kranti K K Parisa™
Subject Re: PostgreSQL 8.1 to 8.3
Date
Msg-id 4478b4ac0804141329x2fb001d8qacfb4b1d47edde9e@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 8.1 to 8.3  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List 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

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

pgsql-admin by date:

Previous
From: "Tena Sakai"
Date:
Subject: Re: PostgreSQL 8.1 to 8.3
Next
From: "Tena Sakai"
Date:
Subject: Re: "missing" library file