EPrints 3.4 and PostgreSQL - Revision history

Th.lauke@arcor.de: categories added

2024-02-19T13:08:03Z

categories added

Drn@ecs.soton.ac.uk: /* Installiing and Configuring PostgreSQL */

2021-01-21T09:38:11Z

‎Installiing and Configuring PostgreSQL

Drn@ecs.soton.ac.uk: Added page discussing using PostgreSQL with EPrints 3.4

2021-01-21T09:37:26Z

Added page discussing using PostgreSQL with EPrints 3.4

New page

EPrints has supported PostgreSQL since quite early in its development. However, MySQL is the default database engine, so few repositories actually use PostgreSQL. This page examines how to setup the latest version of EPrints 3.4 (currently 3.4.2) using PostgresSQL.

== Installiing and Configuring PostgreSQL ==
'''This is based on installing on a CentOS 7 Linux operating system.'''
Carry out the following steps as the ''root'' user.
1. Install the required packages using YUM:
yum install postgresql postgresql-server perl-DBD-Pg
2. Perform initial PostgreSQL setup
postgresql-setup initdb
3. Edit ''/var/lib/pgsql/data/pg_hba.conf'' by changing the following two lines to allow password-less local access and access from localhost (i.e. when using ''--host localhost'' flag with ''psql''):
local all all peer
host all all 127.0.0.1/32 ident
to
local all all trust
host all all 127.0.0.1/32 trust
You may wish to set authentication option to ''md5'' rather than ''trust'' to restrict access for some users on your server but you will need to manual set a password for the ''postgres'' user.

4. Enable and start PostgreSQL on the operating system
systemctl enable postgresql
systemctl start postgresql

== Creating an EPrints archive with a PostgreSQL database ==
'''To be written...'''

← Older revision		Revision as of 13:08, 19 February 2024
Line 1:		Line 1:
		+	{{Work in Progress}}
		+	[[Category:Work in Progress\|Deprecated]]
	EPrints has supported PostgreSQL since quite early in its development. However, MySQL is the default database engine, so few repositories actually use PostgreSQL. This page examines how to setup the latest version of EPrints 3.4 (currently 3.4.2) using PostgresSQL.		EPrints has supported PostgreSQL since quite early in its development. However, MySQL is the default database engine, so few repositories actually use PostgreSQL. This page examines how to setup the latest version of EPrints 3.4 (currently 3.4.2) using PostgresSQL.

@@ Line 12: / Line 12: @@
   host    all             all             127.0.0.1/32            ident
 to
-local   all             all                                     trust
+ local   all             all                                     trust
-host    all             all             127.0.0.1/32            trust
+ host    all             all             127.0.0.1/32            trust
 You may wish to set authentication option to ''md5'' rather than ''trust'' to restrict access for some users on your server but you will need to manual set a password for the ''postgres'' user.