Installing and Configuring Language Pack v11
This section walks you through installing and configuring Language Pack.
Installing Language Pack
The graphical installer is available from the EDB website, as well as via Stack Builder and StackBuilder Plus. StackBuilder Plus is distributed with EDB Postgres Advanced Server and Stack Builder is distributed with PostgreSQL.
Invoking the Graphical Installer
Assume Administrator privileges, and double-click the installer icon; if prompted, provide the password associated with the Administrator account. When prompted, select an installation language, and click OK.
The Language Pack setup wizard welcome window opens.
Click Next to continue.
The Ready to Install window displays the Language Pack installation directory:
On Windows 64: C:/edb/languagepack-11\x64
On OSX: /Library/edb/languagepack-11
You cannot modify the installation directory. Click Next to continue.
A progress bar marks installation progress.
Click Next to continue.
The installer will inform you that the Language Pack installation has completed; click Finish to exit the installer.
Installing Language Pack with Stack Builder
You can use Stack Builder or StackBuilder Plus to download and invoke the Language Pack graphical installer. StackBuilder Plus is distributed with EDB Postgres Advanced Server and Stack Builder is distributed with PostgreSQL.
The following section walks you through installing Language Pack with Stack Builder.
The Stack Builder utility provides a graphical interface that simplifies the process of downloading and installing modules that complement your PostgreSQL installation.
Stack Builder requires Internet access; if your installation of PostgreSQL resides behind a firewall (with restricted Internet access), Stack Builder can download program installers through a proxy server. The module provider deter-mines if the module can be accessed through an HTTP proxy or an FTP proxy; currently, all updates are transferred via an HTTP proxy and the FTP proxy information is not used.
You can invoke Stack Builder at any time after the installation has completed by selecting the Application Stack Builder menu option from the PostgreSQL 11 menu.
Select your server from the drop-down menu on the Stack Builder Welcome window and click Next to continue.
Expand the Add-ons, tools and utilities node of the Categories tree control, and check the box next to EDB Language Pack version. Click Next to continue.
Stack Builder will confirm your package selection before downloading the installer. Click Next to continue.
When the download completes, Stack Builder will offer to invoke the installer for you, or will delay the installation until a more convenient time. To invoke the installer, click Next and follow the steps provided in the Invoking the Graphical Installer section.
Configuring Language Pack
This section walks you through configuring Language Pack on an Advanced Server and PostgreSQL hosts.
Configuring Language Pack on an Advanced Server Host
After installing Language Pack on an Advanced Server host, you must configure the installation.
Configuring Language Pack on Windows
On Windows, the Language Pack installer places the languages in:
C:\edb\languagepack-11\x64
After installing Language Pack, you must set the following variables:
set PYTHONHOME=C:\edb\languagepack-11\x64\Python-3.6
Use the following commands to add Python, Perl and Tcl to your search path:
set PATH=C:\edb\languagepack-11\x64\Python-3.6; C:\edb\languagepack-11\x64\Perl-5.26\bin; C:\edb\languagepack-11\x64\Tcl-8.6\bin;%PATH%
After performing the steps required to configure Language Pack on Windows, use the Windows Services applet to restart the Advanced Server.
Configuring Language Pack on a PostgreSQL Host
After installing Language Pack on a PostgreSQL host, you must configure the installation.
Configuring Language Pack on Windows
After installing Language Pack, you must set the following variables:
set PYTHONHOME=C:\edb\languagepack\v1\Python-3.7
Then, use the following commands to add Language Pack to your search path:
set PATH=C:\edb\languagepack-11\x64\Python-3.6; C:\edb\languagepack\-11\x64\Perl-5.26\bin; C:\edb\languagepack\-11\x64\Tcl-8.6\bin;%PATH%
After setting the system-specific steps required to configure Language Pack on Windows, restart the database server.
Configuring Language Pack on OSX
To simplify setting the value of PATH or LD_LIBRARY_PATH, you can create environment variables that identify the installation location:
PERLHOME=/Library/edb/languagepack-11/Perl-5.26 PYTHONHOME=/Library/edb/languagepack-11/Python-3.6 TCLHOME=/Library/edb/languagepack-11/Tcl-8.6
Then, execute the following command to instruct the Python interpreter where to find Python:
export PYTHONHOME
You can use the same environment variables when setting the value of PATH:
export PATH=$PYTHONHOME/bin: $PERLHOME/bin: $TCLHOME/bin:$PATH
Lastly, set the following variables to instruct OSX where to find the shared libraries:
export DYLD_LIBRARY_PATH=$PYTHONHOME/lib: $PERLHOME/lib/CORE:$TCLHOME/lib: $DYLD_LIBRARY_PATH