Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF, 078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries

Links

XODOX
Impressum

#1: PostgreSQL 8.1 to 8.3

Posted on 2008-04-12 21:08:01 by kranti.parisa

------=_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,<br><br>We are using PostgreSQL 8.1 version. <br>What are the advantages and performance improvement we would get if we move to 8.3. <br>And how easy the transition would be.<br>What are the steps to migrate the data from 8.1 to 8.3<br>
Can i do that?<br>Will my jdbc code already written to access the data from 8.1 will work for 8.3 also?<br><br>Please reply soon.<br clear="all"><br>-- <br><br>Best Regards<br>Kranti Kiran Kumar Parisa<br>M: +91 - 9391 - 438 - 738<br>
+91 - 9849 - 625 - 625<br>

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

Report this message

#2: Re: PostgreSQL 8.1 to 8.3

Posted on 2008-04-12 21:23:53 by Ray Stell

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

Report this message

#3: Re: PostgreSQL 8.1 to 8.3

Posted on 2008-04-12 21:47:45 by kranti.parisa

------=_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 <stellr@cns.vt.edu> 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,<br><br>Thanks for the reply.<br>Will look into that.<br><br><div class="gmail_quote">On Sun, Apr 13, 2008 at 12:53 AM, Ray Stell &lt;<a href="mailto:stellr@cns.vt.edu">stellr@cns.vt.edu</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Sun, Apr 13, 2008 at 12:38:01AM +0530, Kranti K K Parisa? wrote:<br>
&gt; Hi,<br>
&gt;<br>
&gt; We are using PostgreSQL 8.1 version.<br>
&gt; What are the advantages and performance improvement we would get if we move<br>
&gt; to 8.3.<br>
<br>
</div><a href="http://www.postgresql.org/docs/8.3/static/release.html" target="_blank">http://www.postgresql.org/docs/8.3/static/release.html</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><br>Best Regards<br>Kranti Kiran Kumar Parisa<br>M: +91 - 9391 - 438 - 738<br> +91 - 9849 - 625 - 625<br>

------=_Part_5946_18633259.1208029665548--

Report this message

#4: Re: PostgreSQL 8.1 to 8.3

Posted on 2008-04-12 22:08:50 by Ray Stell

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

Report this message

#5: Re: PostgreSQL 8.1 to 8.3

Posted on 2008-04-12 22:20:51 by kranti.parisa

------=_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 <stellr@cns.vt.edu> 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?<br><br><div class="gmail_quote">On Sun, Apr 13, 2008 at 1:38 AM, Ray Stell &lt;<a href="mailto:stellr@cns.vt.edu">stellr@cns.vt.edu</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On Sun, Apr 13, 2008 at 01:17:45AM +0530, Kranti K K Parisa? wrote:<br>
&gt; Will look into that.<br>
<br>
There were some list rumblings when 8.3 was released about this<br>
feature:<br>
<br>
Non-character data types are no longer automatically cast to TEXT (Peter, Tom)<br>
<br>
so, apps will need to be checked for this use.<br>
<br>
Upgrade is a straight forwared process, but does require dump/restore/downtime:<br>
<a href="http://www.postgresql.org/docs/8.3/interactive/install-upgrading.html" target="_blank"> http://www.postgresql.org/docs/8.3/interactive/install-upgra ding.html</a><br>
seemless in my experience.<br>
</blockquote></div><br><br clear="all"><br>-- <br><br>Best Regards<br>Kranti Kiran Kumar Parisa<br>M: +91 - 9391 - 438 - 738<br> +91 - 9849 - 625 - 625<br>

------=_Part_5989_22748670.1208031651852--

Report this message

#6: Re: PostgreSQL 8.1 to 8.3

Posted on 2008-04-12 22:56:50 by Ray Stell

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

Report this message

#7: Re: PostgreSQL 8.1 to 8.3

Posted on 2008-04-14 22:24:49 by Tena Sakai

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7651.59">
<TITLE>RE: [ADMIN] PostgreSQL 8.1 to 8.3</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->

