For this installation i’m using a Hardkernel Odroid N2\/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU.
\nThese device is normaly a good device as Mediaplayer using Coreelec based on Kodi, it has everything needed for including IR receiver for IR remote device.<\/p>\n
The installation of ARMBIAN is a easy step, Odroid N2 devices using a EMMC Module and with a Adapter for SD Cards it is a very easy step putting Armbian on the EMMC using for example Etcher on Windows.
\nFor this Blog I’m using a 16GB EMMC module with Armbian Bullsey which is till now a unstable Release, but for a R&D Task it is fine.<\/p>\n
On the first boot user will be asked to replace the Armbian default password 1234 which makes definitly sense.<\/p>\n
First boot after changing the default passord.<\/p>\n
\n$ ___ _ _ _ _ _ ____\n$ \/ _ __| |_ __ ___ (_) __| | | | |___ \n$ | | | |\/ _` | '__\/ _ | |\/ _` | | | | __) |\n$ | |_| | (_| | | | (_) | | (_| | | | |\/ __\/\n$ ___\/ __,_|_| ___\/|_|__,_| |_| _|_____|\n$ \n$ Welcome to Armbian 21.08.1 Bullseye with Linux 5.10.60-meson64\n$ \n$ System load: 2% Up time: 2 min\n$ Memory usage: 4% of 3.61G IP: 192.168.128.32\n$ CPU temp: 27\u00b0C Usage of \/: 12% of 15G\n$ \n$ [ General system configuration (beta): armbian-config ]\n$ \n$ Last login: Fri Jan 14 08:24:27 2022 from 192.168.128.20\n$ root@odroidn2:~#\n<\/pre>\nReboot after updating:<\/p>\n
\n$ ___ _ _ _ _ _ ____\n$ \/ _ __| |_ __ ___ (_) __| | | | |___ \n$ | | | |\/ _` | '__\/ _ | |\/ _` | | | | __) |\n$ | |_| | (_| | | | (_) | | (_| | | | |\/ __\/\n$ ___\/ __,_|_| ___\/|_|__,_| |_| _|_____|\n$ \n$ Welcome to Armbian 21.08.6 Bullseye with Linux 5.10.81-meson64\n$ \n$ System load: 2% Up time: 0 min\n$ Memory usage: 4% of 3.61G IP: 192.168.128.32\n$ CPU temp: 32\u00b0C Usage of \/: 11% of 15G\n$ \n$ [ General system configuration (beta): armbian-config ]\n$ \n$ Last login: Fri Jan 14 08:24:38 2022 from 192.168.128.20\n$ root@odroidn2:~#\n<\/pre>\nFor \/var\/lib\/postgresqli’m using a USB Stick, in this case a Corsair Slider X2 USB 3.0 which is fine, the Odroid N2\/N2+ is using USB 3.0 to.
\nHere the fdisk -l output for the USB device-<\/p>\n\n$ root@odroidn2:~# fdisk -l\n$ $ Disk \/dev\/sda: 461.63 GiB, 495666069504 bytes, 968097792 sectors\n$ Disk model: Voyager SliderX2\n$ Units: sectors of 1 * 512 = 512 bytes\n$ Sector size (logical\/physical): 512 bytes \/ 512 bytes\n$ I\/O size (minimum\/optimal): 512 bytes \/ 512 bytes\n$ Disklabel type: dos\n$ Disk identifier: 0xd900dfd8\n<\/pre>\nI’m using XFS for PostgreSQL, for this we need to install xfsprogs and create the filesystem.<\/p>\n
\n$ root@odroidn2:~# apt install xfsprogs\n$ Reading package lists... Done\n$ Building dependency tree... Done\n$ Reading state information... Done\n$ The following additional packages will be installed:\n$ libinih1\n$ Suggested packages:\n$ xfsdump acl attr quota\n$ The following NEW packages will be installed:\n$ libinih1 xfsprogs\n$ 0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.\n$ Need to get 906 kB of archives.\n$ After this operation, 3,250 kB of additional disk space will be used.\n$ Do you want to continue? [Y\/n] Y\n<\/pre>\nCreating the filesystem on the USB Stick.<\/p>\n
\n$ root@odroidn2:~# mkfs.xfs \/dev\/sda -f\n$ meta-data=\/dev\/sda isize=512 agcount=4, agsize=30253056 blks\n$ = sectsz=512 attr=2, projid32bit=1\n$ = crc=1 finobt=1, sparse=1, rmapbt=0\n$ = reflink=1 bigtime=0\n$ data = bsize=4096 blocks=121012224, imaxpct=25\n$ = sunit=0 swidth=0 blks\n$ naming =version 2 bsize=4096 ascii-ci=0, ftype=1\n$ log =internal log bsize=4096 blocks=59088, version=2\n$ = sectsz=512 sunit=0 blks, lazy-count=1\n$ realtime =none extsz=4096 blocks=0, rtextents=0\n<\/pre>\nMount the filesystem<\/p>\n
\n$ root@odroidn2:~# mkdir \/var\/lib\/postgresql\n$ root@odroidn2:~# mount \/dev\/sda \/var\/lib\/postgresql\n$ root@odroidn2:~# df -h\n$ Filesystem Size Used Avail Use% Mounted on\n$ udev 1.4G 0 1.4G 0% \/dev\n$ tmpfs 370M 832K 369M 1% \/run\n$ \/dev\/mmcblk1p1 15G 1.5G 13G 11% \/\n$ tmpfs 1.9G 0 1.9G 0% \/dev\/shm\n$ tmpfs 5.0M 4.0K 5.0M 1% \/run\/lock\n$ tmpfs 1.9G 0 1.9G 0% \/tmp\n$ \/dev\/zram1 49M 12M 34M 25% \/var\/log\n$ tmpfs 370M 0 370M 0% \/run\/user\/0\n$ \/dev\/sda 462G 3.3G 459G 1% \/var\/lib\/postgresql\n<\/pre>\nMouting permanently, at first we need the UUID and then edit \/etc\/fstab:<\/p>\n
\n$ root@odroidn2:\/# ls -al \/dev\/disk\/by-uuid\/\n$ total 0\n$ drwxr-xr-x 2 root root 80 Jan 14 10:25 .\n$ drwxr-xr-x 6 root root 120 Jan 1 1970 ..\n$ lrwxrwxrwx 1 root root 9 Jan 14 10:25 755a56a5-79ca-48d5-911a-f5c6d9e81563 -> ..\/..\/sda\n$ lrwxrwxrwx 1 root root 15 Jan 14 10:25 99afb779-b78b-4d62-9926-d09ecb786cc2 -> ..\/..\/mmcblk1p1\n$ root@odroidn2:\/#nano \/etc\/fstab\n$ UUID=99afb779-b78b-4d62-9926-d09ecb786cc2 \/ ext4 defaults,noatime,commit=600,errors=remount-ro 0 1\n$ tmpfs \/tmp tmpfs defaults,nosuid 0 0\n$ UUID=755a56a5-79ca-48d5-911a-f5c6d9e81563 \/var\/lib\/postgresql xfs 0 0\n<\/pre>\nNow the preparation are done, starting with PostgreSQL, Armbian Bullsey is providing PostgreSQL up to PostgreSQL 13.<\/p>\n
\n$ root@odroidn2:~# apt install postgresql-13 postgresql-contrib\n$ Preparing to unpack ...\/3-libxslt1.1_1.1.34-4_arm64.deb ...\n$ Unpacking libxslt1.1:arm64 (1.1.34-4) ...\n$ Selecting previously unselected package postgresql-client-common.\n$ Preparing to unpack ...\/4-postgresql-client-common_225_all.deb ...\n$ Unpacking postgresql-client-common (225) ...\n$ Selecting previously unselected package postgresql-client-13.\n$ Preparing to unpack ...\/5-postgresql-client-13_13.5-0+deb11u1_arm64.deb ...\n$ Unpacking postgresql-client-13 (13.5-0+deb11u1) ...\n$ Selecting previously unselected package ssl-cert.\n$ Preparing to unpack ...\/6-ssl-cert_1.1.0+nmu1_all.deb ...\n$ Unpacking ssl-cert (1.1.0+nmu1) ...\n$ Selecting previously unselected package postgresql-common.\n$ Preparing to unpack ...\/7-postgresql-common_225_all.deb ...\n$ Adding 'diversion of \/usr\/bin\/pg_config to \/usr\/bin\/pg_config.libpq-dev by postgresql-common'\n$ Unpacking postgresql-common (225) ...\n$ Selecting previously unselected package postgresql-13.\n$ Preparing to unpack ...\/8-postgresql-13_13.5-0+deb11u1_arm64.deb ...\n$ Unpacking postgresql-13 (13.5-0+deb11u1) ...\n$ Selecting previously unselected package postgresql-contrib.\n$ Preparing to unpack ...\/9-postgresql-contrib_13+225_all.deb ...\n$ Unpacking postgresql-contrib (13+225) ...\n$ Setting up postgresql-client-common (225) ...\n$ Setting up libpq5:arm64 (13.5-0+deb11u1) ...\n$ Setting up postgresql-client-13 (13.5-0+deb11u1) ...\n$ update-alternatives: using \/usr\/share\/postgresql\/13\/man\/man1\/psql.1.gz to provide \/usr\/share\/man\/man1\/psql.1.gz (psql.1.gz) in auto mode\n$ Setting up libz3-4:arm64 (4.8.10-1) ...\n$ Setting up libllvm11:arm64 (1:11.0.1-2) ...\n$ Setting up ssl-cert (1.1.0+nmu1) ...\n$ Setting up postgresql-common (225) ...\n$ Adding user postgres to group ssl-cert\n$ \n$ Creating config file \/etc\/postgresql-common\/createcluster.conf with new version\n$ Building PostgreSQL dictionaries from installed myspell\/hunspell packages...\n$ Removing obsolete dictionary files:\n$ Created symlink \/etc\/systemd\/system\/multi-user.target.wants\/postgresql.service \u2192 \/lib\/systemd\/system\/postgresql.service.\n$ Setting up libxslt1.1:arm64 (1.1.34-4) ...\n$ Setting up postgresql-13 (13.5-0+deb11u1) ...\n$ Creating new PostgreSQL cluster 13\/main ...\n$ \/usr\/lib\/postgresql\/13\/bin\/initdb -D \/var\/lib\/postgresql\/13\/main --auth-local peer --auth-host md5\n$ The files belonging to this database system will be owned by user \"postgres\".\n$ This user must also own the server process.\n$ \n$ The database cluster will be initialized with locale \"en_US.UTF-8\".\n$ The default database encoding has accordingly been set to \"UTF8\".\n$ The default text search configuration will be set to \"english\".\n$ \n$ Data page checksums are disabled.\n$ \n$ fixing permissions on existing directory \/var\/lib\/postgresql\/13\/main ... ok\n$ creating subdirectories ... ok\n$ selecting dynamic shared memory implementation ... posix\n$ selecting default max_connections ... 100\n$ selecting default shared_buffers ... 128MB\n$ selecting default time zone ... Etc\/UTC\n$ creating configuration files ... ok\n$ running bootstrap script ... ok\n$ performing post-bootstrap initialization ... ok\n$ syncing data to disk ... ok\n$ \n$ Success. You can now start the database server using:\n$ \n$ pg_ctlcluster 13 main start\n$ \n$ Ver Cluster Port Status Owner Data directory Log file\n$ 13 main 5432 down postgres \/var\/lib\/postgresql\/13\/main \/var\/log\/postgresql\/postgresql-13-main.log\n$ update-alternatives: using \/usr\/share\/postgresql\/13\/man\/man1\/postmaster.1.gz to provide \/usr\/share\/man\/man1\/postmaster.1.gz (postmaster.1.gz) in auto mode\n$ Setting up postgresql-contrib (13+225) ...\n$ Processing triggers for man-db (2.9.4-2) ...\n$ Processing triggers for libc-bin (2.31-13) ...\n<\/pre>\nTime for some configuration of PostgreSQL:<\/p>\n
\n$ postgres@odroidn2:\/$ nano \/var\/lib\/postgresql\/13\/main\/postgresql.auto.conf\n$ max_connections = 100\n$ superuser_reserved_connections = 3\n$ shared_buffers = '1024 MB'\n$ work_mem = '32 MB'\n$ maintenance_work_mem = '320 MB'\n$ huge_pages = off\n$ effective_cache_size = '3 GB'\n$ max_worker_processes = 6\n$ max_parallel_workers_per_gather = 3\n$ max_parallel_maintenance_workers = 3\n$ max_parallel_workers = 6\n$ parallel_leader_participation = on\n$ wal_level = replica\n$ max_wal_senders = 0\n$ synchronous_commit = on\n$ checkpoint_timeout = '15 min'\n$ checkpoint_completion_target = 0.9\n$ max_wal_size = '1024 MB'\n$ min_wal_size = '512 MB'\n$ wal_compression = on\n$ wal_buffers = -1\n$ wal_writer_delay = 200ms\n$ wal_writer_flush_after = 1MB\n$ bgwriter_delay = 200ms\n$ bgwriter_lru_maxpages = 100\n$ bgwriter_lru_multiplier = 2.0\n$ bgwriter_flush_after = 0\n$ enable_partitionwise_join = on\n$ enable_partitionwise_aggregate = on\n$ jit = on\n<\/pre>\nRestarting PostgreSQL:<\/p>\n
\n$ root@odroidn2:~# service postgresql restart\n<\/pre>\nTime for pgbench…<\/p>\n
\n$ postgres@odroidn2:\/$ createdb testdb\n$ postgres@odroidn2:\/$ pgbench -i -s 60 testdb\n$ dropping old tables...\n$ NOTICE: table \"pgbench_accounts\" does not exist, skipping\n$ NOTICE: table \"pgbench_branches\" does not exist, skipping\n$ NOTICE: table \"pgbench_history\" does not exist, skipping\n$ NOTICE: table \"pgbench_tellers\" does not exist, skipping\n$ creating tables...\n$ generating data (client-side)...\n$ 6000000 of 6000000 tuples (100%) done (elapsed 122.47 s, remaining 0.00 s)\n$ vacuuming...\n$ creating primary keys...\n$ done in 370.27 s (drop tables 0.00 s, create tables 3.28 s, client-side generate 122.55 s, vacuum 72.07 s, primary keys 172.38 s).\n<\/pre>\nThe performance is good, espacialy comparing with cloud service..<\/p>\n
\n$ latency average = 6.837 ms\n$ tps = 1462.673137 (including connections establishing)\n$ tps = 1462.914005 (excluding connections establishing)\n<\/pre>\nComparing with Azure Flexible Server V3 and V4:<\/p>\n
V3 without replication:<\/strong><\/p>\n
\nlatency average = 8.343 ms\ntps = 479.469320 (including connections establishing)\ntps = 479.735705 (excluding connections establishing)\n<\/pre>\nV4 without replication:<\/strong><\/p>\n
\nlatency average = 11.734 ms\ntps = 340.893181 (including connections establishing)\ntps = 341.094725 (excluding connections establishing)\n<\/pre>\nHave fun playing with ARM.<\/p>\n","protected":false},"excerpt":{"rendered":"
For this installation i’m using a Hardkernel Odroid N2\/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on Kodi, it has everything needed for including IR receiver for IR remote device. The installation of […]<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[2602],"type_dbi":[],"class_list":["post-582","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-postgresql-2"],"acf":[],"yoast_head":"\n
PostgreSQL on ARM using Odroid N2\/N2+ - 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-on-arm-using-odroid-n2-n2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL on ARM using Odroid N2\/N2+\" \/>\n<meta property=\"og:description\" content=\"For this installation i’m using a Hardkernel Odroid N2\/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on Kodi, it has everything needed for including IR receiver for IR remote device. The installation of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-14T12:43:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-08T14:42:01+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=\"7 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-on-arm-using-odroid-n2-n2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/59554f0d99383431eb6ed427e338952b\"},\"headline\":\"PostgreSQL on ARM using Odroid N2\\\/N2+\",\"datePublished\":\"2022-01-14T12:43:31+00:00\",\"dateModified\":\"2024-11-08T14:42:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/\"},\"wordCount\":294,\"commentCount\":0,\"keywords\":[\"postgresql\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/\",\"name\":\"PostgreSQL on ARM using Odroid N2\\\/N2+ - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-01-14T12:43:31+00:00\",\"dateModified\":\"2024-11-08T14:42:01+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/59554f0d99383431eb6ed427e338952b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/postgresql-on-arm-using-odroid-n2-n2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL on ARM using Odroid N2\\\/N2+\"}]},{\"@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\\\/59554f0d99383431eb6ed427e338952b\",\"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 on ARM using Odroid N2\/N2+ - 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-on-arm-using-odroid-n2-n2\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL on ARM using Odroid N2\/N2+","og_description":"For this installation i’m using a Hardkernel Odroid N2\/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on Kodi, it has everything needed for including IR receiver for IR remote device. The installation of […]","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/","og_site_name":"dbi Blog","article_published_time":"2022-01-14T12:43:31+00:00","article_modified_time":"2024-11-08T14:42:01+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Open source Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"headline":"PostgreSQL on ARM using Odroid N2\/N2+","datePublished":"2022-01-14T12:43:31+00:00","dateModified":"2024-11-08T14:42:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/"},"wordCount":294,"commentCount":0,"keywords":["postgresql"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/","name":"PostgreSQL on ARM using Odroid N2\/N2+ - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-14T12:43:31+00:00","dateModified":"2024-11-08T14:42:01+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-on-arm-using-odroid-n2-n2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL on ARM using Odroid N2\/N2+"}]},{"@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\/59554f0d99383431eb6ed427e338952b","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\/582","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=582"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/582\/revisions"}],"predecessor-version":[{"id":658,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/582\/revisions\/658"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=582"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}