{"id":19621,"date":"2022-10-10T08:25:25","date_gmt":"2022-10-10T06:25:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=19621"},"modified":"2022-11-18T17:42:17","modified_gmt":"2022-11-18T16:42:17","slug":"postgresql-from-source-on-openbsd","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/","title":{"rendered":"PostgreSQL from source on OpenBSD"},"content":{"rendered":"\n

In the last post<\/a> we’ve seen that it is quite easy to get started with PostgreSQL on OpenBSD when you install from the provided packages. The downside of this was, that not the latest version of PostgreSQL was provided, 14.2 instead of 14.5, which is the current version as of today. If you want to stay more up to date, and you really should, then you can always install PostgreSQL from source code for your own.<\/p>\n\n\n\n

We’ll start again from a fresh installation but this time, the latest patches are already applied. As we need a group and a user to run PostgreSQL let’s create those:<\/p>\n\n\n

\nopenbsd-latest$ groupadd -g 1000 postgres\nopenbsd-latest$ useradd -g postgres -d \/home\/postgres\/ -m -u 1000 postgres\n<\/pre><\/div>\n\n\n
As there is no sudo<\/a> in OpenBSD we need to configure doas<\/a>, that makes life a bit easier because we do not need to switch accounts for root related tasks:<\/p>\n\n\n
\nopenbsd-latest$ cat \/etc\/doas.conf                                                                                                                 \npermit postgres as root\npermit nopass keepenv postgres\n<\/pre><\/div>\n\n\n
Once we have that we need to download and extract the PostgreSQL source code. I’ll use wget<\/a> for that:<\/p>\n\n\n
\nopenbsd-latest$ su - postgres\nopenbsd-latest$ doas pkg_add wget                                                                                                                  \nquirks-5.5 signed on 2022-10-08T12:25:54Z\nwget-1.21.3: ok\nopenbsd-latest$ wget https:\/\/ftp.postgresql.org\/pub\/source\/v15rc2\/postgresql-15rc2.tar.bz2\nopenbsd-latest$ bunzip2 postgresql-15rc2.tar.bz2                                                                                                   \nopenbsd-latest$ tar xf postgresql-15rc2.tar                                                                                                        \nopenbsd-latest$ cd postgresql-15rc2  \n<\/pre><\/div>\n\n\n
Our Linux, the default configuration we use for the PostgreSQL source code looks like this:<\/p>\n\n\n
\n.\/configure --prefix=${PGHOME} \\\n            --exec-prefix=${PGHOME} \\\n            --bindir=${PGHOME}\/bin \\\n            --libdir=${PGHOME}\/lib \\\n            --sysconfdir=${PGHOME}\/etc \\\n            --includedir=${PGHOME}\/include \\\n            --datarootdir=${PGHOME}\/share \\\n            --datadir=${PGHOME}\/share \\\n            --with-pgport=5432 \\\n            --with-perl \\\n            --with-python \\\n            --with-openssl \\\n            --with-pam \\\n            --with-ldap \\\n            --with-libxml \\\n            --with-libxslt \\\n            --with-segsize=${SEGSIZE} \\\n            --with-blocksize=${BLOCKSIZE} \\\n            --with-llvm LLVM_CONFIG='\/usr\/bin\/llvm-config' \\\n            --with-uuid=ossp \\\n            --with-lz4 \\\n            --with-zstd \\\n            --with-gssapi \\\n            --with-systemd \\\n            --with-icu \\\n            --with-system-tzdata=\/usr\/share\/zoneinfo\n\n<\/pre><\/div>\n\n\n
What OS packages do we need to get a comparable build on OpenBSD? First of all, there is no PAM authentication on OpenBSD, so we can replace that with “–with-bsd-auth” and there is no systemd<\/a>, no gssapi<\/a>, this will give us this:<\/p>\n\n\n
\n.\/configure --prefix=${PGHOME} \\\n            --exec-prefix=${PGHOME} \\\n            --bindir=${PGHOME}\/bin \\\n            --libdir=${PGHOME}\/lib \\\n            --sysconfdir=${PGHOME}\/etc \\\n            --includedir=${PGHOME}\/include \\\n            --datarootdir=${PGHOME}\/share \\\n            --datadir=${PGHOME}\/share \\\n            --with-pgport=5432 \\\n            --with-perl \\\n            --with-python \\\n            --with-openssl \\\n            --with-bsd-auth \\\n            --with-ldap \\\n            --with-libxml \\\n            --with-libxslt \\\n            --with-segsize=${SEGSIZE} \\\n            --with-blocksize=${BLOCKSIZE} \\\n            --with-llvm LLVM_CONFIG='\/usr\/bin\/llvm-config' \\\n            --with-uuid=ossp \\\n            --with-lz4 \\\n            --with-zstd \\\n            --with-icu \\\n            --with-system-tzdata=\/usr\/share\/zoneinfo\n<\/pre><\/div>\n\n\n
Getting this to configure properly, we need these packages:<\/p>\n\n\n
\nopenbsd-latest$ doas pkg_add icu4c lz4 zstd python3 libxml libxslt openldap-client p5-ossp-UUID\n<\/pre><\/div>\n\n\n
Having that installed, configuration goes fine:<\/p>\n\n\n
\nopenbsd-latest$ PGHOME=\/u01\/app\/postgres\/product\/15\/db_0\/ \nopenbsd-latest$ SEGSIZE=2\nopenbsd-latest$ BLOCKSIZE=8\n.\/configure --prefix=${PGHOME} \\\n            --exec-prefix=${PGHOME} \\\n            --bindir=${PGHOME}\/bin \\\n            --libdir=${PGHOME}\/lib \\\n            --sysconfdir=${PGHOME}\/etc \\\n            --includedir=${PGHOME}\/include \\\n            --datarootdir=${PGHOME}\/share \\\n            --datadir=${PGHOME}\/share \\\n            --with-pgport=5432 \\\n            --with-perl \\\n            --with-python \\\n            --with-openssl \\\n            --with-bsd-auth \\\n            --with-ldap \\\n            --with-libxml \\\n            --with-libxslt \\\n            --with-segsize=${SEGSIZE} \\\n            --with-blocksize=${BLOCKSIZE} \\\n            --with-llvm LLVM_CONFIG='\/usr\/bin\/llvm-config' \\\n            --with-uuid=ossp \\\n            --with-lz4 \\\n            --with-zstd \\\n            --with-icu \\\n            --with-system-tzdata=\/usr\/share\/zoneinfo\n<\/pre><\/div>\n\n\n
I’ll not paste the whole output of this, but the end of the output should look like this:<\/p>\n\n\n
\nchecking build system type... x86_64-unknown-openbsd7.1\nchecking host system type... x86_64-unknown-openbsd7.1\nchecking which template to use... openbsd\n...\nconfig.status: linking src\/backend\/port\/sysv_sema.c to src\/backend\/port\/pg_sema.c\nconfig.status: linking src\/backend\/port\/sysv_shmem.c to src\/backend\/port\/pg_shmem.c\nconfig.status: linking src\/include\/port\/openbsd.h to src\/include\/pg_config_os.h\nconfig.status: linking src\/makefiles\/Makefile.openbsd to src\/Makefile.port\n<\/pre><\/div>\n\n\n
Ready to compile:<\/p>\n\n\n
\nopenbsd-latest$ make all\nYou must use GNU make to build PostgreSQL.\n*** Error 1 in \/home\/postgres\/postgresql-15rc2 (Makefile:47 'all': @IFS=':' ;  for dir in $PATH; do  for prog in gmake gnumake make; do  if ...)\n<\/pre><\/div>\n\n\n
OK, this seems to be obvious, we need GNU Make<\/a> for this:<\/p>\n\n\n
\nopenbsd-latest$ doas pkg_add gmake\nquirks-5.5 signed on 2022-10-08T12:25:54Z\ngmake-4.3: ok\nopenbsd-latest$ gmake all   \n...\ngmake[1]: Entering directory '\/home\/postgres\/postgresql-15rc2\/config'\ngmake[1]: Nothing to be done for 'all'.\ngmake[1]: Leaving directory '\/home\/postgres\/postgresql-15rc2\/config'\n<\/pre><\/div>\n\n\n
 Done, so install and add the extensions, but first create the directory structure. Here you have the choice, we’ll usually do it like this to make it easier for our service desk to work on both, Oracle and PostgreSQL:<\/p>\n\n\n
\nopenbsd-latest$ doas mkdir -p \/u01\/app\/postgres\/local\nopenbsd-latest$ doas mkdir \/u02\nopenbsd-latest$ doas mkdir \/u99\nopenbsd-latest$ doas chown -R postgres:postgres \/u01\/\nopenbsd-latest$ doas chown postgres:postgres \/u02\nopenbsd-latest$ doas chown postgres:postgres \/u99\nopenbsd-latest$ doas chmod 770 \/u01\/app\/postgres\nopenbsd-latest$ doas chmod 770 \/u02\nopenbsd-latest$ doas chmod 770 \/u99\n<\/pre><\/div>\n\n\n
The last steps to do for bringing the PostgreSQL server and the extensions onto the system:<\/p>\n\n\n
\nopenbsd-latest$ doas ln -s \/usr\/local\/bin\/llvm-lto \/usr\/bin\/llvm-lto  \nopenbsd-latest$ gmake install         \nUsing GNU make found at \/usr\/local\/bin\/gmake\n\/usr\/local\/bin\/gmake -C .\/src\/backend generated-headers\ngmake[1]: Entering directory '\/home\/postgres\/postgresql-15rc2\/src\/backend'\n\/usr\/local\/bin\/gmake -C catalog distprep generated-header-symlinks\nopenbsd-latest$ cd contrib\/                                                                                                                        \nopenbsd-latest$ gmake install                                                                                                                      \ngmake -C ..\/src\/backend generated-headers\ngmake[1]: Entering directory '\/home\/postgres\/postgresql-15rc2\/src\/backend'\ngmake -C catalog distprep generated-header-symlinks\ngmake[2]: Entering directory '\/home\/postgres\/postgresql-15rc2\/src\/backend\/catalog'\n...\ncd '\/u01\/app\/postgres\/product\/15\/db_0\/\/lib\/bitcode' && \/usr\/bin\/llvm-lto -thinlto -thinlto-action=thinlink -o ltree_plpython3.index.bc ltree_plpython3\/ltree_plpython.bc\ngmake[1]: Leaving directory '\/home\/postgres\/postgresql-15rc2\/contrib\/ltree_plpython'\n<\/pre><\/div>\n\n\n
Done. Initializing the cluster is nothing special:<\/p>\n\n\n
\nopenbsd-latest$ \/u01\/app\/postgres\/product\/15\/db_0\/bin\/initdb -D \/u02\/pgdata\/15\/PG1\nThe files belonging to this database system will be owned by user "postgres".\nThis user must also own the server process.\n\nThe database cluster will be initialized with locale "C".\nThe default database encoding has accordingly been set to "SQL_ASCII".\nThe default text search configuration will be set to "english".\n\nData page checksums are disabled.\n\ncreating directory \/u02\/pgdata\/15\/PG1 ... ok\ncreating subdirectories ... ok\nselecting dynamic shared memory implementation ... posix\nselecting default max_connections ... 20\nselecting default shared_buffers ... 128MB\nselecting default time zone ... Europe\/Berlin\ncreating configuration files ... ok\nrunning bootstrap script ... ok\nperforming post-bootstrap initialization ... ok\nsyncing data to disk ... ok\n\ninitdb: warning: enabling "trust" authentication for local connections\ninitdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.\n\nSuccess. You can now start the database server using:\n\n    \/u01\/app\/postgres\/product\/15\/db_0\/bin\/pg_ctl -D \/u02\/pgdata\/15\/PG1 -l logfile start\n<\/pre><\/div>\n\n\n
The last step is to create a service, so PostgreSQL will start automatically when the system comes up. How does that work on OpenBSD. We’ve already seen in the last post<\/a> that OpenBSD uses rc<\/a> to manage system daemons. All we need to do is to create a script like this in \/etc\/rc.d (this is stolen from the PostgreSQL packages):<\/p>\n\n\n
\nopenbsd-latest$ cat \/etc\/rc.d\/postgres\n#!\/bin\/ksh\n\ndaemon="\/u01\/app\/postgres\/product\/15\/db_0\/bin\/pg_ctl"\ndaemon_flags="-D \/u02\/pgdata\/15\/PG1\/ -w -l \/u02\/pgdata\/15\/PG1\/log\/postgresql.log"\ndaemon_user="postgres"\ndaemon_timeout=300\n\n. \/etc\/rc.d\/rc.subr\n\nrc_usercheck=NO\n\nrc_check() {\n        ${rcexec} "${daemon} status ${daemon_flags}"\n}\n\nrc_reload() {\n        ${rcexec} "${daemon} reload ${daemon_flags}"\n}\n\nrc_start() {\n        ${rcexec} "${daemon} start ${daemon_flags}"\n}\n\nrc_stop() {\n        ${rcexec} "${daemon} stop ${daemon_flags} -m fast" || \\\n                ${rcexec} "${daemon} stop ${daemon_flags} -m immediate"\n}\n\nrc_cmd $1\n\n<\/pre><\/div>\n\n\n
Enable and start the service, and that’s it:<\/p>\n\n\n
\nopenbsd-latest# chmod 755 \/etc\/rc.d\/postgres                                                                                                                 \nopenbsd-latest# rcctl enable postgres \nopenbsd-latest# rcctl start postgres \nopenbsd-latest# \/u01\/app\/postgres\/product\/15\/db_0\/bin\/psql -U postgres postgres\npsql (15rc2)\nType "help" for help.\n\npostgres=# \n<\/pre><\/div>\n\n\n
Conclusion: We anyway prefer to install PostgreSQL from source code, because in that case we are independent from the package manager, whatever it is. In the case of OpenBSD it seems to be even more important, because the packages provided by the OS do not reflect the latest PostgreSQL minor version. Doing it that way is quite simple, once you figured out the required dependencies and how the init<\/a> systems works.<\/p>\n","protected":false},"excerpt":{"rendered":"
In the last post we’ve seen that it is quite easy to get started with PostgreSQL on OpenBSD when you install from the provided packages. The downside of this was, that not the latest version of PostgreSQL was provided, 14.2 instead of 14.5, which is the current version as of today. If you want to […]<\/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,2719,2602],"type_dbi":[],"class_list":["post-19621","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","tag-bsd","tag-openbsd","tag-postgresql-2"],"acf":[],"yoast_head":"\nPostgreSQL from source on OpenBSD - 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-source-on-openbsd\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL from source on OpenBSD\" \/>\n<meta property=\"og:description\" content=\"In the last post we’ve seen that it is quite easy to get started with PostgreSQL on OpenBSD when you install from the provided packages. The downside of this was, that not the latest version of PostgreSQL was provided, 14.2 instead of 14.5, which is the current version as of today. If you want to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-10T06:25:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-18T16:42:17+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=\"5 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-source-on-openbsd\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"PostgreSQL from source on OpenBSD\",\"datePublished\":\"2022-10-10T06:25:25+00:00\",\"dateModified\":\"2022-11-18T16:42:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/\"},\"wordCount\":475,\"commentCount\":0,\"keywords\":[\"BSD\",\"OpenBSD\",\"postgresql\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/\",\"name\":\"PostgreSQL from source on OpenBSD - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-10-10T06:25:25+00:00\",\"dateModified\":\"2022-11-18T16:42:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL from source on OpenBSD\"}]},{\"@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 source on OpenBSD - 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-source-on-openbsd\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL from source on OpenBSD","og_description":"In the last post we’ve seen that it is quite easy to get started with PostgreSQL on OpenBSD when you install from the provided packages. The downside of this was, that not the latest version of PostgreSQL was provided, 14.2 instead of 14.5, which is the current version as of today. If you want to […]","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/","og_site_name":"dbi Blog","article_published_time":"2022-10-10T06:25:25+00:00","article_modified_time":"2022-11-18T16:42:17+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"PostgreSQL from source on OpenBSD","datePublished":"2022-10-10T06:25:25+00:00","dateModified":"2022-11-18T16:42:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/"},"wordCount":475,"commentCount":0,"keywords":["BSD","OpenBSD","postgresql"],"articleSection":["Database Administration & Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/","name":"PostgreSQL from source on OpenBSD - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-10-10T06:25:25+00:00","dateModified":"2022-11-18T16:42:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL from source on OpenBSD"}]},{"@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\/19621","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=19621"}],"version-history":[{"count":12,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19621\/revisions"}],"predecessor-version":[{"id":19641,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19621\/revisions\/19641"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=19621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=19621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=19621"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=19621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}