<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=437433001-03112006><FONT face=Arial
color=#0000ff size=2>Right; I wrote PostgreSQL 8.4.1 and meant 8.1.4. Oops.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=437433001-03112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=437433001-03112006><FONT face=Arial
color=#0000ff size=2>I haven't noticed a difference of performance between
PostgreSQL and MySQL but that because I have never tried OpenCms with MySQL and
always have used PostgreSQL (since 6.0.x versions were
released).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=437433001-03112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=437433001-03112006><FONT face=Arial
color=#0000ff size=2>Sorry to be of no help. </FONT>
</SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>..............................<BR>Jack <BR>-----<
www.iable.ca >---------<BR></FONT></P>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Gaith Bader
[mailto:gaithb@cse.unsw.edu.au] <BR><B>Sent:</B> November 2, 2006 8:27
PM<BR><B>To:</B> jbakker@iable.ca; The OpenCms mailing list<BR><B>Subject:</B>
Postgresql Performance<BR></FONT><BR></DIV>
<DIV></DIV>hello all,
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>I am wondering for people who are using OpenCms with PostgreSQL 8.1.x if
you noticed in standard installation that it is slower than when using opencms
with MySQL..</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>I was hoping if you worked out some tweaking to Postgres and tomcat to
make OpenCms perform better under this setup... </DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>any suggestions are appreciated :-)</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>Cheers,</DIV>
<DIV>Gaith</DIV>
<DIV>
<DIV><SPAN class=Apple-style-span
style="WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; border-spacing: 0px 0px; khtml-text-decorations-in-effect: none; apple-text-size-adjust: auto; orphans: 2; widows: 2"><SPAN
class=Apple-style-span
style="WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; border-spacing: 0px 0px; khtml-text-decorations-in-effect: none; apple-text-size-adjust: auto; orphans: 2; widows: 2"><SPAN
class=Apple-style-span
style="WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; border-spacing: 0px 0px; khtml-text-decorations-in-effect: none; apple-text-size-adjust: auto; orphans: 2; widows: 2">
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV><BR class=khtml-block-placeholder></DIV><BR
class=Apple-interchange-newline></SPAN></SPAN></SPAN></DIV><BR>
<DIV>
<DIV>On 02/11/2006, at 12:46 AM, Jack Bakker wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV style="MARGIN: 0px">Thanks; disassociating the Admin user from the
Guest group worked.</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">I also don't know the exact steps I took, but I
certainly didn't explicitly</DIV>
<DIV style="MARGIN: 0px">associate the Admin user with the Guest group. I
have been exploring logging</DIV>
<DIV style="MARGIN: 0px">in users from a jsp code; am working with version
6.2.1; and am using</DIV>
<DIV style="MARGIN: 0px">PostgreSQL 8.4.1 <SPAN
class=Apple-converted-space></SPAN></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">..............................</DIV>
<DIV style="MARGIN: 0px">Jack</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">-----< <A
href="http://www.iable.ca">www.iable.ca</A> >---------</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px"><SPAN class=Apple-converted-space></SPAN>_____
<SPAN class=Apple-converted-space></SPAN></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">From: Scott Carlson [<A
href="mailto:scott@optionvue.com">mailto:scott@optionvue.com</A>]<SPAN
class=Apple-converted-space> </SPAN></DIV>
<DIV style="MARGIN: 0px">Sent: November 1, 2006 12:42 AM</DIV>
<DIV style="MARGIN: 0px">To: <A
href="mailto:jbakker@iable.ca">jbakker@iable.ca</A>; The OpenCms mailing
list</DIV>
<DIV style="MARGIN: 0px">Subject: RE: [opencms-dev] Permissions for admin
gone !</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">I run into this problem all the time, and I just
assumed it was a bug in my</DIV>
<DIV style="MARGIN: 0px">code... I suspect site registration, and your
description lends credence to</DIV>
<DIV style="MARGIN: 0px">that theory. But, I don't know the exact steps to
reproduce the problem - a</DIV>
<DIV style="MARGIN: 0px">simple site registration doesn't reproduce the
problem.</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">What it is (at least in my case) is that the
"Guest" group gets added to the</DIV>
<DIV style="MARGIN: 0px">Admin user. I just go in and remove the Guest group
from Admin, and things</DIV>
<DIV style="MARGIN: 0px">work just fine until several days or more later,
the Guest group gets added</DIV>
<DIV style="MARGIN: 0px">again.</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">If this is your problem, after removing the Admin
user and going back to</DIV>
<DIV style="MARGIN: 0px">explorer, everything may still be grayed out - hit
the refresh button and</DIV>
<DIV style="MARGIN: 0px">things will behave as expected.</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">Scott</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px"><SPAN class=Apple-converted-space></SPAN>_____
<SPAN class=Apple-converted-space></SPAN></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">From: <A
href="mailto:opencms-dev-bounces@opencms.org">opencms-dev-bounces@opencms.org</A>
on behalf of Jack Bakker</DIV>
<DIV style="MARGIN: 0px">Sent: Tue 10/31/2006 9:24 PM</DIV>
<DIV style="MARGIN: 0px">To: <A
href="mailto:opencms-dev@opencms.org">opencms-dev@opencms.org</A></DIV>
<DIV style="MARGIN: 0px">Subject: [opencms-dev] Permissions for admin gone
!</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">After experimenting with adding webusers, regular
users and setting</DIV>
<DIV style="MARGIN: 0px">permissions on just one .html file; all of a sudden
my 'Admin' user has only</DIV>
<DIV style="MARGIN: 0px">permissions to edit jsp files but everything else
is grayed out.</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">Ideas on how I can reset the 'Admin' user's
permissions to again have</DIV>
<DIV style="MARGIN: 0px">complete access to everything ?</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MARGIN: 0px">..............................</DIV>
<DIV style="MARGIN: 0px">Jack</DIV>
<DIV style="MARGIN: 0px">-----< <A
href="http://www.iable.ca">www.iable.ca</A> >---------</DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV
style="MARGIN: 0px">_______________________________________________</DIV>
<DIV style="MARGIN: 0px">This mail is sent to you from the opencms-dev
mailing list</DIV>
<DIV style="MARGIN: 0px">To change your list options, or to unsubscribe from
the list, please visit</DIV>
<DIV style="MARGIN: 0px"><A
href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</A></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR></DIV>
<DIV style="MIN-HEIGHT: 14px; MARGIN: 0px"><BR><SPAN>
<DIV><winmail.dat></DIV></SPAN><BR></DIV>
<DIV
style="MARGIN: 0px">_______________________________________________</DIV>
<DIV style="MARGIN: 0px">This mail is sent to you from the opencms-dev
mailing list</DIV>
<DIV style="MARGIN: 0px">To change your list options, or to unsubscribe from
the list, please visit</DIV>
<DIV style="MARGIN: 0px"><A
href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</A></DIV></BLOCKQUOTE></DIV><BR></DIV></BLOCKQUOTE></BODY></HTML>