Difference between revisions of "SUNScholar/Prepare Ubuntu/S06"

From Libopedia
Jump to navigation Jump to search
 
(110 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
<center>
 
<center>
−
'''[[SUNScholar/Prepare Ubuntu|Prepare Ubuntu - Index]]'''
+
  '''[[SUNScholar/Prepare Ubuntu/S07|NEXT - STEP 7]]'''
 
</center>
 
</center>
  
−
==Step 6. Install PostgreSQL==
+
==Step 6. Install the PostgreSQL database server==
−
DSpace uses the PostgreSQL database server for the main catalog database. The following procedure installs the PostgreSQL server and creates the "dspace" database and "dspace" database user with the very secret dspace database user password.
+
DSpace can use the PostgreSQL or Oracle  database server for the main database.
  
−
==Step 6.1: Install PostgreSQL==
+
The following procedure installs the PostgreSQL database server and creates the "dspace" database and "dspace" database user with the very secret dspace database user password.
−
  sudo apt-get install postgresql-8.4 libpg-java
+
<center>
 +
  <font color="red">'''The PostgreSQL database server was chosen because it is open source software and this in keeping with the open access pathos.'''</font>
 +
</center>
  
−
==Step 6.2: Setup PostgreSQL admin password==
+
==<font color="red">'''PLEASE NOTE'''</font>==
−
Change database user permissions to "trust" only.
+
*Please see critical database connection bug: https://jira.duraspace.org/browse/DS-2563
−
sudo sed -i 's/ident/trust/' /etc/postgresql/8.4/main/pg_hba.conf
+
*http://wiki.lib.sun.ac.za/index.php/SUNScholar/Optimisations/Database
  
−
sudo sed -i 's/md5/trust/' /etc/postgresql/8.4/main/pg_hba.conf
+
==[[SUNScholar/Prepare_Ubuntu/S06/Ubuntu-16.04|For Ubuntu 16.04 LTS]]==
−
Restart database server.
+
==[[SUNScholar/Prepare_Ubuntu/S06/Ubuntu-14.04|For Ubuntu 14.04 LTS]]==
−
sudo /etc/init.d/postgresql-8.4 restart
 
−
Become the postgres user
 
−
sudo su postgres
 
−
Open a database shell...
 
−
psql -U postgres
 
−
... and set the password:
 
−
alter role postgres with password 'XXXXXX';
 
−
'''Note: Use your unique system admin password for this on a production system !'''
 
  
−
Quit the database shell.
+
==[[SUNScholar/Prepare_Ubuntu/S06/Ubuntu-12.04|For Ubuntu 12.04 LTS]]==
−
\q
 
  
−
==Step 6.3: Create the PostgreSQL "dspace" user==
+
<center>
−
Create the "dspace" user with full privileges.
+
  '''[[SUNScholar/Prepare Ubuntu/S05|PREVIOUS - STEP 5]]'''
−
createuser -U postgres -d -A -P dspace
+
</center>
−
 
 
−
If asked the following:
 
−
Shall the new role be allowed to create more new roles? (y/n) y
 
−
Answer "y" for yes.
 
−
 
 
−
==Step 6.4: Create the PostgreSQL 'dspace' database==
 
−
Create the dspace database user and set password.
 
−
psql -U postgres
 
−
... and set the password:
 
−
alter role dspace with password 'XXXXXX';
 
−
'''Note: Use your unique dspace database password for this on a production system !'''
 
−
 
 
−
Quit the database shell.
 
−
\q
 
−
 
 
−
Create the "dspace" database with the "dspace" database user as owner.
 
−
createdb -U dspace -E UNICODE dspace
 
−
 
 
−
We return to the dspace user
 
−
exit
 
−
 
 
−
==Step 6.5: Setup database host and user access permissions==
 
−
Type the following:
 
−
sudo echo "## DSpace user access">> /etc/postgresql/8.4/main/pg_hba.conf
 
−
 
 
−
sudo echo "host    dspace      dspace      127.0.0.1/32        md5">> /etc/postgresql/8.4/main/pg_hba.conf
 
−
 
 
−
==Step 6.6: Setup number of client connections==
 
−
Edit the postgresql config file:
 
−
 
 
−
sudo nano /etc/postgresql/8.4/main/postgresql.conf
 
−
 
 
−
Change the number of "max_connections" to 300.
 
−
 
 
−
{{NANO}}
 
−
 
 
−
==Step 6.7: Increase the kernel shared memory for postgresql connections==
 
−
Edit the "/etc/sysctl.conf" file:
 
−
 
 
−
sudo nano /etc/sysctl.conf
 
−
 
 
−
Copy and paste the following to the end of the file:
 
−
<pre>
 
−
# Postgres connections
 
−
kernel.shmmax = 500000000
 
−
kernel.shmall = 500000000
 
−
</pre>
 
−
 
 
−
{{NANO}}
 
−
 
 
−
Type the following in a terminal:
 
−
 
 
−
sudo sysctl -p
 
−
 
 
−
==Step 6.8: Restart the PostgreSQL server==
 
−
Type the following:
 
−
 
 
−
  sudo /etc/init.d/postgresql-8.4 restart
 
−
----
 
−
Below is a screenshot of the yearly DB connections.
 
−
 
 
−
[[File:Sunscholar-postgres connections db-year.png]]
 
−
 
 
−
  '''[[SUNScholar/Prepare Ubuntu/S05|PREVIOUS]]'''
 
  
−
  '''[[SUNScholar/Prepare Ubuntu/S07|NEXT]]'''
+
[[Category:Installation]]
 +
__NOTOC__

Latest revision as of 14:13, 30 October 2019

 NEXT - STEP 7

Step 6. Install the PostgreSQL database server

DSpace can use the PostgreSQL or Oracle database server for the main database.

The following procedure installs the PostgreSQL database server and creates the "dspace" database and "dspace" database user with the very secret dspace database user password. 

The PostgreSQL database server was chosen because it is open source software and this in keeping with the open access pathos.

PLEASE NOTE

For Ubuntu 16.04 LTS

For Ubuntu 14.04 LTS

For Ubuntu 12.04 LTS

PREVIOUS - STEP 5
Retrieved from "http://wiki.lib.sun.ac.za/index.php?title=SUNScholar/Prepare_Ubuntu/S06&oldid=45661"