Postgres_Plus_Advanced_Server_Installation_Guide_v9.5.pdf

(4406 KB) Pobierz

Postgres Plus

Advanced Server

Installation Guide

Postgres Plus Advanced Server 9.5

February 22, 2016

Postgres Plus Advanced Server Installation Guide, Version 5.0

by EnterpriseDB Corporation

EnterpriseDB Corporation, 34 Crosby Drive Suite 100, Bedford, MA 01730, USA

+1 781 357 3390

+1 978 589 5701

info@enterprisedb.com

www.enterprisedb.com

Postgres Plus Advanced Server Installation Guide

Table of Contents

Introduction ................................................................................................................. 6

1.1

2.1

2.2

2.3

3.1

3.1.1

3.1.2

3.2

3.2.1

3.2.2

3.3

4.1

4.2

4.3

4.3.1

4.3.2

4.4

4.4.1

4.4.2

4.4.3

4.4.4

4.5

4.6

4.7

5.1

5.2

5.2.1

Typographical Conventions Used in this Guide ................................................. 7

Supported Platforms............................................................................................ 8

Supported Locales ............................................................................................... 9

RPM Installation Pre-Requisites ....................................................................... 10

-Installing an RPM Package.............................................................................. 12

Performing a Minor Version Update of an RPM Installation ....................... 15

Installing Advanced Server on an Isolated Network .................................... 16

Configuring a Package Installation ................................................................... 19

Specifying initdb Options in the Service Configuration File........................ 20

Creating a Database Cluster and Starting the Service .................................. 21

Advanced Server RPM Installers ...................................................................... 22

Graphical Installation Prerequisites .................................................................. 27

Locales Requiring Product Keys ...................................................................... 29

Performing a Graphical Installation .................................................................. 31

Using the Graphical Installer with Windows ................................................ 32

Using the Graphical Installer on a Linux System ......................................... 51

Invoking the Installer from the Command Line ............................................... 73

Performing a Text Mode Installation ............................................................ 74

Performing an Unattended Installation ......................................................... 88

Performing an Installation with Limited Privileges ...................................... 91

Reference

–

Command Line Options .......................................................... 106

Using StackBuilder Plus ................................................................................. 115

Using the Update Monitor .............................................................................. 123

Installation Troubleshooting ........................................................................... 126

Starting and Stopping Advanced Server and Supporting Components .......... 128

Controlling a Service on Linux ....................................................................... 129

Controlling a Service on CentOS or RHEL 7.x .......................................... 129

Requirements Overview.............................................................................................. 8

Using a Package Manager to Install Advanced Server ............................................. 11

Installing Advanced Server with the Interactive Installer......................................... 26

Managing an Advanced Server Installation ............................................................ 128

Postgres Plus Advanced Server Installation Guide

5.2.2

5.2.3

5.2.4

5.2.5

5.3

5.3.1

5.4

6.1

6.2

6.3

6.4

6.4.1

7.1

7.2

7.3

7.4

7.5

7.6

7.7

7.8

7.9

7.9.1

7.9.2

7.9.3

7.10

7.11

7.12

7.13

7.14

7.15

7.16

Controlling a Service on CentOS or RHEL 6.x .......................................... 130

Using pg_ctl to Control Advanced Server .................................................. 132

Using the edbstart and edbstop Utilities ..................................................... 133

Configuring Component Services to AutoStart at System Reboot ............. 136

Controlling a Service on Windows ................................................................. 137

Controlling Server Startup Behavior on Windows ..................................... 138

Using initdb to Create a Cluster ...................................................................... 140

Modifying the postgresql.conf File ................................................................. 143

Modifying the pg_hba.conf File ..................................................................... 147

Setting Advanced Server Environment Variables .......................................... 148

Connecting to Advanced Server ..................................................................... 150

Connecting to an Oracle or MySQL Database ........................................... 151

EDB*Plus - Configuring an RPM Installation ............................................... 152

Infinite Cache .................................................................................................. 154

Language Pack ................................................................................................ 156

Migration Toolkit - Configuring an RPM Installation .................................... 159

pgAgent ........................................................................................................... 161

PgBouncer ....................................................................................................... 165

pgpool-II ......................................................................................................... 169

pgsnmpd .......................................................................................................... 179

PL/Java............................................................................................................ 182

Installing PL/Java on Linux ........................................................................ 182

Installing PL/Java on Windows .................................................................. 185

Using PL/Java ............................................................................................. 188

PL/Perl ............................................................................................................ 190

PL/Python ....................................................................................................... 191

PL/Tcl ............................................................................................................. 193

PostGIS ........................................................................................................... 194

Slony ............................................................................................................... 201

SQL Profiler .................................................................................................... 202

sslutils ............................................................................................................. 205

Configuring Advanced Server ................................................................................ 142

Advanced Server Supporting Components ............................................................. 152

7.13.1 Upgrading to PostGIS 2.0 ........................................................................... 196

Postgres Plus Advanced Server Installation Guide

Upgrading an Installation With pg_upgrade ........................................................... 207

8.1

8.1.1

8.2

8.2.1

8.3

8.4

8.4.1

8.4.2

8.4.3

8.4.4

8.5

Performing an Upgrade - Overview ................................................................ 208

Linking versus Copying .............................................................................. 209

Invoking pg_upgrade ...................................................................................... 210

Command Line Options - Reference .......................................................... 212

Upgrading to Advanced Server 9.5 ................................................................. 215

pg_upgrade Troubleshooting .......................................................................... 223

Upgrade Error - There seems to be a postmaster servicing the cluster ....... 223

Upgrade Error - fe_sendauth: no password supplied .................................. 223

Upgrade Error - New cluster is not empty; exiting ..................................... 223

Upgrade Error - Failed to load library ........................................................ 223

Reverting to the Old Cluster ........................................................................... 225

Uninstalling a Package with rpm .................................................................... 227

Uninstalling a Package with yum ................................................................... 228

Un-Installing Advanced Server at the Command Line ................................... 229

Un-installing Advanced Server on a Windows System .................................. 231

Un-Installing Advanced Server............................................................................... 226

9.1

9.2

9.3

9.4

Plik z chomika:

musli_com

Inne pliki z tego folderu:

Beginning Databases With PostreSQL - From Novice To Professional, 2nd Ed 2005.pdf (18792 KB)
confoo_pgsql.pdf (4980 KB)
PostgreSQL - The Comprehensive Guide, 2nd ed 2005.chm (6799 KB)
Postgres_Plus_Advanced_Server_Installation_Guide_v9.5.pdf (4406 KB)
PostgreSQL - Introduction And Concepts 2001.pdf (2617 KB)

Postgres_Plus_Advanced_Server_Installation_Guide_v9.5.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: