Page History
...
Relational Database: (PostgreSQL or Oracle)
PostgreSQL 9.4 or later (with pgcrypto installed)
Warning | ||||
---|---|---|---|---|
| ||||
PostgreSQL users MUST ensure they are running 9.4 or above AND have the pgcrypto extension installed and enabled. The pgcrypto extension allows DSpace to create UUIDs (universally unique identifiers) for all objects in DSpace, which means that (internal) object identifiers are now globally unique and no longer tied to database sequences. |
- PostgreSQL later: PostgreSQL can be downloaded from http://www.postgresql.org/ .postgresql.org/. It is also provided via many operating system package managers
- If the version of Postgres provided by your package manager is outdated, you may wish to use one of the official PostgreSQL provided repositories:
- Linux users can select their OS of choice for detailed instructions on using the official PostgreSQL apt or yum repository: http://www.postgresql.org/download/linux/
- Windows users will need to use the windows installer: http://www.postgresql.org/download/windows/
- Mac OSX users can choose their preferred installation method: http://www.postgresql.org/download/macosx/
- If the version of Postgres provided by your package manager is outdated, you may wish to use one of the official PostgreSQL provided repositories:
- Install the pgcrypto extension. It will also need to be enabled on your DSpace Database (see Installation instructions below for more info).
- On most Linux operating systems (Ubuntu, Debian, RedHat), this extension is provided in the "postgresql-contrib" package in your package manager. So, ensure you've installed "postgresql-contrib".
- On Windows, this extension should be provided automatically by the installer (check your "[PostgreSQL]/share/extension" folder for files starting with "pgcrypto")
- .Unicode (specifically UTF-8) support must be enabled (but this is enabled by default).
- Once installed, you need to enable TCP/IP connections (DSpace uses JDBC):
- In
postgresql.conf
: uncomment the line starting:listen_addresses = 'localhost'
. This is the default, in recent PostgreSQL releases, but you should at least check it. - Then tighten up security a bit by editing
pg_hba.conf
and adding this line:host dspace dspace 127.0.0.1 255.255.255.255 md5
. This should appear before any lines matchingall
databases, because the first matching rule governs. - Then restart PostgreSQL.
- In
Oracle 10g or later
- :Details on acquiring Oracle can be downloaded from the following location: http://www.oracle.com/database/. You will need to create a database for DSpace. Make sure that the character set is one of the Unicode character sets. DSpace uses UTF-8 natively, and it is suggested that the Oracle database use the same character set. You will also need to create a user account for DSpace (e.g. dspace) and ensure that it has permissions to add and remove tables in the database. Refer to the Quick Installation for more details.
- NOTE: If the database server is not on the same machine as DSpace, you must install the Oracle client to the DSpace server and point
tnsnames.ora
andlistener.ora
files to the database the Oracle server. - NOTE: DSpace uses sequences to generate unique object IDs — beware Oracle sequences, which are said to lose their values when doing a database export/import, say restoring from a backup. Be sure to run the script etc/oracle/update-sequences.sql after importing.
- For people interested in switching from Postgres PostgreSQL to Oracle , I know of no tools that would do this automatically. You will need to recreate the community, collection, and eperson structure in the Oracle system, and then use the item export and import tools to move your content over.(or visa versa), you may be able to inves
- NOTE: If the database server is not on the same machine as DSpace, you must install the Oracle client to the DSpace server and point
Servlet Engine (Apache Tomcat 7 or later, Jetty, Caucho Resin or equivalent)
...
Overview
Content Tools