Page History
...
- PostgreSQL can be downloaded from http://www.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:
.Code Block 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
...
Overview
Content Tools