[xwiki-users] HSQLDB to PostgreSQL cause of "embedded database does not support large wikis efficiently"
8 Jul
2010
8 Jul
'10
3 p.m.
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-da…
Sent from the XWiki- Users mailing list archive at Nabble.com.
8 Jul
8 Jul
4:04 p.m.
New subject: [xwiki-users] HSQLDB to PostgreSQL cause of "embedded database does not support large wikis efficiently"
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 <Aleksandar-Novakovic(a)web.de> 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-da…
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
6:41 p.m.
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!
26 Jul
26 Jul
11:58 a.m.
Marius Dumitru Florea wrote:
On 07/08/2010 04:00 PM, Aleks87 wrote:
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-da…
Sent from the XWiki- Users mailing list archive at Nabble.com.
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.
6:42 p.m.
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 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? 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.
5198
days inactive
5216
days old
4 comments
4 participants
participants (4)
-
Aleks87 -
Caleb James DeLisle -
Deven Phillips -
Marius Dumitru Florea