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

From Libopedia
Jump to navigation Jump to search
 
(128 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
==Step 6. Install PostgreSQL==
+
<center>
−
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 default password.
+
  '''[[SUNScholar/Prepare Ubuntu/S07|NEXT - STEP 7]]'''
 +
</center>
  
−
==Step 6.1: Install PostgreSQL==
+
==Step 6. Install the PostgreSQL database server==
−
  sudo apt-get install postgresql-8.4 libpg-java
+
DSpace can use the PostgreSQL or Oracle database server for the main database.
  
−
==Step 6.2: Setup PostgreSQL admin password==
+
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.
−
Change database user permissions to "trust" only.
+
<center>
−
  sudo sed -i 's/ident/trust/' /etc/postgresql/8.4/main/pg_hba.conf
+
  <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>
  
−
sudo sed -i 's/md5/trust/' /etc/postgresql/8.4/main/pg_hba.conf
+
==<font color="red">'''PLEASE NOTE'''</font>==
−
Restart database server.
+
*Please see critical database connection bug: https://jira.duraspace.org/browse/DS-2563
−
sudo /etc/init.d/postgresql-8.4 restart
+
*http://wiki.lib.sun.ac.za/index.php/SUNScholar/Optimisations/Database
−
Open a database shell...
 
−
sudo psql -U postgres
 
−
... and set the password:
 
−
alter role postgres with password 'dspace';
 
−
'''Note:''' Use your unique password for this on a production system !
 
  
−
Quit the database shell.
+
==[[SUNScholar/Prepare_Ubuntu/S06/Ubuntu-16.04|For Ubuntu 16.04 LTS]]==
−
\q
+
==[[SUNScholar/Prepare_Ubuntu/S06/Ubuntu-14.04|For Ubuntu 14.04 LTS]]==
  
−
==Step 6.3: Create the PostgreSQL 'dspace' user==
+
==[[SUNScholar/Prepare_Ubuntu/S06/Ubuntu-12.04|For Ubuntu 12.04 LTS]]==
−
First we become the postgres user
 
−
sudo su - postgres
 
−
Create the "dspace" database user with full privileges.
 
−
createuser -U postgres -d -A -P dspace
 
  
−
If asked the following:
+
<center>
−
  Shall the new role be allowed to create more new roles? (y/n) y
+
  '''[[SUNScholar/Prepare Ubuntu/S05|PREVIOUS - STEP 5]]'''
−
Answer "y" for yes.
+
</center>
  
−
==Step 6.4: Create the PostgreSQL 'dspace' database==
+
[[Category:Installation]]
−
Create the "dspace" database with the "dspace" database user.
+
__NOTOC__
−
createdb -U dspace -E UNICODE dspace
 
−
Now we exit as the postgres 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]]'''
 

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"