{"id":19667,"date":"2022-10-11T10:44:26","date_gmt":"2022-10-11T08:44:26","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=19667"},"modified":"2022-10-11T10:44:27","modified_gmt":"2022-10-11T08:44:27","slug":"postgresql-from-packages-on-netbsd","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/","title":{"rendered":"PostgreSQL from packages on NetBSD"},"content":{"rendered":"\n

The last flavor of BSD we’ll look at is NetBSD<\/a>. We already had FreeBSD (here<\/a> and here<\/a>) and OpenBSD (here<\/a> and here<\/a>). If you want to learn more about the history of NetBSD and the goals of the project, head over to the about page<\/a> on the official website. We’ll use the same structure as in the other BSD related posts: First we’ll look at how you can get started with PostgreSQL on NetBSD with packages in this post. The next post we’ll be about getting PostgreSQL up and running on NetBSD from source code.<\/p>\n\n\n\n

Again, we’ll not look into how to get NetBSD installed. The text based installation procedure is really simple and you should get it up and running within a few minutes.<\/p>\n\n\n\n

The tool on NetBSD to apply the latest updates is pkgin<\/a>. As this is not installed by default in a minimal installation we need to do that first:<\/p>\n\n\n

\nlocalhost$ PKG_PATH="https:\/\/cdn.NetBSD.org\/pub\/pkgsrc\/packages\/NetBSD\/$(uname -p)\/$(uname -r | cut -d_ -f1)\/All"\nlocalhost$ export PKG_PATH\nlocalhost$ pkg_add pkgin\npkg_add: Warning: package `pkgin-21.12.0nb2' was built for a platform:\npkg_add: NetBSD\/x86_64 9.0 (pkg) vs. NetBSD\/x86_64 9.3 (this host)\npkg_add: Warning: package `pkg_install-20211115' was built for a platform:\npkg_add: NetBSD\/x86_64 9.0 (pkg) vs. NetBSD\/x86_64 9.3 (this host)\npkgin-21.12.0nb2: copying \/usr\/pkg\/share\/examples\/pkgin\/repositories.conf.example to \/usr\/pkg\/etc\/pkgin\/repositories.conf\nlocalhost$ which pkgin\n\/usr\/pkg\/bin\/pkgin\n<\/pre><\/div>\n\n\n
Now we can update the packages to the latest release:<\/p>\n\n\n
\nlocalhost$ pkgin update\nreading local summary...\nprocessing local summary...\nprocessing remote summary (https:\/\/cdn.netbsd.org\/pub\/pkgsrc\/packages\/NetBSD\/x86_64\/9.0\/All)...\npkg_summary.bz2                                                                                                   100% 3839KB 479.9KB\/s   00:08     \nlocalhost$ pkgin upgrade\ncalculating dependencies...done.\nnothing to do.\nlocalhost#\n<\/pre><\/div>\n\n\n
Lets check what we have available when it comes to PostgreSQL:<\/p>\n\n\n
\nnetbsd-latest$ pkgin search postgresql | grep server\ndovecot-pgsql-2.3.19.1  Secure IMAP and POP3 server (PostgreSQL plugin)\nmydns-pgsql-1.1.0nb18  PostgreSQL-based DNS server\npgpool-3.4.1         Connection pooling\/replication server for PostgreSQL\nphp56-davical-1.1.10nb1  Simple CalDAV server using a PostgreSQL backend\nphp74-davical-1.1.10nb1  Simple CalDAV server using a PostgreSQL backend\nphp80-davical-1.1.10nb1  Simple CalDAV server using a PostgreSQL backend\nphp81-davical-1.1.10nb1  Simple CalDAV server using a PostgreSQL backend\npostfix-pgsql-3.6.4  Postfix SMTP server PostgreSQL backend module\npostgresql10-pgpool2-4.3.2  Middleware between PostgreSQL servers and a PostgreSQL database client\npostgresql10-server-10.21  PostgreSQL database server programs\npostgresql11-pgpool2-4.3.2  Middleware between PostgreSQL servers and a PostgreSQL database client\npostgresql11-server-11.16  PostgreSQL database server programs\npostgresql12-pgpool2-4.3.2  Middleware between PostgreSQL servers and a PostgreSQL database client\npostgresql12-server-12.11  PostgreSQL database server programs\npostgresql13-pgpool2-4.3.2  Middleware between PostgreSQL servers and a PostgreSQL database client\npostgresql13-server-13.7  PostgreSQL database server programs\npostgresql14-pgpool2-4.3.2  Middleware between PostgreSQL servers and a PostgreSQL database client\npostgresql14-server-14.4  PostgreSQL database server programs\nzabbix-server-postgresql-5.0.17nb2  Enterprise-class Monitoring Solution for Everyone\n<\/pre><\/div>\n\n\n
Versions 10 to 14, and not only the latest version as in OpenBSD, so more choice in NetBSD. The minor version is also more up to date with 14.4 (one minor release behind as of today).<\/p>\n\n\n\n
Again, and no surprise, the installation from packages is easy:<\/p>\n\n\n
\nnetbsd-latest# pkgin install postgresql14-server-14.4 \ncalculating dependencies...done.\n\n5 packages to install:\n  postgresql14-server-14.4 postgresql14-client-14.4 lz4-1.9.3nb1 libxml2-2.9.14 xmlcatmgr-2.2nb1\n\n0 to refresh, 0 to upgrade, 5 to install\n16M to download, 49M to install\n\nproceed ? [Y\/n] y\nxmlcatmgr-2.2nb1.tgz                                                                                              100%   29KB  29.4KB\/s   00:00    \npostgresql14-client-14.4.tgz                                                                                      100% 5720KB   2.8MB\/s   00:02    \nlz4-1.9.3nb1.tgz                                                                                                  100%  345KB 344.6KB\/s   00:01    \nlibxml2-2.9.14.tgz                                                                                                100% 2305KB   1.1MB\/s   00:02    \npostgresql14-server-14.4.tgz                                                                                      100% 7477KB   2.4MB\/s   00:03    \ninstalling postgresql14-server-14.4...\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.etc.sgml to \/usr\/pkg\/etc\/sgml\/catalog\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.etc.xml to \/usr\/pkg\/etc\/xml\/catalog\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.share.sgml to \/usr\/pkg\/share\/sgml\/catalog\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.share.xml to \/usr\/pkg\/share\/xml\/catalog\npostgresql14-client-14.4: copying \/usr\/pkg\/share\/postgresql\/pg_service.conf.sample to \/usr\/pkg\/etc\/postgresql\/pg_service.conf\npostgresql14-client-14.4: copying \/usr\/pkg\/share\/postgresql\/psqlrc.sample to \/usr\/pkg\/etc\/postgresql\/psqlrc\npostgresql14-server-14.4: Creating group ``pgsql''\npostgresql14-server-14.4: Creating user ``pgsql''\n===========================================================================\nThe following files should be created for postgresql14-server-14.4:\n\n        \/etc\/rc.d\/pgsql (m=0755)\n            [\/usr\/pkg\/share\/examples\/rc.d\/pgsql]\n\n===========================================================================\ninstalling postgresql14-client-14.4...\npostgresql14-client-14.4: copying \/usr\/pkg\/share\/postgresql\/pg_service.conf.sample to \/usr\/pkg\/etc\/postgresql\/pg_service.conf\npostgresql14-client-14.4: copying \/usr\/pkg\/share\/postgresql\/psqlrc.sample to \/usr\/pkg\/etc\/postgresql\/psqlrc\ninstalling lz4-1.9.3nb1...\ninstalling libxml2-2.9.14...\ninstalling xmlcatmgr-2.2nb1...\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.etc.sgml to \/usr\/pkg\/etc\/sgml\/catalog\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.etc.xml to \/usr\/pkg\/etc\/xml\/catalog\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.share.sgml to \/usr\/pkg\/share\/sgml\/catalog\nxmlcatmgr-2.2nb1: copying \/usr\/pkg\/share\/examples\/xmlcatmgr\/catalog.share.xml to \/usr\/pkg\/share\/xml\/catalog\npkg_install warnings: 1, errors: 0\npkg_install error log can be found in \/var\/db\/pkgin\/pkg_install-err.log\nreading local summary...\nprocessing local summary...\nmarking postgresql14-server-14.4 as non auto-removable\n<\/pre><\/div>\n\n\n
A few dependencies have been installed. Lets do what the output is recommending and copy the template to \/etc\/rc.d and enable the service in rc.conf:<\/p>\n\n\n
\nnetbsd-latest$ cp \/usr\/pkg\/share\/examples\/rc.d\/pgsql \/etc\/rc.d\/pgsql\nnetbsd-latest$ cat \/etc\/rc.conf | grep pg\npgsql=YES\n<\/pre><\/div>\n\n\n
Initializing the cluster and starting it up can now be done using the “service” command:<\/p>\n\n\n
\nnetbsd-latest$ service pgsql initdb\nInitializing PostgreSQL databases.\ninitdb: warning: enabling "trust" authentication for local connections\nYou can change this by editing pg_hba.conf or using the option -A, or\n--auth-local and --auth-host, the next time you run initdb.\nnetbsd-latest$ service pgsql start\nStarting pgsql.\n<\/pre><\/div>\n\n\n
That was easy and PostgreSQL is up and running:<\/p>\n\n\n
\nnetbsd-latest$ psql -U pgsql postgres\npsql (14.4)\nType "help" for help.\n\npostgres=# select version();\n                                     version                                     \n---------------------------------------------------------------------------------\n PostgreSQL 14.4 on x86_64--netbsd, compiled by gcc (nb4 20200810) 7.5.0, 64-bit\n(1 row)\n\npostgres=# \n<\/pre><\/div>\n\n\n
As usual, installation from packages is not a big deal. NetBSD comes with a couple of PostgreSQL versions to chose from and seems to be more up to date than OpenBSD.<\/p>\n","protected":false},"excerpt":{"rendered":"
The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and here). If you want to learn more about the history of NetBSD and the goals of the project, head over to the about page on the official website. We’ll use the same structure as […]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[2718,2720,2602],"type_dbi":[],"class_list":["post-19667","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","tag-bsd","tag-netbsd","tag-postgresql-2"],"acf":[],"yoast_head":"\nPostgreSQL from packages on NetBSD - 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\/postgresql-from-packages-on-netbsd\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL from packages on NetBSD\" \/>\n<meta property=\"og:description\" content=\"The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and here). If you want to learn more about the history of NetBSD and the goals of the project, head over to the about page on the official website. We’ll use the same structure as […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-11T08:44:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T08:44:27+00:00\" \/>\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=\"4 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\/postgresql-from-packages-on-netbsd\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"PostgreSQL from packages on NetBSD\",\"datePublished\":\"2022-10-11T08:44:26+00:00\",\"dateModified\":\"2022-10-11T08:44:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/\"},\"wordCount\":310,\"commentCount\":0,\"keywords\":[\"BSD\",\"NetBSD\",\"postgresql\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/\",\"name\":\"PostgreSQL from packages on NetBSD - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-10-11T08:44:26+00:00\",\"dateModified\":\"2022-10-11T08:44:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL from packages on NetBSD\"}]},{\"@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":"PostgreSQL from packages on NetBSD - 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\/postgresql-from-packages-on-netbsd\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL from packages on NetBSD","og_description":"The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and here). If you want to learn more about the history of NetBSD and the goals of the project, head over to the about page on the official website. We’ll use the same structure as […]","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/","og_site_name":"dbi Blog","article_published_time":"2022-10-11T08:44:26+00:00","article_modified_time":"2022-10-11T08:44:27+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"PostgreSQL from packages on NetBSD","datePublished":"2022-10-11T08:44:26+00:00","dateModified":"2022-10-11T08:44:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/"},"wordCount":310,"commentCount":0,"keywords":["BSD","NetBSD","postgresql"],"articleSection":["Database Administration & Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/","name":"PostgreSQL from packages on NetBSD - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-10-11T08:44:26+00:00","dateModified":"2022-10-11T08:44:27+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-netbsd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL from packages on NetBSD"}]},{"@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\/19667","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=19667"}],"version-history":[{"count":10,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19667\/revisions"}],"predecessor-version":[{"id":19727,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19667\/revisions\/19727"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=19667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=19667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=19667"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=19667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}