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(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