Changes for page PostgreSQL Installation

Last modified by Vincent Massol on 2024/03/15

<
From version < 15.1 >
edited by Vincent Massol
on 2015/07/28
To version < 16.1 >
edited by Vincent Massol
on 2017/03/02
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -2,8 +2,16 @@
2 2  {{toc/}}
3 3  {{/box}}
4 4  
5 -Follow these instuctions:
5 += Installation =
6 6  
7 +You have 2 options:
8 +* Install PostgreSQL on your machine manually
9 +* Use the official PostgreSQL docker image
10 +
11 +== Manual Installation ==
12 +
13 +Follow these instructions:
14 +
7 7  * Download and install [[PostgreSQL>>http://www.postgresql.org/]]
8 8  * Download the appropriate [[Postgres JDBC41 driver>>http://jdbc.postgresql.org/download.html]]. You can also download it directly from the [[Maven Central Repository>>http://repo1.maven.org/maven2/postgresql/postgresql/]] and copy the JAR into your container's common lib directory or in the XWiki webapp (in ##WEB-INF/lib##)
9 9  * Start PostgreSQL
... ... @@ -50,6 +50,17 @@
50 50  )))
51 51  * Tell XWiki to use this database. To do this, edit the ##WEB-INF/hibernate.cfg.xml## file where you have expanded the XWiki WAR file and uncomment the PostgreSQL part. Make sure to review the ##connection.url## property. For example a typical value would be:{{code}}<property name="connection.url">jdbc:postgresql://localhost:5432/xwiki</property>{{/code}}
52 52  
61 +== Using Docker ==
62 +
63 +* Install Docker
64 +* Run the following command (update to your needs):(((
65 +{{code language="bash"}}
66 +docker run --name pgtest -e POSTGRES_PASSWORD=xwiki -e POSTGRES_ROOT_PASSWORD=xwiki -e POSTGRES_USER=xwiki -e POSTGRES_DB=xwiki -e POSTGRES_INITDB_ARGS="--encoding=UTF8" -v postgres-data:/var/lib/postgresql/data -p 5432:5432 postgres:9.5
67 +{{/code}}
68 +)))
69 +* Download the appropriate [[Postgres JDBC41 driver>>http://jdbc.postgresql.org/download.html]]. You can also download it directly from the [[Maven Central Repository>>http://repo1.maven.org/maven2/postgresql/postgresql/]] and copy the JAR into your container's common lib directory or in the XWiki webapp (in ##WEB-INF/lib##)
70 +* Tell XWiki to use this database. To do this, edit the ##WEB-INF/hibernate.cfg.xml## file where you have expanded the XWiki WAR file and uncomment the PostgreSQL part. Make sure to review the ##connection.url## property. For example a typical value would be:{{code}}<property name="connection.url">jdbc:postgresql://localhost:5432/xwiki</property>{{/code}}
71 +
53 53  = Multiwiki Status =
54 54  
55 55  Prior to XWiki 4.5M1, multiwiki mode was not fully working on PostgreSQL. Since XWiki 4.5M1, we've made it work in ##schema## mode (i.e. a subwiki is represented as a Schema in the database). However it's not working in ##database## mode for the moment (i.e. a subwiki is represented as a Catalog in the database) because the PostGreSQL JDBC Driver doesn't support yet the ##setCatalog## method.

Get Connected