[xwiki-users] postgres limitation - xwiki-users@xwiki.org - lists.xwiki.org

List overview All Threads
Download

[xwiki-users] postgres limitation

[xwiki-users] Who is watching?

[xwiki-users] Xwiki Enterprise...

Pascal BASTIEN

7 Oct 2014 7 Oct '14

5:56 p.m.

Hello, Do you know if this limitation is still there? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#… "Multi Wiki not working in database mode" If I use a postgresql database and I want another subwiki, are there a doc to create manualy another associated database? Thanks you. Pascal B

Reply

Show replies by date

Thomas Mortagne

7 Oct 7 Oct

6:12 p.m.

Do you absolutely need to have each wiki is a different database ? Ad indicated on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#… by default each wiki has it's own schema in the same database and it's working well as far as I know. On Tue, Oct 7, 2014 at 5:56 PM, Pascal BASTIEN <pbasnews-xwiki(a)yahoo.fr> wrote:

Hello, Do you know if this limitation is still there? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#… "Multi Wiki not working in database mode" If I use a postgresql database and I want another subwiki, are there a doc to create manualy another associated database? Thanks you. Pascal B _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Thomas Mortagne

Reply

Pascal BASTIEN

9:42 p.m.

wow ... ok in fact I had misunderstand this chapter :-/ Sorry I will try it. :-) ________________________________ De : Thomas Mortagne <thomas.mortagne(a)xwiki.com> À : Pascal BASTIEN <pbasnews-xwiki(a)yahoo.fr>fr>; XWiki Users <users(a)xwiki.org> Envoyé le : Mardi 7 octobre 2014 18h12 Objet : Re: [xwiki-users] postgres limitation Do you absolutely need to have each wiki is a different database ? Ad indicated on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#… by default each wiki has it's own schema in the same database and it's working well as far as I know. On Tue, Oct 7, 2014 at 5:56 PM, Pascal BASTIEN <pbasnews-xwiki(a)yahoo.fr> wrote:

Hello, Do you know if this limitation is still there? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#… "Multi Wiki not working in database mode" If I use a postgresql database and I want another subwiki, are there a doc to create manualy another associated database? Thanks you. Pascal B _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Thomas Mortagne

Reply

Paul Libbrecht

8 Oct 8 Oct

7:41 a.m.

Just a matter of feelings, it would seem to me that a different DB and, thus, a different connection pool, disk space, SQL user, ‎and set of locks would appear very trustable to me. I understand different tables by wiki brings only separate locks... Right? Paul -- fat fingered on my z10 -- Message d'origine De: Thomas Mortagne Envoyé: Dienstag, 7. Oktober 2014 18:12 À: Pascal BASTIEN; XWiki Users Répondre à: XWiki Users Objet: Re: [xwiki-users] postgres limitation Do you absolutely need to have each wiki is a different database ? Ad indicated on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#… by default each wiki has it's own schema in the same database and it's working well as far as I know. On Tue, Oct 7, 2014 at 5:56 PM, Pascal BASTIEN <pbasnews-xwiki(a)yahoo.fr> wrote:

Hello, Do you know if this limitation is still there? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#… "Multi Wiki not working in database mode" If I use a postgresql database and I want another subwiki, are there a doc to create manualy another associated database? Thanks you. Pascal B _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Thomas Mortagne _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Reply

Bryn Jeffries

10 Oct 10 Oct

11:21 a.m.

On 8/10/2014 4:41 PM, Paul Libbrecht wrote:

Just a matter of feelings, it would seem to me that a different DB and, thus, a different connection pool, disk space, SQL user, ‎and set of locks would appear very trustable to me. I understand different tables by wiki brings only separate locks... Right?

PostgreSQL doesn't generally have locks, as it mostly uses Snapshot Isolation. So there's little benefit in separate databases for this reason. For disk space, it's possible to specify different tablespaces for the additional schemas, although you can't do this within the wiki interface (you'd need to use psql).

Reply

3629

days inactive

3632

days old

xwiki-users@xwiki.org

Manage subscription

4 comments

4 participants

tags (0)

participants (4)

Bryn Jeffries
Pascal BASTIEN
Paul Libbrecht
Thomas Mortagne