Return-Path: 
 <users-return-16453-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 90411 invoked from network); 5 Nov 2010 08:52:02 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 5 Nov 2010 08:52:02 -0000
Received: (qmail 89219 invoked by uid 500); 5 Nov 2010 08:52:33 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 88919 invoked by uid 500); 5 Nov 2010 08:52:30 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 88910 invoked by uid 99); 5 Nov 2010 08:52:29 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Nov 2010 08:52:29 +0000
X-ASF-Spam-Status: No, hits=4.7 required=10.0
	tests=FREEMAIL_FROM,FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of etile.basson@googlemail.com
 designates 74.125.82.50 as permitted sender)
Received: from [74.125.82.50] (HELO mail-ww0-f50.google.com) (74.125.82.50)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Nov 2010 08:52:24 +0000
Received: by wwb17 with SMTP id 17so2834093wwb.19
        for <users@jackrabbit.apache.org>;
 Fri, 05 Nov 2010 01:52:03 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=googlemail.com; s=gamma;
        h=domainkey-signature:mime-version:received:received:in-reply-to
         :references:date:message-id:subject:from:to:content-type;
        bh=oFgcNsd9KyWxn1WGb0UrzE436HyrOhDqhJQNm+ucqQI=;
        b=QS9EXEsEcOxmjd9xWRNEP2DxnJYDiKNl7QdiDdLkFt4DlVKn0SL7+0xr3flO1SNuVY
         Tet/6N/z/QIM1O+e4sRsviF7SrJE9bbuQ70zBCDP4HHaVm1ZAixq3NM4bjt2wpt9O3ON
         bETSOU1EvglWbcWzp4XM9PIBxgZYId276pBlw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=PTtVagMsl2MLtMENjwMiqejtXPObrf4RJg88EBGxgk5QyUbx4Q2RU0MM56Hhp8mVme
         wH96KMJ6zYMPleUb/lpaFre7VyJElo+Ziip+8yYcre8syXp3lncL1l+d26W/ATBDVxGS
         ztPPn5ZJUy3AlGC3m9emMrEg4MYGQHl08ymSo=
MIME-Version: 1.0
Received: by 10.216.27.20 with SMTP id d20mr1639236wea.99.1288947123207; Fri,
 05 Nov 2010 01:52:03 -0700 (PDT)
Received: by 10.216.176.208 with HTTP; Fri, 5 Nov 2010 01:52:03 -0700 (PDT)
In-Reply-To: <4CC98DE0.9080106@gmail.com>
References: <AANLkTi=+wGHiyx6nkMcMNsHA1KJWDzB+6CyDYm1HJ+89@mail.gmail.com>
	<AANLkTimBG9=HxJF40sZjB9gH_peTCidYgtuymP5_9gR0@mail.gmail.com>
	<4CC98487.4080000@gmail.com>
	<AANLkTi=DRFXKr9j7-=KFfHt20DhKPe1QKoNrMc4q+p_P@mail.gmail.com>
	<4CC98DE0.9080106@gmail.com>
Date: Fri, 5 Nov 2010 09:52:03 +0100
Message-ID: <AANLkTikvhfnYa+=UEmrQw=KD0JP9XZEVJmskrC0KevY9@mail.gmail.com>
Subject: Re: Problem with Clustering Setup (PostgreSQL)
From: Etile Basson <etile.basson@googlemail.com>
To: users@jackrabbit.apache.org
Content-Type: multipart/alternative; boundary=0016e6db5c3869bd6d04944a63c6

--0016e6db5c3869bd6d04944a63c6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi there,

just want to thank Thomas and Justin for their worthful hints. I managed to
get the jackrabbit cluster up and running with PostgreSQL. Please find my
repository.xml below this text. Do you want me to attach it to the
corresponding wiki page? It think that it might serve as a good example for
anyone who wants to use clustering with PostgreSQL.

--snip--
<?xml version=3D"1.0"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD
Jackrabbit 1.2//EN"
                            "
http://jackrabbit.apache.org/dtd/repository-1.2.dtd">
<Repository>
    <Cluster>
        <Journal class=3D"org.apache.jackrabbit.core.journal.DatabaseJourna=
