[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 <[email protected]> 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 [email protected] 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 <[email protected]> À : Pascal BASTIEN <[email protected]>; XWiki Users <[email protected]> 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 <[email protected]> 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 [email protected] 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 <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] 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