{"id":180,"date":"2026-05-10T23:42:24","date_gmt":"2026-05-11T06:42:24","guid":{"rendered":"https:\/\/choice.work\/?p=180"},"modified":"2026-05-10T23:42:45","modified_gmt":"2026-05-11T06:42:45","slug":"choice-log-no-1778480994-postgresql-18-administration","status":"publish","type":"post","link":"https:\/\/choice.work\/?p=180","title":{"rendered":"Choice log no. 1778480994 – PostgreSQL 18 Administration Inistallation"},"content":{"rendered":"

Ubutntu 24.04
\nPostgreSQL 18<\/p>\n

sudo apt update && sudo apt upgrade -y<\/strong>
\nsudo apt dist-upgrade<\/strong>
\nsudo apt autoremove<\/strong>
\nsudo reboot<\/strong><\/p>\n

sudo apt install -y postgresql-common<\/strong>
\nReading package lists\u2026 Done
\nBuilding dependency tree\u2026 Done
\nReading state information\u2026 Done
\nThe following additional packages will be installed:
\n libcommon-sense-perl libjson-perl libjson-xs-perl libtypes-serialiser-perl postgresql-client-common
\nThe following NEW packages will be installed:
\n libcommon-sense-perl libjson-perl libjson-xs-perl libtypes-serialiser-perl postgresql-client-common postgresql-common
\n0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
\nNeed to get 395 kB of archives.
\nAfter this operation, 1,326 kB of additional disk space will be used.
\nGet:1 http:\/\/us.archive.ubuntu.com\/ubuntu noble\/main amd64 libjson-perl all 4.10000-1 [81.9 kB]
\nGet:2 http:\/\/us.archive.ubuntu.com\/ubuntu noble-updates\/main amd64 postgresql-client-common all 257build1.1 [36.4 kB]
\nGet:3 http:\/\/us.archive.ubuntu.com\/ubuntu noble-updates\/main amd64 postgresql-common all 257build1.1 [161 kB]
\nGet:4 http:\/\/us.archive.ubuntu.com\/ubuntu noble\/main amd64 libcommon-sense-perl amd64 3.75-3build3 [20.4 kB]
\nGet:5 http:\/\/us.archive.ubuntu.com\/ubuntu noble\/main amd64 libtypes-serialiser-perl all 1.01-1 [11.6 kB]
\nGet:6 http:\/\/us.archive.ubuntu.com\/ubuntu noble-updates\/main amd64 libjson-xs-perl amd64 4.040-0ubuntu0.24.04.1 [83.7 kB]
\nFetched 395 kB in 1s (706 kB\/s)
\nPreconfiguring packages \u2026
\nSelecting previously unselected package libjson-perl.
\n(Reading database \u2026 147196 files and directories currently installed.)
\nPreparing to unpack \u2026\/0-libjson-perl_4.10000-1_all.deb \u2026
\nUnpacking libjson-perl (4.10000-1) \u2026
\nSelecting previously unselected package postgresql-client-common.
\nPreparing to unpack \u2026\/1-postgresql-client-common_257build1.1_all.deb \u2026
\nUnpacking postgresql-client-common (257build1.1) \u2026
\nSelecting previously unselected package postgresql-common.
\nPreparing to unpack \u2026\/2-postgresql-common_257build1.1_all.deb \u2026
\nAdding \u2018diversion of \/usr\/bin\/pg_config to \/usr\/bin\/pg_config.libpq-dev by postgresql-common\u2019
\nUnpacking postgresql-common (257build1.1) \u2026
\nSelecting previously unselected package libcommon-sense-perl:amd64.
\nPreparing to unpack \u2026\/3-libcommon-sense-perl_3.75-3build3_amd64.deb \u2026
\nUnpacking libcommon-sense-perl:amd64 (3.75-3build3) \u2026
\nSelecting previously unselected package libtypes-serialiser-perl.
\nPreparing to unpack \u2026\/4-libtypes-serialiser-perl_1.01-1_all.deb \u2026
\nUnpacking libtypes-serialiser-perl (1.01-1) \u2026
\nSelecting previously unselected package libjson-xs-perl.
\nPreparing to unpack \u2026\/5-libjson-xs-perl_4.040-0ubuntu0.24.04.1_amd64.deb \u2026
\nUnpacking libjson-xs-perl (4.040-0ubuntu0.24.04.1) \u2026
\nSetting up postgresql-client-common (257build1.1) \u2026
\nSetting up libcommon-sense-perl:amd64 (3.75-3build3) \u2026
\nSetting up libtypes-serialiser-perl (1.01-1) \u2026
\nSetting up libjson-perl (4.10000-1) \u2026
\nSetting up libjson-xs-perl (4.040-0ubuntu0.24.04.1) \u2026
\nSetting up postgresql-common (257build1.1) \u2026<\/p>\n

Creating config file \/etc\/postgresql-common\/createcluster.conf with new version
\nBuilding PostgreSQL dictionaries from installed myspell\/hunspell packages\u2026
\nRemoving obsolete dictionary files:
\nCreated symlink \/etc\/systemd\/system\/multi-user.target.wants\/postgresql.service \u2192 \/usr\/lib\/systemd\/system\/postgresql.service.
\nProcessing triggers for man-db (2.12.0-4build2) \u2026
\nScanning processes\u2026
\nScanning linux images\u2026 <\/p>\n

Running kernel seems to be up-to-date.
\nNo services need to be restarted.
\nNo containers need to be restarted.
\nNo user sessions are running outdated binaries.
\nNo VM guests are running outdated hypervisor (qemu) binaries on this host.<\/p>\n

sudo \/usr\/share\/postgresql-common\/pgdg\/apt.postgresql.org.sh<\/strong>
\nThis script will enable the PostgreSQL APT repository on apt.postgresql.org on
\nyour system. The distribution codename used will be noble-pgdg.<\/p>\n

Press Enter to continue, or Ctrl-C to abort.<\/p>\n

Using keyring \/usr\/share\/postgresql-common\/pgdg\/apt.postgresql.org.gpg
\nWriting \/etc\/apt\/sources.list.d\/pgdg.sources \u2026<\/p>\n

Running apt-get update \u2026
\nGet:1 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg InRelease [180 kB]
\nHit:2 http:\/\/security.ubuntu.com\/ubuntu noble-security InRelease
\nHit:3 http:\/\/us.archive.ubuntu.com\/ubuntu noble InRelease
\nGet:4 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg\/main amd64 Packages [481 kB]
\nHit:5 http:\/\/us.archive.ubuntu.com\/ubuntu noble-updates InRelease
\nHit:6 http:\/\/us.archive.ubuntu.com\/ubuntu noble-backports InRelease
\nFetched 661 kB in 1s (607 kB\/s)
\nReading package lists\u2026 Done<\/p>\n

You can now start installing packages from apt.postgresql.org.<\/p>\n

Have a look at https:\/\/wiki.postgresql.org\/wiki\/Apt for more information;
\nmost notably the FAQ at https:\/\/wiki.postgresql.org\/wiki\/Apt\/FAQ<\/p>\n

sudo apt update<\/strong>
\nHit:1 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg InRelease
\nHit:2 http:\/\/security.ubuntu.com\/ubuntu noble-security InRelease
\nHit:3 http:\/\/us.archive.ubuntu.com\/ubuntu noble InRelease
\nHit:4 http:\/\/us.archive.ubuntu.com\/ubuntu noble-updates InRelease
\nHit:5 http:\/\/us.archive.ubuntu.com\/ubuntu noble-backports InRelease
\nReading package lists\u2026 Done
\nBuilding dependency tree\u2026 Done
\nReading state information\u2026 Done
\n2 packages can be upgraded. Run \u2018apt list \u2013upgradable\u2019 to see them.<\/p>\n

sudo apt install postgresql-18<\/strong>
\nReading package lists\u2026 Done
\nBuilding dependency tree\u2026 Done
\nReading state information\u2026 Done
\nThe following additional packages will be installed:
\n libllvm19 libpq5 postgresql-18-jit postgresql-client-18 postgresql-client-common postgresql-common
\nSuggested packages:
\n libpq-oauth postgresql-doc-18
\nThe following NEW packages will be installed:
\n libllvm19 libpq5 postgresql-18 postgresql-18-jit postgresql-client-18
\nThe following packages will be upgraded:
\n postgresql-client-common postgresql-common
\n2 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
\nNeed to get 48.6 MB of archives.
\nAfter this operation, 202 MB of additional disk space will be used.
\nDo you want to continue? [Y\/n] Y
\nGet:1 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg\/main amd64 postgresql-common all 290.pgdg24.04+1 [113 kB]
\nGet:2 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg\/main amd64 postgresql-client-common all 290.pgdg24.04+1 [48.1 kB]
\nGet:3 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg\/main amd64 libpq5 amd64 18.3-1.pgdg24.04+1 [255 kB]
\nGet:4 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg\/main amd64 postgresql-client-18 amd64 18.3-1.pgdg24.04+1 [2,086 kB]
\nGet:5 http:\/\/us.archive.ubuntu.com\/ubuntu noble-updates\/main amd64 libllvm19 amd64 1:19.1.1-1ubuntu1~24.04.2 [28.7 MB]
\nGet:6 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg\/main amd64 postgresql-18 amd64 18.3-1.pgdg24.04+1 [7,527 kB]
\nGet:7 https:\/\/apt.postgresql.org\/pub\/repos\/apt noble-pgdg\/main amd64 postgresql-18-jit amd64 18.3-1.pgdg24.04+1 [9,867 kB]
\nFetched 48.6 MB in 2s (31.9 MB\/s)
\nPreconfiguring packages \u2026
\n(Reading database \u2026 147418 files and directories currently installed.)
\nPreparing to unpack \u2026\/0-postgresql-common_290.pgdg24.04+1_all.deb \u2026
\nLeaving \u2018diversion of \/usr\/bin\/pg_config to \/usr\/bin\/pg_config.libpq-dev by postgresql-common\u2019
\nUnpacking postgresql-common (290.pgdg24.04+1) over (257build1.1) \u2026
\nPreparing to unpack \u2026\/1-postgresql-client-common_290.pgdg24.04+1_all.deb \u2026
\nUnpacking postgresql-client-common (290.pgdg24.04+1) over (257build1.1) \u2026
\nSelecting previously unselected package libllvm19:amd64.
\nPreparing to unpack \u2026\/2-libllvm19_1%3a19.1.1-1ubuntu1~24.04.2_amd64.deb \u2026
\nUnpacking libllvm19:amd64 (1:19.1.1-1ubuntu1~24.04.2) \u2026
\nSelecting previously unselected package libpq5:amd64.
\nPreparing to unpack \u2026\/3-libpq5_18.3-1.pgdg24.04+1_amd64.deb \u2026
\nUnpacking libpq5:amd64 (18.3-1.pgdg24.04+1) \u2026
\nSelecting previously unselected package postgresql-client-18.
\nPreparing to unpack \u2026\/4-postgresql-client-18_18.3-1.pgdg24.04+1_amd64.deb \u2026
\nUnpacking postgresql-client-18 (18.3-1.pgdg24.04+1) \u2026
\nSelecting previously unselected package postgresql-18.
\nPreparing to unpack \u2026\/5-postgresql-18_18.3-1.pgdg24.04+1_amd64.deb \u2026
\nUnpacking postgresql-18 (18.3-1.pgdg24.04+1) \u2026
\nSelecting previously unselected package postgresql-18-jit.
\nPreparing to unpack \u2026\/6-postgresql-18-jit_18.3-1.pgdg24.04+1_amd64.deb \u2026
\nUnpacking postgresql-18-jit (18.3-1.pgdg24.04+1) \u2026
\nSetting up postgresql-client-common (290.pgdg24.04+1) \u2026
\nRemoving obsolete conffile \/etc\/postgresql-common\/supported_versions \u2026
\nSetting up libllvm19:amd64 (1:19.1.1-1ubuntu1~24.04.2) \u2026
\nSetting up libpq5:amd64 (18.3-1.pgdg24.04+1) \u2026
\nSetting up postgresql-common (290.pgdg24.04+1) \u2026
\nInstalling new version of config file \/etc\/postgresql-common\/pg_upgradecluster.d\/analyze \u2026
\nReplacing config file \/etc\/postgresql-common\/createcluster.conf with new version
\nSetting up postgresql-client-18 (18.3-1.pgdg24.04+1) \u2026
\nupdate-alternatives: using \/usr\/share\/postgresql\/18\/man\/man1\/psql.1.gz to provide \/usr\/share\/man\/man1\/psql.1.gz (psql.1.gz) in auto mode
\nSetting up postgresql-18 (18.3-1.pgdg24.04+1) \u2026
\nCreating new PostgreSQL cluster 18\/main \u2026
\n\/usr\/lib\/postgresql\/18\/bin\/initdb -D \/var\/lib\/postgresql\/18\/main \u2013auth-local peer \u2013auth-host scram-sha-256 \u2013no-instructions
\nThe files belonging to this database system will be owned by user \u201cpostgres\u201d.
\nThis user must also own the server process.<\/p>\n

The database cluster will be initialized with locale \u201cen_US.UTF-8\u201d.
\nThe default database encoding has accordingly been set to \u201cUTF8\u201d.
\nThe default text search configuration will be set to \u201cenglish\u201d.<\/p>\n

Data page checksums are enabled.<\/p>\n

fixing permissions on existing directory \/var\/lib\/postgresql\/18\/main \u2026 ok
\ncreating subdirectories \u2026 ok
\nselecting dynamic shared memory implementation \u2026 posix
\nselecting default \u201cmax_connections\u201d \u2026 100
\nselecting default \u201cshared_buffers\u201d \u2026 128MB
\nselecting default time zone \u2026 America\/Los_Angeles
\ncreating configuration files \u2026 ok
\nrunning bootstrap script \u2026 ok
\nperforming post-bootstrap initialization \u2026 ok
\nsyncing data to disk \u2026 ok
\nSetting up postgresql-18-jit (18.3-1.pgdg24.04+1) \u2026
\nProcessing triggers for libc-bin (2.39-0ubuntu8.7) \u2026
\nProcessing triggers for man-db (2.12.0-4build2) \u2026
\nScanning processes\u2026
\nScanning linux images\u2026 <\/p>\n

Running kernel seems to be up-to-date.
\nNo services need to be restarted.
\nNo containers need to be restarted.
\nNo user sessions are running outdated binaries.
\nNo VM guests are running outdated hypervisor (qemu) binaries on this host.<\/p>\n

Sanity check<\/em><\/strong>
\nsudo systemctl status postgresql<\/strong>
\n\u25cf postgresql.service \u2013 PostgreSQL RDBMS
\n Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql.service; enabled; preset: enabled)
\n Active: active (exited) since Sun 2026-05-10 13:29:30 PDT; 4min 17s ago
\n Main PID: 1833 (code=exited, status=0\/SUCCESS)
\n CPU: 3ms<\/p>\n

May 10 13:29:30 pvews systemd[1]: Starting postgresql.service \u2013 PostgreSQL RDBMS\u2026
\nMay 10 13:29:30 pvews systemd[1]: Finished postgresql.service \u2013 PostgreSQL RDBMS.<\/p>\n

Confirm user
\nsudo -i -u postgres<\/strong>
\npostgres@pvews:~$ psql
\npsql (18.3 (Ubuntu 18.3-1.pgdg24.04+1))
\nType \u201chelp\u201d for help.<\/p>\n