Change comment:
Rewording
Summary
-
Page properties (2 modified, 0 added, 0 removed)
-
Objects (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki.Ser giu1 +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]] (ordirectly 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 -C onnectto 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. 271 +2012-11-19 01:19:41.0