[xwiki-users] HSQLDB to PostgreSQL cause of "embedded database does not support large wikis efficiently"
I have installed the standalone version of XWiki Enterprise 2.4 M1 The standalone installation have a HSQLDB Database which I should not use. Is it right? So I have to change the Database. And I decided to use PostgreSQL 8.3 cause it was already installed on this pc. At this time I dont have the rights (password) to create a Database and I have to contact the Admin for that. But I'm not sure how this all should work. Now I have a Folder "\XWiki Enterprise\database" where my XWiki content will be saved. Is it right? But changing to PostgreSQL I can erase this Folder because my Database will now been in "\PostgreSQL\8.3\data". Right? I know that I have to change my hibernate.cfg.xml and to add a .jar to "\XWiki Enterprise\webapps\xwiki\WEB-INF\lib". But what .jar is the right one? "postgresql-8.3-603.jdbc3.jar" or "postgresql-8.3-603.jdbc4.jar" And if I have done that I can access the wiki over http://localhost:5432/xwiki/bin/view/Main/ (5432 instead of 8080 because of PostgreSQL) But how could the other people access the wiki. I heared it will be possible with "\\myip:5432/xwiki/bin/view/Main" if all pc's are in the same network. But it would mean that my pc have to run constantly. And the start_xwiki.bat file has to be opened. I think that would not be the problem. But would my wiki get performance problems after a few days?! And how safe is this all... Sorry I'm very new to this all and I have read many tutorials and helps in the last weeks but I'm not sure if I understand them right. If someone could answer my questions and give me some tips how to implement this all, it would be very helpful. Thank you! -- View this message in context: http://xwiki.475771.n2.nabble.com/HSQLDB-to-PostgreSQL-cause-of-embedded-dat... Sent from the XWiki- Users mailing list archive at Nabble.com.
The Web Application will still run on port 8080 by default. The difference here is that the data will be stored on PostgreSQL instead of HSQLDB. I would recommend following the document at : http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationPostgreSQL And reply back here if you still have questions. Thanks, Deven On Thu, Jul 8, 2010 at 9:00 AM, Aleks87 <[email protected]> wrote:
I have installed the standalone version of XWiki Enterprise 2.4 M1 The standalone installation have a HSQLDB Database which I should not use. Is it right? So I have to change the Database. And I decided to use PostgreSQL 8.3 cause it was already installed on this pc. At this time I dont have the rights (password) to create a Database and I have to contact the Admin for that. But I'm not sure how this all should work. Now I have a Folder "\XWiki Enterprise\database" where my XWiki content will be saved. Is it right? But changing to PostgreSQL I can erase this Folder because my Database will now been in "\PostgreSQL\8.3\data". Right?
I know that I have to change my hibernate.cfg.xml and to add a .jar to "\XWiki Enterprise\webapps\xwiki\WEB-INF\lib". But what .jar is the right one? "postgresql-8.3-603.jdbc3.jar" or "postgresql-8.3-603.jdbc4.jar"
And if I have done that I can access the wiki over http://localhost:5432/xwiki/bin/view/Main/ (5432 instead of 8080 because of PostgreSQL)
But how could the other people access the wiki. I heared it will be possible with "\\myip:5432/xwiki/bin/view/Main" if all pc's are in the same network. But it would mean that my pc have to run constantly. And the start_xwiki.bat file has to be opened. I think that would not be the problem. But would my wiki get performance problems after a few days?! And how safe is this all...
Sorry I'm very new to this all and I have read many tutorials and helps in the last weeks but I'm not sure if I understand them right. If someone could answer my questions and give me some tips how to implement this all, it would be very helpful.
Thank you! -- View this message in context: http://xwiki.475771.n2.nabble.com/HSQLDB-to-PostgreSQL-cause-of-embedded-dat... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On 07/08/2010 04:00 PM, Aleks87 wrote:
I have installed the standalone version of XWiki Enterprise 2.4 M1 The standalone installation have a HSQLDB Database which I should not use.
Is it right?
It all depends on what you plan to do with your wiki. If you just want to play with it, test it, or even use it internally for a few people then HSQLDB is fine. If you plan to make it public on the web or an a wide network then it's recommended that you switch to a more reliable database.
So I have to change the Database. And I decided to use PostgreSQL 8.3 cause it was already installed on this pc. At this time I dont have the rights (password) to create a Database and I have to contact the Admin for that. But I'm not sure how this all should work.
Now I have a Folder "\XWiki Enterprise\database" where my XWiki content will be saved. Is it right?
Yes, HSQLDB stores its data in the database directory.
But changing to PostgreSQL I can erase this Folder because my Database will now been in "\PostgreSQL\8.3\data". Right?
Yes, if you switch to a different database then you can delete the database directory, but first make sure you don't have important wiki pages you wish to keep. If you do have, you can export them and then reimport after moving to a different database. Note that the HSQLDB database of the standalone XE contains already the default XE pages. You'll have to import the default XAR after switching to a different database.
I know that I have to change my hibernate.cfg.xml and to add a .jar to "\XWiki Enterprise\webapps\xwiki\WEB-INF\lib". But what .jar is the right one? "postgresql-8.3-603.jdbc3.jar" or "postgresql-8.3-603.jdbc4.jar"
And if I have done that I can access the wiki over http://localhost:5432/xwiki/bin/view/Main/ (5432 instead of 8080 because of PostgreSQL)
No, you would still use 8080. The port where your database listens for connections is different than the port where Jetty (the web server) listens for connections.
But how could the other people access the wiki. I heared it will be possible with "\\myip:5432/xwiki/bin/view/Main" if all pc's are in the same network.
Indeed.
But it would mean that my pc have to run constantly. And the start_xwiki.bat file has to be opened. I think that would not be the problem. But would my wiki get performance problems after a few days?! And how safe is this all...
You might want to increase the memory allocated to the Jetty server. Hope this helps, Marius
Sorry I'm very new to this all and I have read many tutorials and helps in the last weeks but I'm not sure if I understand them right. If someone could answer my questions and give me some tips how to implement this all, it would be very helpful.
Thank you!
Marius Dumitru Florea wrote:
On 07/08/2010 04:00 PM, Aleks87 wrote:
I have installed the standalone version of XWiki Enterprise 2.4 M1 The standalone installation have a HSQLDB Database which I should not use.
Is it right?
It all depends on what you plan to do with your wiki. If you just want to play with it, test it, or even use it internally for a few people then HSQLDB is fine. If you plan to make it public on the web or an a wide network then it's recommended that you switch to a more reliable database.
I plan to use it in an intern network. About 7 people would use it for knowledge exchange. That means that they can create owen wiki pages and if necessary they can add attachments. But there will also be a "TodoClass" and similiar to the Todo a ToolClass where the user can post usefull tools. The Event Calendar is also included to add meating dates and the PhotoAlbumsClass to add photos from the last party^^ (don't know if we would use it, cause its very exhausting to add all the photos individually). My Database is now about 35MB and I,ve only created a few test pages. I have to add 75MB KnowHow saved in word, excel and text editor files...don't know how much MB it would be if I copy the content of the files in a wiki page. Some files I'll only attach because it takes to long to copy, paste and modify all the text. How much MB can HSQLDB handle? Where can I change this value? And would you advise me to use another database? -- View this message in context: http://xwiki.475771.n2.nabble.com/HSQLDB-to-PostgreSQL-cause-of-embedded-dat... Sent from the XWiki- Users mailing list archive at Nabble.com.
My understanding is large or many attachments can cause problems for HSQL so I would be on the safe side and switch to Postgres because it is a pain to have a database large enough that it causes the import/export system problems and then have to use a large export tool and hope for the best. Also in my experience installing on Postgres is very easy (especially on a Linux system where you can install Postgres with the package manager) The only limitation is you can't have multiple sub-wikis with Postgres. Caleb Aleks87 wrote:
Marius Dumitru Florea wrote:
On 07/08/2010 04:00 PM, Aleks87 wrote:
I have installed the standalone version of XWiki Enterprise 2.4 M1 The standalone installation have a HSQLDB Database which I should not use. Is it right? It all depends on what you plan to do with your wiki. If you just want to play with it, test it, or even use it internally for a few people then HSQLDB is fine. If you plan to make it public on the web or an a wide network then it's recommended that you switch to a more reliable database.
I plan to use it in an intern network. About 7 people would use it for knowledge exchange. That means that they can create owen wiki pages and if necessary they can add attachments. But there will also be a "TodoClass" and similiar to the Todo a ToolClass where the user can post usefull tools. The Event Calendar is also included to add meating dates and the PhotoAlbumsClass to add photos from the last party^^ (don't know if we would use it, cause its very exhausting to add all the photos individually). My Database is now about 35MB and I,ve only created a few test pages. I have to add 75MB KnowHow saved in word, excel and text editor files...don't know how much MB it would be if I copy the content of the files in a wiki page. Some files I'll only attach because it takes to long to copy, paste and modify all the text.
How much MB can HSQLDB handle? Where can I change this value? And would you advise me to use another database?
participants (4)
-
Aleks87 -
Caleb James DeLisle -
Deven Phillips -
Marius Dumitru Florea