l">
            <param name=3D"revision" value=3D"${rep.home}/revision.log" />
            <param name=3D"driver" value=3D"org.postgresql.Driver" />
            <param name=3D"url" value=3D"${jackrabbit.repository.url}" />
            <param name=3D"user" value=3D"${jackrabbit.repository.user}" />
            <param name=3D"password" value=3D"${jackrabbit.repository.passw=
ord}"
/>
            <param name=3D"schema" value=3D"postgresql"/>
            <param name=3D"schemaObjectPrefix" value=3D"J_C_"/>
        </Journal>
    </Cluster>

    <FileSystem class=3D"org.apache.jackrabbit.core.fs.local.LocalFileSyste=
m">
        <param name=3D"path" value=3D"${rep.home}/repository"/>
    </FileSystem>

    <Security appName=3D"Jackrabbit">
        <AccessManager
class=3D"org.apache.jackrabbit.core.security.SimpleAccessManager">
        </AccessManager>

        <LoginModule
class=3D"org.apache.jackrabbit.core.security.SimpleLoginModule">
           <param name=3D"anonymousId" value=3D"anonymous"/>
        </LoginModule>
    </Security>

    <Workspaces rootPath=3D"${rep.home}/workspaces"
defaultWorkspace=3D"default"/>

    <Workspace name=3D"${wsp.name}">
        <FileSystem
class=3D"org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name=3D"path" value=3D"${wsp.home}/filesystem"/>
        </FileSystem>

        <PersistenceManager
class=3D"org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
            <param name=3D"driver" value=3D"org.postgresql.Driver" />
        <param name=3D"url" value=3D"${jackrabbit.repository.url}" />
            <param name=3D"user" value=3D"${jackrabbit.repository.user}" />
            <param name=3D"password" value=3D"${jackrabbit.repository.passw=
ord}"
/>
            <param name=3D"schema" value=3D"postgresql"/>
            <param name=3D"schemaObjectPrefix" value=3D"J_PM_${wsp.name}_" =
/>
            <param name=3D"externalBLOBs" value=3D"false" />
        </PersistenceManager>

        <SearchIndex
class=3D"org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name=3D"path" value=3D"${wsp.home}/index"/>
        </SearchIndex>
    </Workspace>

    <Versioning rootPath=3D"${rep.home}/version">
        <FileSystem
class=3D"org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name=3D"path" value=3D"${rep.home}/version" />
        </FileSystem>

        <PersistenceManager
class=3D"org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
            <param name=3D"driver" value=3D"org.postgresql.Driver" />
        <param name=3D"url" value=3D"${jackrabbit.repository.url}" />
            <param name=3D"user" value=3D"${jackrabbit.repository.user}" />
            <param name=3D"password" value=3D"${jackrabbit.repository.passw=
ord}"
/>
            <param name=3D"schema" value=3D"postgresql"/>
            <param name=3D"schemaObjectPrefix" value=3D"J_V_PM_" />
            <param name=3D"externalBLOBs" value=3D"false" />
        </PersistenceManager>
    </Versioning>

    <SearchIndex
class=3D"org.apache.jackrabbit.core.query.lucene.SearchIndex">
        <param name=3D"path" value=3D"${rep.home}/repository/index"/>
    </SearchIndex>
</Repository>
--snap--

Regards,
Etile

On Thu, Oct 28, 2010 at 4:51 PM, Sergiy Shyrkov <my.public.mailing@gmail.co=
m
> wrote:

> Thank you for the prompt reply!
>
> Kind regards
> Sergiy
>
>
> On 28.10.2010 16:32, Thomas M=FCller wrote:
>
>> Hi,
>>
>>  Could you, please, give me some hints if there are any advantages in
>>> using
>>> DatabaseFileSystem compared to LocalFileSystem?
>>>
>> Yes, in my view LocalFileSystem is appropriate. Only config files are
>> stored in the FileSystem, no user data. LocalFileSystem is easier to
>> use and configure. Some people may want to avoid creating files in the
>> file system, so they can use a database FileSystem.
>>
>>  I assume, the information about clustering configuration
>>> (http://wiki.apache.org/jackrabbit/Clustering ) is also valid for
>>> Jackarabbit 2.1.x/2.2.x. Is it correct?
>>>
>> Yes.
>>
>> Regards,
>> Thomas
>>
>
>

--0016e6db5c3869bd6d04944a63c6--