Changes

From SME Server
Jump to navigationJump to search

Postgresql (view source)

Revision as of 16:40, 3 March 2022

426 bytes added ,  16:40, 3 March 2022
no edit summary
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}}
+
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
   −
{{Note box|For SME Server 9.x, 64-bit, we advise you to use [[Software_Collections:PostgreSQL]]}}
      
== 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.  
Line 139: Line 167:     
==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 \
Line 151: Line 181:  
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
Line 188: Line 219:  
  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
−
  −
There is an old v8 contrib that could possibly be updated to install this.
  −
  −
smeserver-postgresql
  −
      
----
 
----
 
[[Category:Howto]]
 
[[Category:Howto]]
 
[[Category:Administration]]
 
[[Category:Administration]]
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/40871"

Navigation menu