Changes for page PostgreSQL Installation

Last modified by Vincent Massol on 2024/03/15

<
From version < 11.6 >
edited by Sergiu Dumitriu
on 2012/11/19
To version < 11.7 >
edited by Manuel Smeria
on 2012/12/10
>
Change comment: Rewording

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Sergiu
1 +XWiki.ManuelSmeria
Content
... ... @@ -1,23 +1,20 @@
1 1  Follow these instuctions:
2 2  
3 -* Download and install PostgreSQL ([[http://www.postgresql.org/]])
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##)
3 +* Download and install [[PostgreSQL>>http://www.postgresql.org/]]
4 +* Download the appropriate [[Postgres JDBC4 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##)
5 5  * Start PostgreSQL
6 -** On Mac you could issue the following shell commands to start/stop PostgreSQL 9.1 (adapt to your version and to your setup):(((
7 -{{code language="none"}}
6 +** On Mac you could issue the following shell commands to start/stop PostgreSQL 9.1 (adapt to your version and to your setup):
7 +(((
8 +{{code}}
8 8  sudo -u postgres /Library/PostgreSQL/9.1/bin/pg_ctl start -D /Library/PostgreSQL/9.1/data
9 9  sudo -u postgres /Library/PostgreSQL/9.1/bin/pg_ctl stop -D /Library/PostgreSQL/9.1/data
10 10  {{/code}}
11 11  )))
12 12  * Create the ##xwiki## user and the ##xwiki## database:(((
13 -* Using the ##psql## tool:(((
14 +* Using the ##psql## tool:
15 +(((
16 +In a shell, start the PostgreSQL interactive terminal: {{code}}psql -U <replace_with_your_admin_user_eg_postgres>{{/code}}
14 14  
15 -In a shell, start the PostgreSQL interactive terminal:
16 -
17 -{{code language="none"}}
18 -psql -U <replace_with_your_admin_user_eg_postgres>;
19 -{{/code}}
20 -
21 21  Create the ##xwiki## database:
22 22  
23 23  {{code language="none"}}
... ... @@ -27,61 +27,27 @@
27 27  TABLESPACE = pg_default;
28 28  {{/code}}
29 29  
30 -Verify that the ##xwiki## database is listed in the available databases:
27 +Verify that the ##xwiki## database is listed in the available databases: {{code}}\l{{/code}}
31 31  
32 -{{code language="none"}}
33 -\l
34 -{{/code}}
29 +Connect to the ##xwiki## database: {{code}}\connect xwiki{{/code}}
35 35  
36 -Connect to the ##xwiki## database:
31 +Create a ##xwiki## user: {{code language="none"}}CREATE USER xwiki PASSWORD 'xwiki' VALID UNTIL 'infinity';{{/code}}
37 37  
38 -{{code language="none"}}
39 -\connect xwiki
40 -{{/code}}
33 +Verify that the ##xwiki## user is listed in the available users: {{code language="none"}}\du{{/code}}
41 41  
42 -Create a ##xwiki## user:
43 -
44 -{{code language="none"}}
45 -CREATE USER xwiki PASSWORD 'xwiki' VALID UNTIL 'infinity';
46 -{{/code}}
47 -
48 -Verify that the ##xwiki## user is listed in the available users:
49 -
50 -{{code language="none"}}
51 -\du
52 -{{/code}}
53 -
54 -Gives all permissions to the ##xwiki## user:
55 -
56 -{{code language="none"}}
57 -GRANT ALL ON SCHEMA public TO xwiki;
58 -{{/code}}
35 +Give all the permissions to the ##xwiki## user: {{code}}GRANT ALL ON SCHEMA public TO xwiki;{{/code}}
59 59  )))
60 -* Using the ##createuser## and ##createdb## programs:(((
61 -
37 +* Using the ##createuser## and ##createdb## programs:
38 +(((
39 +{{info}}
62 62  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).
41 +{{/info}}
63 63  
64 -Create the ##xwiki## user:
43 +Create the ##xwiki## user: {{code}}createuser xwiki -S -D -R -P -Upostgres{{/code}}
65 65  
66 -{{code}}
67 -createuser xwiki -S -D -R -P -Upostgres
68 -{{/code}}
45 +Create the ##xwiki## database: {{code}}createdb xwiki -Eunicode -Oxwiki -Upostgres{{/code}}
69 69  
70 -Create the ##xwiki## database:
71 -
72 -{{code}}
73 -createdb xwiki -Eunicode -Oxwiki -Upostgres
74 -{{/code}}
75 -
76 -Note that if you need to remove this DB at some point you can issue:
77 -
78 -{{code}}
79 -dropdb -Upostgres xwiki
80 -{{/code}}
47 +Note that if you need to remove this DB at some point you can issue:{{code}}dropdb -Upostgres xwiki{{/code}}
81 81  )))
82 82  )))
83 -* 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:(((
84 -{{code}}
85 -<property name="connection.url">jdbc:postgresql://localhost:5432/xwiki</property>
86 -{{/code}}
87 -)))
50 +* 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}}
XWiki.XWikiComments[8]
Date
... ... @@ -1,1 +1,1 @@
1 -2012-11-19 01:19:41.27
1 +2012-11-19 01:19:41.0

Get Connected