PostgreSQL 8.1 to 8.3

------=_Part_5853_6012602.1208027282014
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

We are using PostgreSQL 8.1 version.
What are the advantages and performance improvement we would get if we move
to 8.3.
And how easy the transition would be.
What are the steps to migrate the data from 8.1 to 8.3
Can i do that?
Will my jdbc code already written to access the data from 8.1 will work for
8.3 also?

Please reply soon.

--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625

------=_Part_5853_6012602.1208027282014
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

We are using PostgreSQL 8.1 version.
What are the advantages and performance improvement we would get if we move to 8.3.
And how easy the transition would be.
What are the steps to migrate the data from 8.1 to 8.3

Can i do that?
Will my jdbc code already written to access the data from 8.1 will work for 8.3 also?

Please reply soon.

--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738

+91 - 9849 - 625 - 625


------=_Part_5853_6012602.1208027282014--

Re: PostgreSQL 8.1 to 8.3

On Sun, Apr 13, 2008 at 12:38:01AM +0530, Kranti K K Parisa? wrote:
> Hi,
>
> We are using PostgreSQL 8.1 version.
> What are the advantages and performance improvement we would get if we move
> to 8.3.

http://www.postgresql.org/docs/8.3/static/release.html

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: PostgreSQL 8.1 to 8.3

------=_Part_5946_18633259.1208029665548
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Ray,

Thanks for the reply.
Will look into that.

On Sun, Apr 13, 2008 at 12:53 AM, Ray Stell wrote:

> On Sun, Apr 13, 2008 at 12:38:01AM +0530, Kranti K K Parisa? wrote:
> > Hi,
> >
> > We are using PostgreSQL 8.1 version.
> > What are the advantages and performance improvement we would get if we
> move
> > to 8.3.
>
> http://www.postgresql.org/docs/8.3/static/release.html
>



--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625

------=_Part_5946_18633259.1208029665548
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Ray,

Thanks for the reply.
Will look into that.

Re: PostgreSQL 8.1 to 8.3

On Sun, Apr 13, 2008 at 01:17:45AM +0530, Kranti K K Parisa? wrote:
> Will look into that.

There were some list rumblings when 8.3 was released about this
feature:

Non-character data types are no longer automatically cast to TEXT (Peter, Tom)

so, apps will need to be checked for this use.

Upgrade is a straight forwared process, but does require dump/restore/downtime:
http://www.postgresql.org/docs/8.3/interactive/install-upgra ding.html
seemless in my experience.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: PostgreSQL 8.1 to 8.3

------=_Part_5989_22748670.1208031651852
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

That means, we have to get the values into specific data types than the
general string variables?

On Sun, Apr 13, 2008 at 1:38 AM, Ray Stell wrote:

> On Sun, Apr 13, 2008 at 01:17:45AM +0530, Kranti K K Parisa? wrote:
> > Will look into that.
>
> There were some list rumblings when 8.3 was released about this
> feature:
>
> Non-character data types are no longer automatically cast to TEXT (Peter,
> Tom)
>
> so, apps will need to be checked for this use.
>
> Upgrade is a straight forwared process, but does require
> dump/restore/downtime:
> http://www.postgresql.org/docs/8.3/interactive/install-upgra ding.html
> seemless in my experience.
>



--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625

------=_Part_5989_22748670.1208031651852
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

That means, we have to get the values into specific data types than the general string variables?

Re: 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

Re: PostgreSQL 8.1 to 8.3

This is a multi-part message in MIME format.

------_=_NextPart_001_01C89E6D.96C5527B
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
=20
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:=20
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.2.2.1. General

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


------_=_NextPart_001_01C89E6D.96C5527B
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




charset=3Diso-8859-1">
6.5.7651.59">

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: HREF=3D"http://www.linux-mag.com/id/5679">http://www.linux-m ag.com/id/567=
9

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:

  HREF=3D"http://www.postgresql.org/docs/8.3/static/release-8- 3.html">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:

HREF=3D"http://www.postgresql.org/mailpref/pgsql-admin">http ://www.postgr=
esql.org/mailpref/pgsql-admin

Re: PostgreSQL 8.1 to 8.3

------=_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