View source for Archive:4 4 3:Installing PostgreSQL/de

<div class="noprint"><languages />

{{Copyright SEP AG|de}}

{{Outdated_de}}</div><br />

==Übersicht==
<div class="boilerplate metadata" id="Additional resources" style="background-color:#ecedf1; color:#8695a7; border: 1px ridge #cdd3db; margin: 0.5em; padding: 0.5em; float: right; width: 35%; "><center><b>
Weitere Quellen</b></center>

{|style="margin: auto; margin-bottom:1em; width:100%; border:0px solid grey;"
| rowspan="2" style="padding:0px 10px 0px;" |[[File:SEP_next.png|45px|link=Special:MyLanguage/4_4_3:SEP_sesam_Quick_Install_Guide]]
| style="padding:0px 40px 0px 10px; color: grey; font-size: 90%; text-align:left;" | Siehe auch:  [[Special:MyLanguage/4_4_3:SEP_sesam_Quick_Install_Guide#linux|SEP sesam Installation - Kurzanleitung]] – [[Special:MyLanguage/Debian_Repository|Debian Repository]]
|}

{|style="margin: auto; margin-bottom:1em; width:100%; border:0px solid grey;"
| rowspan="2" style="padding:0px 10px 0px;" | [[File:SEP Tip.png|45px|link=Special:MyLanguage/FAQ|FAQ]]
| style="padding:0px 40px 0px 10px; color: grey; font-size: 90%; text-align:left;" | Unter [[Special:MyLanguage/FAQ#installation_and_configuration|FAQ]] finden Sie Antworten auf Installations- und Konfigurationsprobleme.
|}

{|style="margin: auto; margin-bottom:1em; width:100%; border:0px solid grey;"
| rowspan="2" style="padding:0px 10px 0px;" | [[File:SEP_Video.png|45px|link=Video Tutorials & Screencasts|]]
| style="padding:0px 40px 0px 10px; color: grey; font-size: 90%; text-align:left;" | SEP sesam [[Special:MyLanguage/Video Tutorials & Screencasts#installation|Videos und Aufzeichnungen]] anschauen.
|}

{|style="margin: auto; margin-bottom:1em; width:100%; border:0px solid grey;"
| rowspan="2" style="padding:0px 10px 0px;" | [[File:SEP Troubleshooting.png|45px|link=Special:MyLanguage/Troubleshooting_Guide|Troubleshooting Guide]]
| style="padding:0px 40px 0px 10px; color: grey; font-size: 90%; text-align:left;" | Im Problemfall nutzen Sie den  [[Special:MyLanguage/Troubleshooting_Guide|Troubleshooting Guide]].
|}</div>
Die PostgreSQL Datenbank wird für 64-Bit SEP sesam Installationen benötigt. Beachten Sie, dass die SEP sesam RPM-Pakete bereits das PostgreSQL Serverpaket enthalten, aber für einige ältere SEP sesam Versionen müssen Sie das PostgreSQL möglicherweise manuell installieren, wie unten beschrieben. 

Die Datenbank kann auf verschiedenen Linux-basierten Distributionen installiert werden:
* SLES
* Debian/Ubuntu/UCS
* RHEL/CentOS

Ausführliche Informationen zur Konfiguration von PostgreSQL-Sicherungen oder -Rücksicherungen finden Sie unter [[Special:MyLanguage/4_4_3:PostgreSQL_Backup|PostgreSQL Sicherung]] und [[Special:MyLanguage/4_4_3:PostgreSQL_Restore|PostgreSQL Rücksicherung]].

== {{anchor|SLES}}SLES-basierte Distributionen ==

Die PostgreSQL-Datenbank kann mit Hilfe von ''YaST'' oder anderen gängigen Kommandozeilen-Tools (''rug'' oder ''zypper'') installiert werden. Ausführliche Informationen zu den unterstützten SLES-Versionen finden Sie unter [[Special:MyLanguage/SEP_sesam_OS_and_Database_Support_Matrix#Linux|SEP sesam OS und Datenbank Support Matrix]].  

=== {{anchor|zypper}}''Installation mit zypper'' ===

SLES includes the standard tool ''zypper'' which is common for package management. With this tool packages can be installed (and uninstalled) in the command line. The package name for the PostgreSQL database is <tt>postgresq1-server</tt>. The SEP sesam Server package includes all dependencies that are needed for standard SEP sesam Server installation.

Um die PostgreSQL-Datenbank zu installieren, verwenden Sie den folgenden Befehl: 
 kiwi:~ # zypper install postgresql-server

Die Installation wird wie folgt ausgeführt:

 kiwi:~ # '''zypper install postgresql-server'''
 Loading files of the repository...
 Reading installed packages...
 Resolving package dependencies...
 
 The following new packages have been installed:
   postgresql postgresql-libs postgresql-server 
 
 Total size of the download: 4,1 M. After the operation an additional 7,1 M will be needed.
 Continue? [YES/no]: YES
 Package postgresql-libs-8.3.7-0.1.1.i586 is being called (1/3), 175,0 K (560,0 K installed)
 Calling: postgresql-libs-8.3.7-0.1.1.i586.rpm [done]
 Installing: postgresql-libs-8.3.7-0.1.1 [done]
 Package postgresql-8.3.7-0.1.1.i586 is being called (2/3), 1023,0 K (4,2 M installed)
 Calling: postgresql-8.3.7-0.1.1.i586.rpm [done]
 Installing: postgresql-8.3.7-0.1.1 [done]
 Package postgresql-server-8.3.7-0.1.1.i586 is being called (3/3), 3,0 M (12,4 M installed)
 Calling: postgresql-server-8.3.7-0.1.1.i586.rpm [fertig (1,1 M/s)]
 Installing: postgresql-server-8.3.7-0.1.1 [done]

Danach kann die PostgreSQL-Instanz einmalig gestartet werden:

 kiwi:~ # /etc/init.d/postgresql start
 Initializing the PostgreSQL database at location /var/lib/pgsql/data    done 
 Starting PostgreSQL                                                     done     

SLES 12+ starten mit:
 service postgresql start
or
 systemctl enable postgresql  

PostgreSQL-Instanz automatisch starten:
 systemctl enable postgresql                                              

=== {{anchor|YaST}}''Installation mit YaST'' ===

Sie können die Installation auch über die GUI durchführen. Die Suche und Auswahl des Pakets erfolgt über die Paketsuche ''YaST''. Beachten Sie, dass das YaST-Modul standardmäßig nicht verfügbar ist; das Paket ''yast2-packager-webpin'' muss zuerst installiert werden.

== {{anchor|debian}}Debian-basierte Distributionen ==

For Debian-based distributions (Debian/Ubuntu/UCS) SEP provides signed Debian repositories for easier package installation, verification and update of the SEP sesam software. For details on Debian packages, see [[Special:MyLanguage/Debian_Repository|Debian Repository]].

=== {{anchor|apt-get}}''Installation mit apt-get'' ===

Debian-based distribution (Debian/Ubuntu/UCS) includes the standard tool ''apt-get'' which is common for package management. With this tool packages can be installed (and uninstalled) in the command line.

The SEP sesam Server package includes all dependencies that are needed for standard SEP sesam Server installation. For details on the supported Debian-based versions, see [[Special:MyLanguage/SEP_sesam_OS_and_Database_Support_Matrix#Linux|SEP sesam OS and Database Support Matrix]]. 

Um die PostgreSQL-Datenbank zu installieren, verwenden Sie den folgenden Befehl:
 root@hostname#: apt-get install postgresql

Die Installation wird wie folgt ausgeführt:
 root@hostname#: '''apt-get install postgresql'''
 Pckagelists are being read... Done
 Dependency tree is being created       
 Reading status information... Done
 The following packages have been installed automatically and aren't needed any longer:
   libnm-util0 libpcsclite1 dhcdbd libpkcs11-helper1 libiw29 wpasupplicant libnl1 openvpn-blacklist
 Use »apt-get autoremove« to remove them.
 The following additional packages are being installed:
   postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common
 Recommended packages:
   oidentd ident-server postgresql-doc-8.3
 The following NEW packages are being installed:
   postgresql postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common
 0 updated, 5 new installed, 0 to be removed and 53 not updated.
 7257kB of archives have to be downloaded.
 After this operation 19.6 MB of storage space are needed additionally.
 Do you want to continue [Y/n]? Y
 Getting:1 http://ftp.de.debian.org lenny/main postgresql-client-common 94lenny1 [46,8kB]
 Getting:2 http://ftp.de.debian.org lenny/main postgresql-client-8.3 8.3.7-0lenny1 [1651kB]
 Getting:3 http://ftp.de.debian.org lenny/main postgresql-common 94lenny1 [116kB]
 Getting:4 http://ftp.de.debian.org lenny/main postgresql-8.3 8.3.7-0lenny1 [5208kB]
 Getting:5 http://ftp.de.debian.org lenny/main postgresql 8.3.7-0lenny1 [235kB]
 7257kB were downloaded in 4s (1686kB/s)
 Vorkonfiguration der Pakete ...
 Selecting previously deselected package postgresql-client-common.
 (Reading database ... 96396 Files and directories are currently installed.)
 Unpacking postgresql-client-common (from .../postgresql-client-common_94lenny1_all.deb) ...
 Selecting previously deselected package postgresql-client-8.3.
 Unpacking postgresql-client-8.3 (from .../postgresql-client-8.3_8.3.7-0lenny1_i386.deb) ...
 Selecting previously deselected package postgresql-common.
 Unpacking postgresql-common (from .../postgresql-common_94lenny1_all.deb) ...
 Selecting previously deselected package postgresql-8.3.
 Unpacking postgresql-8.3 (from .../postgresql-8.3_8.3.7-0lenny1_i386.deb) ...
 Selecting previously deselected package postgresql.
 Unpacking postgresql (from .../postgresql_8.3.7-0lenny1_all.deb) ...
 Converting trigger for man-db ...
 Setting up postgresql-client-common (94lenny1) ...
 Setting up postgresql-client-8.3 (8.3.7-0lenny1) ...
 Setting up postgresql-common (94lenny1) ...
 supported_versions: WARNING: Unknown Debian release: 5.0.2
 Adding user postgres to group ssl-cert
 Setting up postgresql-8.3 (8.3.7-0lenny1) ...
 Creating new cluster (configuration: /etc/postgresql/8.3/main, data: /var/lib/postgresql/8.3/main)...
 Moving configuration file /var/lib/postgresql/8.3/main/postgresql.conf to /etc/postgresql/8.3/main...
 Moving configuration file /var/lib/postgresql/8.3/main/pg_hba.conf to /etc/postgresql/8.3/main...
 Moving configuration file /var/lib/postgresql/8.3/main/pg_ident.conf to /etc/postgresql/8.3/main...
 Configuring postgresql.conf to use port 5432...
 Starting PostgreSQL 8.3 database server: main.
 Setting up postgresql 8.3.7-0lenny1) ...
 root@hostname#:

{{Anmerkung|Die Installation von SEP sesam unter Debian und Ubuntu erfordert zusätzliche Schritte. Weitere Informationen finden Sie unter [[Special:MyLanguage/Debian_Repository|Debian Repository]].}}

== {{anchor|RHEL}}RHEL/CentOS-basierte Distributionen ==

=== {{anchor|yum}}''Installation über den yum Paketmanager'' ===

Installing in RHEL- or CentOS-based distributions is similar as in SLES or Debian. All RHEL- and CentOS-based distributions include the standard tool ''yum'' which is common for package management. With this tool packages can be installed (and uninstalled) in the command line.

The SEP sesam Server package includes all dependencies that are needed for standard SEP sesam Server installation. For details on the supported RHEL/CentOS-based versions, see [[Special:MyLanguage/SEP_sesam_OS_and_Database_Support_Matrix#Linux|SEP sesam OS and Database Support Matrix]].

Um die PostgreSQL-Datenbank zu installieren, verwenden Sie den folgenden Befehl:
 # yum install postgresql-server

Die Installation wird wie folgt ausgeführt:
 [root@rhel5fix ~]# '''yum install postgresql-server'''
 Loading "downloadonly" plugin
 Loading "rhnplugin" plugin
 Loading "installonlyn" plugin
 Setting up Install Process
 Setting up repositories
 rhel-i386-server-5        100% |=========================| 1.3 kB    00:00     
 Reading repository metadata in from local files
 primary.xml.gz            100% |=========================| 2.3 MB    00:02     
 ################################################## 6101/6101
 Parsing package install arguments
 Resolving Dependencies
 --> Populating transaction set with selected packages. Please wait.
 ---> Downloading header for postgresql-server to pack into transaction set.
 postgresql-server-8.1.11- 100% |=========================|  29 kB    00:00     
 ---> Package postgresql-server.i386 0:8.1.11-1.el5_1.1 set to be updated
 --> Running transaction check
 --> Processing Dependency: postgresql = 8.1.11-1.el5_1.1 for package: postgresql-server
 --> Restarting Dependency Resolution with new changes.
 --> Populating transaction set with selected packages. Please wait.
 ---> Downloading header for postgresql to pack into transaction set.
 postgresql-8.1.11-1.el5_1 100% |=========================| 121 kB    00:00     
 ---> Package postgresql.i386 0:8.1.11-1.el5_1.1 set to be updated
 --> Running transaction check
 
 Dependencies Resolved
 
 =============================================================================
  Package                 Arch       Version          Repository        Size 
 =============================================================================
 Installing:
  postgresql-server       i386       8.1.11-1.el5_1.1  rhel-i386-server-5  3.9 M
 Installing for dependencies:
  postgresql              i386       8.1.11-1.el5_1.1  rhel-i386-server-5  2.9 M
 
 Transaction Summary
 =============================================================================
 Install      2 Package(s)         
 Update       0 Package(s)         
 Remove       0 Package(s)         
 
 Total download size: 6.7 M
 Is this ok [y/N]: y
 Downloading Packages:
 (1/2): postgresql-server- 100% |=========================| 3.9 MB    00:04     
 (2/2): postgresql-8.1.11- 100% |=========================| 2.9 MB    00:03     
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
   Installing: postgresql                   ######################### [1/2] 
   Installing: postgresql-server            ######################### [2/2] 
 Installed: postgresql-server.i386 0:8.1.11-1.el5_1.1
 Dependency Installed: postgresql.i386 0:8.1.11-1.el5_1.1
 Complete!

Sobald das PostgreSQL installiert ist, kannst du das SEP sesam Paket installieren. Weitere Informationen finden Sie unter [[Special:MyLanguage/4_4_3:SEP_sesam_Quick_Install_Guide#linux|SEP sesam Installation Kurzanleitung für Linux]].

<div class="noprint">
== Siehe auch == 
[[Special:MyLanguage/4_4_3:SEP_sesam_Quick_Install_Guide#linux|SEP sesam Installation - Kurzanleitung]] – [[Special:MyLanguage/Debian_Repository|Debian Repository]]</div>