{"id":4580,"date":"2015-05-18T09:10:16","date_gmt":"2015-05-18T07:10:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/"},"modified":"2015-05-18T09:10:16","modified_gmt":"2015-05-18T07:10:16","slug":"getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/","title":{"rendered":"getting started with postgres plus advanced server (1) – setting up ppas"},"content":{"rendered":"

I did several posts around postgresql and postgres plus advanced server<\/a> in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and recovery, high availability and monitoring. So I thought I’d write a guide on how to do that, consisting of:<\/p>\n

    \n
  1. setting up postgres plus advanced server<\/li>\n
  2. setting up a backup and recovery server<\/li>\n
  3. setting up a hot standby database<\/li>\n
  4. setting up monitoring<\/li>\n<\/ol>\n

    As this is the first post of the series this is about getting ppas<\/a> installed and creating the first database cluster.<\/a>
    \nObviously the first thing to do is to install an operating system. Several of these     are supported<\/a>, just choose the one you like. An example setup can be found here<\/a>. So, once ppas was downloaded<\/a> and transferred to the system where it is supposed to be installed we can start. There are several ways to get ppas installed on the system but before you begin java should be installed. For yum based distributions this is done by:<\/p>\n

    yum install java\n<\/pre>\n
    Using the standalone installer in interactive mode<\/h3>\n
    Starting the installation is just a matter of extracting the file and executing it:<\/p>\n
    [root@oel7 tmp]# ls\nppasmeta-9.4.1.3-linux-x64.tar.gz\n[root@oel7 tmp]# tar -axf ppasmeta-9.4.1.3-linux-x64.tar.gz \n[root@oel7 tmp]# ls\nppasmeta-9.4.1.3-linux-x64  ppasmeta-9.4.1.3-linux-x64.tar.gz\n[root@oel7 tmp]# ppasmeta-9.4.1.3-linux-x64\/ppasmeta-9.4.1.3-linux-x64.run \n<\/pre>\n
    \"alt\" \"alt\"
    \n\"alt\" provide the username and password you used for downloading the product: \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\" \"alt\"done.<\/p>\n
    Using the standalone installer in interactive text mode<\/h3>\n
    If you do not want to use the graphical user interface you can launch the installer in interactive text mode:<\/p>\n
    # ppasmeta-9.4.1.3-linux-x64\/ppasmeta-9.4.1.3-linux-x64.run --mode text\n<\/pre>\n
    Either go with the default options or adjust what you like. The questions should be self explaining:
    \nLanguage Selection<\/p>\n
    Please select the installation language
    \n[1] English – English
    \n[2] Japanese – \u65e5\u672c\u8a9e
    \n[3] Simplified Chinese – \u7b80\u4f53\u4e2d\u6587
    \n[4] Traditional Chinese – \u7e41\u4f53\u4e2d\u6587
    \n[5] Korean – \ud55c\uad6d\uc5b4
    \nPlease choose an option [1] : 1
    \n—————————————————————————-
    \nWelcome to the Postgres Plus Advanced Server Setup Wizard.<\/p>\n
    —————————————————————————-
    \nPlease read the following License Agreement. You must accept the terms of this
    \nagreement before continuing with the installation.<\/p>\n
    Press [Enter] to continue:
    \n…..
    \n…..
    \nPress [Enter] to continue:<\/p>\n
    Do you accept this license? [y\/n]: y<\/p>\n
    —————————————————————————-
    \nUser Authentication<\/p>\n
    This installation requires a registration with EnterpriseDB.com. Please enter
    \nyour credentials below. If you do not have an account, Please create one now on
    \nhttps:\/\/www.enterprisedb.com\/user-login-registration<\/p>\n
    Email []:<\/p>\n
    Password : xxxxx<\/p>\n
    —————————————————————————-
    \nPlease specify the directory where Postgres Plus Advanced Server will be
    \ninstalled.<\/p>\n
    Installation Directory [\/opt\/PostgresPlus]:<\/p>\n
    —————————————————————————-
    \nSelect the components you want to install.<\/p>\n
    Database Server [Y\/n] :y\nConnectors [Y\/n] :y\nInfinite Cache [Y\/n] :y\nMigration Toolkit [Y\/n] :y\nPostgres Enterprise Manager Client [Y\/n] :y\npgpool-II [Y\/n] :y\npgpool-II Extensions [Y\/n] :y\nEDB*Plus [Y\/n] :y\nSlony Replication [Y\/n] :y\nPgBouncer [Y\/n] :y\nIs the selection above correct? [Y\/n]: y<\/pre>\n
     <\/p>\n
    —————————————————————————-
    \nAdditional Directories<\/p>\n
    Please select a directory under which to store your data.<\/p>\n
    Data Directory [\/opt\/PostgresPlus\/9.4AS\/data]:<\/p>\n
    Please select a directory under which to store your Write-Ahead Logs.<\/p>\n
    Write-Ahead Log (WAL) Directory [\/opt\/PostgresPlus\/9.4AS\/data\/pg_xlog]:<\/p>\n
    —————————————————————————-
    \nConfiguration Mode<\/p>\n
    Postgres Plus Advanced Server always installs with Oracle(R) compatibility features and maintains full PostgreSQL compliance. Select your style preference for installation defaults and samples.<\/p>\n
    The Oracle configuration will cause the use of certain objects (e.g. DATE data types, string operations, etc.) to produce Oracle compatible results, create the same Oracle sample tables, and have the database match Oracle examples used in the documentation.<\/p>\n
    Configuration Mode<\/p>\n
    [1] Oracle Compatible
    \n[2] PostgreSQL Compatible
    \nPlease choose an option [1] : 1<\/p>\n
    —————————————————————————-
    \nPlease provide a password for the database superuser (enterprisedb). A locked
    \nUnix user account (enterprisedb) will be created if not present.<\/p>\n
    Password :
    \nRetype Password :
    \n—————————————————————————-
    \nAdditional Configuration<\/p>\n
    Please select the port number the server should listen on.<\/p>\n
    Port [5444]:<\/p>\n
    Select the locale to be used by the new database cluster.<\/p>\n
    Locale<\/p>\n
    [1] [Default locale]
    \n……
    \nPlease choose an option [1] : 1<\/p>\n
    Install sample tables and procedures. [Y\/n]: Y<\/p>\n
    —————————————————————————-
    \nDynatune Dynamic Tuning:
    \nServer Utilization<\/p>\n
    Please select the type of server to determine the amount of system resources
    \nthat may be utilized:<\/p>\n
    [1] Development (e.g. a developer’s laptop)
    \n[2] General Purpose (e.g. a web or application server)
    \n[3] Dedicated (a server running only Postgres Plus)
    \nPlease choose an option [2] : 2<\/p>\n
    —————————————————————————-
    \nDynatune Dynamic Tuning:
    \nWorkload Profile<\/p>\n
    Please select the type of workload this server will be used for:<\/p>\n
    [1] Transaction Processing (OLTP systems)
    \n[2] General Purpose (OLTP and reporting workloads)
    \n[3] Reporting (Complex queries or OLAP workloads)
    \nPlease choose an option [1] : 2<\/p>\n
    —————————————————————————-
    \nAdvanced Configuration<\/p>\n
    —————————————————————————-
    \nPgBouncer Listening Port [6432]:<\/p>\n
    —————————————————————————-
    \nService Configuration<\/p>\n
    Autostart PgBouncer Service [Y\/n]: n\nAutostart pgAgent Service [Y\/n]: n\nUpdate Notification Service [Y\/n]: n<\/pre>\n
     <\/p>\n
    The Update Notification Service informs, downloads and installs whenever
    \nsecurity patches and other updates are available for your Postgres Plus Advanced
    \nServer installation.<\/p>\n
    —————————————————————————-
    \nPre Installation Summary<\/p>\n
    Following settings will be used for installation:<\/p>\n
    Installation Directory: \/opt\/PostgresPlus\n Data Directory: \/opt\/PostgresPlus\/9.4AS\/data\n WAL Directory: \/opt\/PostgresPlus\/9.4AS\/data\/pg_xlog\n Database Port: 5444\n Database Superuser: enterprisedb\n Operating System Account: enterprisedb\n Database Service: ppas-9.4\n PgBouncer Listening Port: 6432\nPress [Enter] to continue:<\/pre>\n
     <\/p>\n
    —————————————————————————-
    \nSetup is now ready to begin installing Postgres Plus Advanced Server on your
    \ncomputer.<\/p>\n
    Do you want to continue? [Y\/n]: Y<\/p>\n
    —————————————————————————-
    \nPlease wait while Setup installs Postgres Plus Advanced Server on your computer.<\/p>\n
    Installing Postgres Plus Advanced Server\n 0% ______________ 50% ______________ 100%\n ########################################\n Installing Database Server ...\n Installing pgAgent ...\n Installing Connectors ...\n Installing Migration Toolkit ...\n Installing EDB*Plus ...\n Installing Infinite Cache ...\n Installing Postgres Enterprise Manager Client ...\n Installing Slony Replication ...\n Installing pgpool-II ...\n Installing pgpool-II Extensions ...\n Installing PgBouncer ...\n Installing StackBuilder Plus ...\n #<\/pre>\n
    —————————————————————————-
    \nSetup has finished installing Postgres Plus Advanced Server on your computer.<\/p>\n
    done.<\/p>\n
    Using the standalone installer in unattended mode<\/h3>\n
    Another option is to use the unattended mode by providing all the parameters on the command line or by creating a configuration file. This is an example for providing the parameters on the command line. Most of the parameters can be skipped and the default is applied:
    \nppasmeta-9.4.1.3-linux-x64\/ppasmeta-9.4.1.3-linux-x64.run –mode unattended
    \n–enable-components dbserver,connectors,infinitecache,edbmtk,pem_client,
    \npgpool,pgpoolextension,edbplus,replication,pgbouncer
    \n–installer-language en –superaccount enterprisedb
    \n–servicename ppas-9.4 –serviceaccount enterprisedb
    \n–prefix \/opt\/PostgresPlus –datadir \/opt\/PostgresPlus\/9.4AS\/data
    \n–xlogdir \/opt\/PostgresPlus\/9.4AS\/data\/pg_xlog
    \n–databasemode oracle –superpassword enterprisedb
    \n–webusername document.write([‘xx.xx’,’xx.xxx’].join(‘@’)) –webpassword xxxxx<\/p>\n
    Installing Database Server ...\n Installing pgAgent ...\n Installing Connectors ...\n Installing Migration Toolkit ...\n Installing EDB*Plus ...\n Installing Infinite Cache ...\n Installing Postgres Enterprise Manager Client ...\n Installing Slony Replication ...\n Installing pgpool-II ...\n Installing pgpool-II Extensions ...\n Installing PgBouncer ...\n Installing StackBuilder Plus ...X11 connection rejected because of wrong authentication.<\/pre>\n
    Done. No matter which installation method was chosen the result is that ppas is installed and the database cluster is initialized. You might check the processes:<\/p>\n
    # ps -ef | grep postgres\n enterpr+ 12759 1 0 12:03 ? 00:00:00 \/opt\/PostgresPlus\/9.4AS\/bin\/edb-postgres -D \/opt\/PostgresPlus\/9.4AS\/data\n enterpr+ 12760 12759 0 12:03 ? 00:00:00 postgres: logger process\n enterpr+ 12762 12759 0 12:03 ? 00:00:00 postgres: checkpointer process\n enterpr+ 12763 12759 0 12:03 ? 00:00:00 postgres: writer process\n enterpr+ 12764 12759 0 12:03 ? 00:00:00 postgres: wal writer process\n enterpr+ 12765 12759 0 12:03 ? 00:00:00 postgres: autovacuum launcher process\n enterpr+ 12766 12759 0 12:03 ? 00:00:00 postgres: stats collector process\n enterpr+ 12882 12759 0 12:03 ? 00:00:00 postgres: enterprisedb edb ::1[45984] idle\n root 13866 2619 0 12:15 pts\/0 00:00:00 grep --color=auto postgres<\/pre>\n
    Or the services that got created:
    \n# chkconfig –list | grep ppas<\/p>\n
    Note: This output shows SysV services only and does not include native
    \nsystemd services. SysV configuration data might be overridden by native
    \nsystemd configuration.<\/p>\n
    If you want to list systemd services use ‘systemctl list-unit-files’.
    \nTo see services enabled on particular target use
    \n‘systemctl list-dependencies [target]’.<\/p>\n
    ppas-9.4 0:off 1:off 2:on 3:on 4:on 5:on 6:off\n ppas-agent-9.4 0:off 1:off 2:on 3:on 4:on 5:on 6:off\n ppas-infinitecache 0:off 1:off 2:off 3:off 4:off 5:off 6:off\n ppas-pgpool 0:off 1:off 2:off 3:off 4:off 5:off 6:off\n ppas-replication-9.4 0:off 1:off 2:off 3:off 4:off 5:off 6:off\n # ls -la \/etc\/init.d\/ppas*\n -rwxr-xr-x. 1 root root 3663 Apr 23 12:03 \/etc\/init.d\/ppas-9.4\n -rwxr-xr-x. 1 root root 2630 Apr 23 12:03 \/etc\/init.d\/ppas-agent-9.4\n -rwxr-xr-x. 1 root root 1924 Apr 23 12:04 \/etc\/init.d\/ppas-infinitecache\n -rwxr-xr-x. 1 root root 3035 Apr 23 12:04 \/etc\/init.d\/ppas-pgpool\n -rwxr-xr-x. 1 root root 3083 Apr 23 12:04 \/etc\/init.d\/ppas-replication-9.4<\/pre>\n
    As the account which installed the software should not be used to work with the database lets create an os account for doing the connections to the database:
    \n# groupadd postgres
    \n# useradd -g postgres postgres
    \n# passwd postgres
    \nChanging password for user postgres.
    \nNew password:
    \nRetype new password:
    \npasswd: all authentication tokens updated successfully.<\/p>\n
    ppas brings an environment file for setting all the environment variables. Lets source that so it will be available for future logins:<\/p>\n
    su - postgres\n echo \". \/opt\/PostgresPlus\/9.4AS\/pgplus_env.sh\" >> .bash_profile\n Once you login to the postgres account the environment is there:\n $ env | grep PG\n PGPORT=5444\n PGDATABASE=edb\n PGLOCALEDIR=\/opt\/PostgresPlus\/9.4AS\/share\/locale\n PGDATA=\/opt\/PostgresPlus\/9.4AS\/data\n $ env | grep EDB\n EDBHOME=\/opt\/PostgresPlus\/9.4AS\n Now we are ready to login to the database:\n $ psql -U enterprisedb\n Password for user enterprisedb:\n psql.bin (9.4.1.3)\n Type \"help\" for help.\n edb=# l<\/pre>\n
    List of databases<\/p>\n
    Name | Owner | Encoding | Collate | Ctype | ICU | Access privileges\n -----------+--------------+----------+-------------+-------------+-----+-------------------------------\n edb | enterprisedb | UTF8 | en_US.UTF-8 | en_US.UTF-8 | |\n postgres | enterprisedb | UTF8 | en_US.UTF-8 | en_US.UTF-8 | |\n template0 | enterprisedb | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | =c\/enterprisedb +\n | | | | | | enterprisedb=CTc\/enterprisedb\n template1 | enterprisedb | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | =c\/enterprisedb +\n | | | | | | enterprisedb=CTc\/enterprisedb\n (4 rows)<\/pre>\n
    Mission completed. The next post will setup a backup and recovery server for backing up and restoring the ppas database cluster.<\/p>\n","protected":false},"excerpt":{"rendered":"
    I did several posts around postgresql and postgres plus advanced server in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and recovery, high availability and monitoring. So I thought I’d write a guide on how to do that, […]<\/p>\n","protected":false},"author":29,"featured_media":4581,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[77],"type_dbi":[],"class_list":["post-4580","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-postgresql"],"acf":[],"yoast_head":"\ngetting started with postgres plus advanced server (1) - setting up ppas - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"getting started with postgres plus advanced server (1) - setting up ppas\" \/>\n<meta property=\"og:description\" content=\"I did several posts around postgresql and postgres plus advanced server in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and recovery, high availability and monitoring. So I thought I’d write a guide on how to do that, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-18T07:10:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"220\" \/>\n\t<meta property=\"og:image:height\" content=\"137\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"getting started with postgres plus advanced server (1) – setting up ppas\",\"datePublished\":\"2015-05-18T07:10:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\"},\"wordCount\":1054,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png\",\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\",\"name\":\"getting started with postgres plus advanced server (1) - setting up ppas - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png\",\"datePublished\":\"2015-05-18T07:10:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png\",\"width\":220,\"height\":137},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"getting started with postgres plus advanced server (1) – setting up ppas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"getting started with postgres plus advanced server (1) - setting up ppas - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/","og_locale":"en_US","og_type":"article","og_title":"getting started with postgres plus advanced server (1) - setting up ppas","og_description":"I did several posts around postgresql and postgres plus advanced server in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and recovery, high availability and monitoring. So I thought I’d write a guide on how to do that, […]","og_url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/","og_site_name":"dbi Blog","article_published_time":"2015-05-18T07:10:16+00:00","og_image":[{"width":220,"height":137,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"getting started with postgres plus advanced server (1) – setting up ppas","datePublished":"2015-05-18T07:10:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/"},"wordCount":1054,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png","keywords":["PostgreSQL"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/","url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/","name":"getting started with postgres plus advanced server (1) - setting up ppas - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png","datePublished":"2015-05-18T07:10:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ppas1.png","width":220,"height":137},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-postgres-plus-advanced-server-1-setting-up-ppas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"getting started with postgres plus advanced server (1) – setting up ppas"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4580"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4580\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4581"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4580"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}