3,299
edits
Changes
From SME Server
Jump to navigationJump to searchno edit summary
Line 1:
Line 1:
+see the smeserver-postgresql rpm by charlie, what does this provide, suggest changes to this rather than creating a howto+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
===Koozali SME v10 and manual install with systemd===
−{{Note box| There is now a contrib for Koozali SME Server v10 - See above for [[Postgres#How_to_install_Postgresql_13|easy installation]]}}
− yum install smeserver-postgresql --enablerepo=smecontribs
+This is for reference with PostGresql12 and manual installation:
+ db yum_repositories set postgresql12 repository \
+ BaseURL https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7Server-\$basearch/ \
+ EnableGroups no \
+ GPGCheck yes \
+ Name "Postgresql-12" \
+ GPGKey https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-12 \
+ Visible no \
+ status disabled
+Update yum
+ signal-event yum-modify
+Install the rpms
+ yum --enablerepo=postgresql12 install postgresql12-server postgresql12-contrib
+Set a config key for SME to recognise the service:
+ config set postgresql-12 service status enabled access private
+We will need a file:
+ mkdir -p /usr/lib/systemd/system/postgresql-12.service.d
+ nano /usr/lib/systemd/system/postgresql-12.service.d/50koozali.conf
+Add something like this:
+ [Unit]
+ After=network.target network.service wan.service
+ [Install]
+ WantedBy=sme-server.target
+Reconfigure and reboot:
+ signal-event post-upgrade;signal-event reboot
+The service will show as failed at this point.
+ systemctl status postgresql-12
+So we need to init the DB:
+ /usr/pgsql-12/bin/postgresql-12-setup initdb
+Then start it:
+ systemctl start postgresql-12
+And now we can see it running.
+We can check some of the defaults:
+ grep '^[[:blank:]]*[^[:blank:]#;]' /var/lib/pgsql/12/data/pg_hba.conf
+ grep '^[[:blank:]]*[^[:blank:]#;]' /var/lib/pgsql/12/data/postgresql.conf
