[xwiki-users] postgres limitation
Hello, Do you know if this limitation is still there? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#H... "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
Do you absolutely need to have each wiki is a different database ? Ad indicated on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#H... 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@yahoo.fr> wrote:
Hello, Do you know if this limitation is still there?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#H...
"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@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
wow ... ok in fact I had misunderstand this chapter :-/ Sorry I will try it. :-) ________________________________ De : Thomas Mortagne <thomas.mortagne@xwiki.com> À : Pascal BASTIEN <pbasnews-xwiki@yahoo.fr>; XWiki Users <users@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#H... 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@yahoo.fr> wrote:
Hello, Do you know if this limitation is still there?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#H...
"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@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
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#H... 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@yahoo.fr> wrote:
Hello, Do you know if this limitation is still there?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL#H...
"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@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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).
participants (4)
-
Bryn Jeffries -
Pascal BASTIEN -
Paul Libbrecht -
Thomas Mortagne