Alfresco Community 23.x Install PostgreSQL 15.x

Alfresco Supported platforms

Here is a list of the individual components that have been through the complete Alfresco Quality Assurance and Certification activities for Alfresco Content Services 23.x.

Install Initial Packages

sudo apt install dirmngr ca-certificates software-properties-common apt-transport-https lsb-release curl -y

Import Repository

# import the PostgreSQL GPG key
curl -fSsL https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo tee /usr/share/keyrings/postgresql.gpg > /dev/null

# Import stable APT repository

echo deb [arch=amd64,arm64,ppc64el signed-by=/usr/share/keyrings/postgresql.gpg] http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main | sudo tee /etc/apt/sources.list.d/postgresql.list

Install PostgreSQL 15

# Update your repository sources list 
sudo apt update

# install PostgreSQL
sudo apt install postgresql-client-15 postgresql-15

# verify the software’s status 
systemctl status postgresql

Output:

● postgresql.service - PostgreSQL RDBMS
     Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
     Active: active (exited) since Mon 2024-04-22 07:13:14 UTC; 8s ago
    Process: 391 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
   Main PID: 391 (code=exited, status=0/SUCCESS)
        CPU: 2ms

Prepare Database for ACS

Prepare alfresco database, user and assign privileges

ubuntu@alfresco23x:~$ sudo su - postgres
postgres@alfresco23x:~$ psql

Create a database named alfresco. Set default encoding which is utf8.

postgres=# create database alfresco encoding 'utf8';
CREATE DATABASE

Create a user named alfresco with password alfresco

postgres=# create role alfresco LOGIN password 'alfresco';
CREATE ROLE

Grant all permissions for user alfresco on database alfresco.

postgres=# grant all on database alfresco to alfresco;
GRANT

LifeIsSimpleWhenYouLiveSimply

KnowledgeDiscoveryInData