859
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − {{Warning box|For Koozali SME Server 10.x there is no contrib yet. We have detailed a basic install in the last [[Postgres#Koozali_SME_v10_and_systemd|section]] on this page and previous versions or methods should be ignored. We may build an updated Contrib in due course}}+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + − {{Note box|For SME Server 9.x, 64-bit, we advise you to use [[Software_Collections:PostgreSQL]]}} + + − Line 139:
Line 167: + + − + − + Line 151:
Line 181: − + + Line 188:
Line 219: − − There is an old v8 contrib that could possibly be updated to install this. − − smeserver-postgresql −
no edit summary
There is now a smeserver-postgresql contrib in the contribs repo.
It requires postgresql 13 from the postgresql repo.
==Version==
{{#smeversion:smeserver-postgresql}}
<br>
<br>
<br>
<br>
==How to install Postgresql 13==
db yum_repositories set postgresql13 repository \
BaseURL https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-7Server-\$basearch/ \
EnableGroups no \
GPGCheck yes \
Name "Postgresql-13" \
GPGKey https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-13 \
Visible no \
status disabled
Update yum
signal-event yum-modify
Install
yum --enablerepo=smecontribs,postgresql13 install smeserver-postgresql
signal-event post-upgrade;signal-event reboot
== How to install Postgres 8 ==
== How to install Postgres 8 ==
{{Warning box| '''Tis information is now outdated/deprecated as we now use systemd on Koozali SME Server v10'''}}
{{Note box|This howto is created with information extracted from forums. Proceed at your own risk.}}
{{Note box|This howto is created with information extracted from forums. Proceed at your own risk.}}
{{Warning box|The command below will install '''postgres''' and update '''postgres-libs'''. For dependency resolution it will also install '''tcl''' and '''mx''' from the '''base''' repository.
{{Warning box|The command below will install '''postgres''' and update '''postgres-libs'''. For dependency resolution it will also install '''tcl''' and '''mx''' from the '''base''' repository.
==Koozali SME v10 and systemd==
==Koozali SME v10 and systemd==
{{Note box| There is now a contrib for Koozali SMEServer v10}}
db yum_repositories set postgresql12 repository \
db yum_repositories set postgresql12 repository \
BaseURL https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7Server-\$basearch/ \
BaseURL https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-7Server-\$basearch/ \
EnableGroups no \
EnableGroups no \
GPGCheck yes \
GPGCheck yes \
Name "MongoDB" \
Name "Postgresql-12" \
GPGKey https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-12 \
GPGKey https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-12 \
Visible no \
Visible no \
Update yum
Update yum
signal-event yum-modify
signal-event yum-modify
Install the rpms
Install the rpms
yum --enablerepo=postgresql12 install postgresql12-server postgresql12-contrib
yum --enablerepo=postgresql12 install postgresql12-server postgresql12-contrib
grep '^[[:blank:]]*[^[:blank:]#;]' /var/lib/pgsql/12/data/pg_hba.conf
grep '^[[:blank:]]*[^[:blank:]#;]' /var/lib/pgsql/12/data/pg_hba.conf
grep '^[[:blank:]]*[^[:blank:]#;]' /var/lib/pgsql/12/data/postgresql.conf
grep '^[[:blank:]]*[^[:blank:]#;]' /var/lib/pgsql/12/data/postgresql.conf
----
----
[[Category:Howto]]
[[Category:Howto]]
[[Category:Administration]]
[[Category:Administration]]