{"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<p class=\"wp-block-paragraph\">The last flavor of BSD we&#8217;ll look at is <a href=\"https:\/\/netbsd.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">NetBSD<\/a>. We already had FreeBSD (<a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-on-freebsd-installation-from-packages\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> and <a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-on-freebsd-installation-from-source-code\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>) and OpenBSD (<a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-packages-on-openbsd\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> and <a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-from-source-on-openbsd\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>). If you want to learn more about the history of NetBSD and the goals of the project, head over to the <a href=\"https:\/\/netbsd.org\/about\/\" target=\"_blank\" rel=\"noreferrer noopener\">about page<\/a> on the official website. We&#8217;ll use the same structure as in the other BSD related posts: First we&#8217;ll look at how you can get started with PostgreSQL on NetBSD with packages in this post. The next post we&#8217;ll be about getting PostgreSQL up and running on NetBSD from source code.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Again, we&#8217;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<p class=\"wp-block-paragraph\">The tool on NetBSD to apply the latest updates is <a href=\"https:\/\/pkgin.net\/\" target=\"_blank\" rel=\"noreferrer noopener\">pkgin<\/a>. As this is not installed by default in a minimal installation we need to do that first:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,2,3,9]; title: ; notranslate\" title=\"\">\nlocalhost$ PKG_PATH=&quot;https:\/\/cdn.NetBSD.org\/pub\/pkgsrc\/packages\/NetBSD\/$(uname -p)\/$(uname -r | cut -d_ -f1)\/All&quot;\nlocalhost$ export PKG_PATH\nlocalhost$ pkg_add pkgin\npkg_add: Warning: package `pkgin-21.12.0nb2&#039; 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&#039; 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<p class=\"wp-block-paragraph\">Now we can update the packages to the latest release:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,6]; title: ; notranslate\" title=\"\">\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<p class=\"wp-block-paragraph\">Lets check what we have available when it comes to PostgreSQL:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1]; title: ; notranslate\" title=\"\">\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<p class=\"wp-block-paragraph\">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<p class=\"wp-block-paragraph\">Again, and no surprise, the installation from packages is easy:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\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 ? &#x5B;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&#039;&#039;\npostgresql14-server-14.4: Creating user ``pgsql&#039;&#039;\n===========================================================================\nThe following files should be created for postgresql14-server-14.4:\n\n        \/etc\/rc.d\/pgsql (m=0755)\n            &#x5B;\/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<p class=\"wp-block-paragraph\">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<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,2]; title: ; notranslate\" title=\"\">\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<p class=\"wp-block-paragraph\">Initializing the cluster and starting it up can now be done using the &#8220;service&#8221; command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [1,6]; title: ; notranslate\" title=\"\">\nnetbsd-latest$ service pgsql initdb\nInitializing PostgreSQL databases.\ninitdb: warning: enabling &quot;trust&quot; 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<p class=\"wp-block-paragraph\">That was easy and PostgreSQL is up and running:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; highlight: [1,5]; title: ; notranslate\" title=\"\">\nnetbsd-latest$ psql -U pgsql postgres\npsql (14.4)\nType &quot;help&quot; 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<p class=\"wp-block-paragraph\">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":"<p>The last flavor of BSD we&#8217;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&#8217;ll use the same structure as [&hellip;]<\/p>\n","protected":false},"author":28,"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":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>PostgreSQL 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&#8217;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&#8217;ll use the same structure as [&hellip;]\" \/>\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=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\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\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/4bae5e5dd8c7d48edbd948772b49b202\"},\"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 &amp; 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\\\/4bae5e5dd8c7d48edbd948772b49b202\"},\"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\\\/4bae5e5dd8c7d48edbd948772b49b202\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"caption\":\"Open source Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/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&#8217;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&#8217;ll use the same structure as [&hellip;]","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":"Open source Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Open source Team","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":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4bae5e5dd8c7d48edbd948772b49b202"},"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 &amp; 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\/4bae5e5dd8c7d48edbd948772b49b202"},"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\/4bae5e5dd8c7d48edbd948772b49b202","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","caption":"Open source Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_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\/28"}],"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}]}}