Hide last authors
author | version | line-number | content |
---|---|---|---|
![]() |
1.18 | 1 | Follow these instuctions: |
2 | |||
![]() |
1.1 | 3 | * Download and install PostgreSQL (http://www.postgresql.org/) |
![]() |
7.1 | 4 | * Download appropriate [[Postgres JDBC4 driver>>http://jdbc.postgresql.org/download.html]] (or 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##) |
![]() |
1.1 | 5 | * Start PostgreSQL |
![]() |
7.1 | 6 | * Create the ##xwiki## user and the ##xwiki## database:((( |
7 | * Using the ##psql## tool:((( | ||
![]() |
1.1 | 8 | |
![]() |
7.1 | 9 | In a shell, start the PostgreSQL interactive terminal: |
10 | |||
![]() |
3.1 | 11 | {{code language="none"}} |
![]() |
7.1 | 12 | psql -U <replace_with_your_admin_user_eg_postgres>; |
13 | {{/code}} | ||
![]() |
1.1 | 14 | |
![]() |
7.1 | 15 | Create the ##xwiki## database: |
![]() |
8.1 | 16 | |
![]() |
7.1 | 17 | {{code language="none"}} |
![]() |
1.10 | 18 | CREATE DATABASE xwiki |
![]() |
4.1 | 19 | WITH OWNER = <replace_with_your_admin_user_eg_postgres> |
![]() |
1.10 | 20 | ENCODING = 'UNICODE' |
21 | TABLESPACE = pg_default; | ||
![]() |
7.1 | 22 | {{/code}} |
![]() |
1.10 | 23 | |
![]() |
7.1 | 24 | Verify that the ##xwiki## database is listed in the available databases: |
25 | |||
26 | {{code language="none"}} | ||
![]() |
5.1 | 27 | \l |
![]() |
7.1 | 28 | {{/code}} |
![]() |
5.1 | 29 | |
![]() |
7.1 | 30 | Connect to the ##xwiki## database: |
31 | |||
32 | {{code language="none"}} | ||
![]() |
2.1 | 33 | \connect xwiki |
![]() |
7.1 | 34 | {{/code}} |
![]() |
1.16 | 35 | |
![]() |
7.1 | 36 | Create a ##xwiki## user: |
37 | |||
38 | {{code language="none"}} | ||
![]() |
1.16 | 39 | CREATE USER xwiki PASSWORD 'xwiki' VALID UNTIL 'infinity'; |
![]() |
7.1 | 40 | {{/code}} |
![]() |
1.16 | 41 | |
![]() |
7.1 | 42 | Verify that the ##xwiki## user is listed in the available users: |
43 | |||
44 | {{code language="none"}} | ||
![]() |
6.1 | 45 | \du |
![]() |
7.1 | 46 | {{/code}} |
![]() |
6.1 | 47 | |
![]() |
7.1 | 48 | Gives all permissions to the ##xwiki## user: |
49 | |||
50 | {{code language="none"}} | ||
![]() |
1.10 | 51 | GRANT ALL ON SCHEMA public TO xwiki; |
![]() |
3.1 | 52 | {{/code}} |
![]() |
7.1 | 53 | ))) |
54 | * Using the ##createuser## and ##createdb## programs:((( | ||
![]() |
1.1 | 55 | |
![]() |
7.1 | 56 | Make sure that the ##createuser## and ##createdb## programs are in your ##$PATH##. The example below also assumes that the ##postgres## user exists in your setup (this is the default on Linux). |
![]() |
3.1 | 57 | |
![]() |
7.1 | 58 | Create the ##xwiki## user: |
59 | |||
![]() |
3.1 | 60 | {{code}} |
![]() |
7.1 | 61 | createuser xwiki -S -D -R -P -Upostgres |
![]() |
3.1 | 62 | {{/code}} |
![]() |
7.1 | 63 | |
64 | Create the ##xwiki## database: | ||
65 | |||
66 | {{code}} | ||
67 | createdb xwiki -Eunicode -Oxwiki -Upostgres | ||
68 | {{/code}} | ||
![]() |
4.1 | 69 | ))) |
![]() |
7.1 | 70 | ))) |
![]() |
9.1 | 71 | * 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:((( |
![]() |
3.1 | 72 | {{code}} |
![]() |
1.24 | 73 | <property name="connection.url">jdbc:postgresql://localhost:5432/xwiki</property> |
![]() |
4.1 | 74 | {{/code}} |
75 | ))) |