<P><FONT SIZE=3D2>Hi,<BR>
<BR>
I consider myself poor, inexperienced postgres<BR>
administrator (which is not really my job, but<BR>
we cannot afford a dba), but I moved from 8.2.3<BR>
to 8.3.0 about a month ago.&nbsp; It took some planning<BR>
and reading, but with the preparation I did, it<BR>
went pretty smooth.&nbsp; Just my 2 bits as a first-<BR>
hand experience.<BR>
<BR>
Also in a recent linux magazine (I don't know if<BR>
that's your platform or not, but...) there was<BR>
this article: <A =
HREF=3D"http://www.linux-mag.com/id/5679">http://www.linux-m ag.com/id/567=
9</A><BR>
which may be a good source of information.<BR>
<BR>
Hope this helps.<BR>
<BR>
Regards,<BR>
<BR>
Tena Sakai<BR>
tsakai@gallo.ucsf.edu<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: pgsql-admin-owner@postgresql.org on behalf of Ray Stell<BR>
Sent: Sat 4/12/2008 1:56 PM<BR>
To: Kranti K K Parisa?<BR>
Cc: pgsql-admin@postgresql.org<BR>
Subject: Re: [ADMIN] PostgreSQL 8.1 to 8.3<BR>
<BR>
On Sun, Apr 13, 2008 at 01:50:51AM +0530, Kranti K K Parisa? wrote:<BR>
&gt; That means, we have to get the values into specific data types than =
the<BR>
&gt; general string variables?<BR>
<BR>
no, no.&nbsp; Apps can't assume a automatic cast to text.&nbsp; Read the =
release notes:<BR>
&nbsp;<A =
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</A><BR>
&nbsp;E.2.2.1. General<BR>
<BR>
--<BR>
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)<BR>
To make changes to your subscription:<BR>
<A =
HREF=3D"http://www.postgresql.org/mailpref/pgsql-admin">http ://www.postgr=
esql.org/mailpref/pgsql-admin</A><BR>
<BR>
</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C89E6D.96C5527B--

Report this message

#8: Re: PostgreSQL 8.1 to 8.3

Posted on 2008-04-14 22:29:33 by kranti.parisa

------=_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 <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
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Tena,<br><br>Thanks very much for your info.<br>I have installed PostgreSQL 8.3 on 5431 port, and on the same machine 8.1 is running on 5432 port.<br>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.<br>
<br>How ever need to test more.<br><br>Regards, Kranti<br><br><div class="gmail_quote">On Tue, Apr 15, 2008 at 1:54 AM, Tena Sakai &lt;<a href="mailto:tsakai@gallo.ucsf.edu">tsakai@gallo.ucsf.edu</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">







<div>


<p><font size="2">Hi,<br>
<br>
I consider myself poor, inexperienced postgres<br>
administrator (which is not really my job, but<br>
we cannot afford a dba), but I moved from 8.2.3<br>
to 8.3.0 about a month ago.&nbsp; It took some planning<br>
and reading, but with the preparation I did, it<br>
went pretty smooth.&nbsp; Just my 2 bits as a first-<br>
hand experience.<br>
<br>
Also in a recent linux magazine (I don&#39;t know if<br>
that&#39;s your platform or not, but...) there was<br>
this article: <a href="http://www.linux-mag.com/id/5679" target="_blank">http://www.linux-mag.com/id/5679</a><br>
which may be a good source of information.<br>
<br>
Hope this helps.<br>
<br>
Regards,<br>
<br>
Tena Sakai<br>
<a href="mailto:tsakai@gallo.ucsf.edu" target="_blank">tsakai@gallo.ucsf.edu</a><div><div></div><div class="Wj3C7c"><br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:pgsql-admin-owner@postgresql.org" target="_blank">pgsql-admin-owner@postgresql.org</a> on behalf of Ray Stell<br>
Sent: Sat 4/12/2008 1:56 PM<br>
To: Kranti K K Parisa?<br>
Cc: <a href="mailto:pgsql-admin@postgresql.org" target="_blank">pgsql-admin@postgresql.org</a><br>
Subject: Re: [ADMIN] PostgreSQL 8.1 to 8.3<br>
<br>
On Sun, Apr 13, 2008 at 01:50:51AM +0530, Kranti K K Parisa? wrote:<br>
&gt; That means, we have to get the values into specific data types than the<br>
&gt; general string variables?<br>
<br>
no, no.&nbsp; Apps can&#39;t assume a automatic cast to text.&nbsp; Read the release notes:<br>
&nbsp;<a href="http://www.postgresql.org/docs/8.3/static/release-8-3.html" target="_blank">http://www.postgresql.org/docs/8.3/static/release-8-3.html</a><br>
&nbsp;E.2.2.1. General<br>
<br></div></div>
--<br>
Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin@postgresql.org" target="_blank">pgsql-admin@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-admin" target="_blank">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
<br>
</font>
</p>

</div>
</blockquote></div><br><br clear="all"><br>-- <br><br>Best Regards<br>Kranti Kiran Kumar Parisa<br>M: +91 - 9391 - 438 - 738<br> +91 - 9849 - 625 - 625<br>

------=_Part_3861_2210872.1208204973984--

Report this message