Modified Dockerfile for timescaledb

[einarwar]

Hello, and thanks for this tool.

I am working in a project where we needed to smoothly upgrade from postgres 15 to 16, where different running instances had different postgres versions. We easilly solved this by replacing the official postgres-image with the docker-pgautoupgrade image.

We now plan to add the timescaledb, preferably by using an image. I tried to modify and apply the example for postGIS, but was not able to get it to work.

FROM docker.io/timescale/timescaledb:latest-pg16 as pg16
FROM docker.io/pgautoupgrade/pgautoupgrade:16-bookworm as pgautoupgrade

# Original entrypoint overwritten in /usr/local/bin, so copy elsewhere
RUN cp /usr/local/bin/docker-entrypoint.sh /docker-entrypoint.sh

# Copy in TimescaleDB libs/bins, Not sure about this one
COPY --from=pg16 /usr/lib /usr/lib

# Copy extensions for postgresql 16
COPY --from=pg16 /usr/local /usr/local

# Squash image to reduce size
FROM scratch
COPY --from=pgautoupgrade / /
ENV \
    PGTARGET=16 \
    PGDATA=/var/lib/postgresql/data
WORKDIR /var/lib/postgresql
ENTRYPOINT ["/docker-entrypoint.sh"]
CMD ["postgres"]

Trying to build this results in the following error:
/docker-entrypoint.sh: line 92: /usr/local/bin/initdb: cannot execute: required file not found

Do you have any suggestions or pointers on what i am doing wrong, and do you think it would be possible to make an example like the postgis one, but for timescaleDB as well?

[justinclift]

Interesting problem. 😄

Let's see if we can first figure out why it's throwing that error for you, as there might turn out to be a simple fix. 😄

The "required file not found" sounds like either initdb itself is in a different location, or one of it's dependencies.

Are you able to check if the /usr/local/bin/initdb file is present, and at exactly that path?

If it is, are you able to run ldd on it? ie: ldd /usr/local/bin/initdb

That should (in theory) output a list of the dependency libraries that initdb tries to load. That might also reveal what's broken. 😄

[einarwar]

It seems to be there. It seems like libc.musl-x86_64.so.1 is not found

root@e90d3ae57568:/# ldd /usr/local/bin/initdb 
        linux-vdso.so.1 (0x00007ffccebf7000)
        libpq.so.5 => /lib/x86_64-linux-gnu/libpq.so.5 (0x00007f1ce0482000)
        libicuuc.so.74 => /lib/libicuuc.so.74 (0x00007f1ce02de000)
        libc.musl-x86_64.so.1 => not found
        libssl.so.3 => /lib/x86_64-linux-gnu/libssl.so.3 (0x00007f1ce0235000)
        libcrypto.so.3 => /lib/x86_64-linux-gnu/libcrypto.so.3 (0x00007f1cdfdaf000)
        libgssapi_krb5.so.2 => /lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007f1cdfd5a000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f1cdfc7b000)
        libldap-2.5.so.0 => /lib/x86_64-linux-gnu/libldap-2.5.so.0 (0x00007f1cdfc1c000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f1cdfa3b000)
        libicudata.so.74 => /lib/libicudata.so.74 (0x00007f1cdfa38000)
        libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f1cdf81e000)
        libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f1cdf7fc000)
        libc.musl-x86_64.so.1 => not found
        libkrb5.so.3 => /lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007f1cdf722000)
        libk5crypto.so.3 => /lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007f1cdf6f5000)
        libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007f1cdf6ef000)
        libkrb5support.so.0 => /lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007f1cdf6df000)
        /lib/ld-musl-x86_64.so.1 => /lib64/ld-linux-x86-64.so.2 (0x00007f1ce050b000)
        liblber-2.5.so.0 => /lib/x86_64-linux-gnu/liblber-2.5.so.0 (0x00007f1cdf6cf000)
        libsasl2.so.2 => /lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007f1cdf6b2000)
        libgnutls.so.30 => /lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007f1cdf496000)
        libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007f1cdf48f000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f1cdf47c000)
        libp11-kit.so.0 => /lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007f1cdf348000)
        libidn2.so.0 => /lib/x86_64-linux-gnu/libidn2.so.0 (0x00007f1cdf317000)
        libunistring.so.2 => /lib/x86_64-linux-gnu/libunistring.so.2 (0x00007f1cdf161000)
        libtasn1.so.6 => /lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007f1cdf14c000)
        libnettle.so.8 => /lib/x86_64-linux-gnu/libnettle.so.8 (0x00007f1cdf0fc000)
        libhogweed.so.6 => /lib/x86_64-linux-gnu/libhogweed.so.6 (0x00007f1cdf0b3000)
        libgmp.so.10 => /lib/x86_64-linux-gnu/libgmp.so.10 (0x00007f1cdf032000)
        libffi.so.8 => /lib/x86_64-linux-gnu/libffi.so.8 (0x00007f1cdf026000)

[justinclift]

Ahhh. That might be some kind of Alpine vs Debian problem. Musl is a special library of C routines that does things (a bit) differently than glibc which Debian uses.

To me, that looks like you're attempting to use PostgreSQL binaries compiled on Alpine (and therefore expecting musl) then trying to use that on a system that uses something-other-than-musl.

That's kind of weird though, if that's the output from PostgreSQL from the pgautoupgrade/pgautoupgrade:16-bookworm image. That's supposed to be Debian based rather than Alpine based.

Hmmm, maybe double check where the PostgreSQL you're running the ldd is from? My first guess is it's just a simple cut-n-paste typo or similar simple mix up in the image tag you're using?

Well, hopefully it does turn out to be that simple. 😁

[einarwar]

It seems like the timescaleDB image is alpine. This might maybe cause the issues? Output from cat /etc/os-release when trying to only build with FROM docker.io/timescale/timescaledb:latest-pg16:

/ # cat /etc/os-release 
NAME="Alpine Linux"
ID=alpine
VERSION_ID=3.20.2
PRETTY_NAME="Alpine Linux v3.20"
HOME_URL="https://alpinelinux.org/"
BUG_REPORT_URL="https://gitlab.alpinelinux.org/alpine/aports/-/issues"

[justinclift]

This might maybe cause the issues?

Yeah, that might be the thing.

Maybe try using the timescaledb (alpine based) image with one of the alpine based pgautoupgrade images. i.e. pgautoupgrade/pgautoupgrade:latest, and see if the behaviour changes?

[einarwar]

Testing with docker.io/pgautoupgrade/pgautoupgrade:16-alpine seems to solve the issue. This introduces some difficulties as some existing systems would need to go from a debian-based image to an alpine-based image. But that is not in the hands of pgautoupgrade, i guess timescaledb would need to have a debian-based alternative.

I don't know if you have in-depth knowledge of how to modify the example to work with timescaledb. I'll try to reverse-engineer the steps taken and files modified in the timescaledb-image. If I get it to work, I can maybe provide an example that could be added to the wiki if that would be interesting :)

[justinclift]

Interesting. Yeah, if you get that written up on the wiki then that'd be potentially useful for people. It's good to have more (coherent) docs than less. 😁

[zN3utr4l]

it doesn't work anyway, even with alpine. @einarwar, @justinclift

docker build -f .\TimeScaleDB\Dockerfile.pgautoupgrade -t pgautoupgrade:pg14-to-pg15 . ; docker run --rm -it -v timescale_data:/var/lib/postgresql/data -e PGAUTO_ONESHOT=yes pgautoupgrade:pg14-to-pg15

FROM timescale/timescaledb:latest-pg15 AS pg15
FROM pgautoupgrade/pgautoupgrade:15-alpine3.22 AS pgautoupgrade

RUN cp /usr/local/bin/docker-entrypoint.sh /docker-entrypoint.sh

COPY --from=pg15 /usr/lib /usr/lib
COPY --from=pg15 /usr/local /usr/local

ENV PGTARGET=15 PGDATA=/var/lib/postgresql/data

WORKDIR /var/lib/postgresql

ENTRYPOINT ["/docker-entrypoint.sh"]
CMD ["postgres"]

PG 14 to PG 15

PostgreSQL Database directory appears to contain a database; Skipping initialization

************************************
PostgreSQL data directory: /var/lib/postgresql/data
************************************
Creating upgrade lock file at /var/lib/postgresql/data/upgrade_in_progress.lock
*******************************************************************************************
Performing PG upgrade on version 14 database files.  Upgrading to version 15
*******************************************************************************************
----------------------------------------------------------------------
Checking for left over artifacts from a failed previous autoupgrade...
----------------------------------------------------------------------
-------------------------------------------------------------------------------
No artifacts found from a failed previous autoupgrade.  Continuing the process.
-------------------------------------------------------------------------------
---------------------------------------
Creating OLD temporary directory /var/lib/postgresql/data/old
---------------------------------------
--------------------------------------------
Creating OLD temporary directory is complete
--------------------------------------------
-------------------------------------------------------
Moving existing data files into OLD temporary directory
-------------------------------------------------------
'/var/lib/postgresql/data/PG_VERSION' -> '/var/lib/postgresql/data/old/PG_VERSION'
'/var/lib/postgresql/data/base' -> '/var/lib/postgresql/data/old/base'
'/var/lib/postgresql/data/current_logfiles' -> '/var/lib/postgresql/data/old/current_logfiles'
'/var/lib/postgresql/data/global' -> '/var/lib/postgresql/data/old/global'
'/var/lib/postgresql/data/log' -> '/var/lib/postgresql/data/old/log'
mv: can't rename '/var/lib/postgresql/data/old': Invalid argument
'/var/lib/postgresql/data/old' -> '/var/lib/postgresql/data/old/old'
'/var/lib/postgresql/data/pg_commit_ts' -> '/var/lib/postgresql/data/old/pg_commit_ts'
'/var/lib/postgresql/data/pg_dynshmem' -> '/var/lib/postgresql/data/old/pg_dynshmem'
'/var/lib/postgresql/data/pg_hba.conf' -> '/var/lib/postgresql/data/old/pg_hba.conf'
'/var/lib/postgresql/data/pg_ident.conf' -> '/var/lib/postgresql/data/old/pg_ident.conf'
'/var/lib/postgresql/data/pg_logical' -> '/var/lib/postgresql/data/old/pg_logical'
'/var/lib/postgresql/data/pg_multixact' -> '/var/lib/postgresql/data/old/pg_multixact'
'/var/lib/postgresql/data/pg_notify' -> '/var/lib/postgresql/data/old/pg_notify'
'/var/lib/postgresql/data/pg_replslot' -> '/var/lib/postgresql/data/old/pg_replslot'
'/var/lib/postgresql/data/pg_serial' -> '/var/lib/postgresql/data/old/pg_serial'
'/var/lib/postgresql/data/pg_snapshots' -> '/var/lib/postgresql/data/old/pg_snapshots'
'/var/lib/postgresql/data/pg_stat' -> '/var/lib/postgresql/data/old/pg_stat'
'/var/lib/postgresql/data/pg_stat_tmp' -> '/var/lib/postgresql/data/old/pg_stat_tmp'
'/var/lib/postgresql/data/pg_subtrans' -> '/var/lib/postgresql/data/old/pg_subtrans'
'/var/lib/postgresql/data/pg_tblspc' -> '/var/lib/postgresql/data/old/pg_tblspc'
'/var/lib/postgresql/data/pg_twophase' -> '/var/lib/postgresql/data/old/pg_twophase'
'/var/lib/postgresql/data/pg_wal' -> '/var/lib/postgresql/data/old/pg_wal'
'/var/lib/postgresql/data/pg_xact' -> '/var/lib/postgresql/data/old/pg_xact'
'/var/lib/postgresql/data/postgresql.auto.conf' -> '/var/lib/postgresql/data/old/postgresql.auto.conf'
'/var/lib/postgresql/data/postgresql.conf' -> '/var/lib/postgresql/data/old/postgresql.conf'
'/var/lib/postgresql/data/postmaster.opts' -> '/var/lib/postgresql/data/old/postmaster.opts'
'/var/lib/postgresql/data/postmaster.pid' -> '/var/lib/postgresql/data/old/postmaster.pid'
'/var/lib/postgresql/data/upgrade_in_progress.lock' -> '/var/lib/postgresql/data/old/upgrade_in_progress.lock'
-------------------------------------------------------------------
Moving existing data files into OLD temporary directory is complete
-------------------------------------------------------------------
---------------------------------------
Creating NEW temporary directory /var/lib/postgresql/data/new
---------------------------------------
--------------------------------------------
Creating NEW temporary directory is complete
--------------------------------------------
-----------------------------------------------------
Changing permissions of temporary directories to 0700
-----------------------------------------------------
---------------------------------------------------------
Changing permissions of temporary directories is complete
---------------------------------------------------------
-------------------------------------------------
Remove postmaster.pid file from PG data directory
-------------------------------------------------
------------------------------------
Determining our own initdb arguments
------------------------------------
2025-06-24 09:11:12.429 UTC [41] LOG:  database system was interrupted; last known up at 2025-06-24 08:19:24 UTC
2025-06-24 09:11:13.152 UTC [41] LOG:  database system was not properly shut down; automatic recovery in progress
2025-06-24 09:11:13.155 UTC [41] LOG:  redo starts at 25/87AA07C8
2025-06-24 09:11:13.163 UTC [41] LOG:  invalid record length at 25/87ACADD0: wanted 24, got 0
2025-06-24 09:11:13.163 UTC [41] LOG:  redo done at 25/87ACAD98 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
---------------------------------------------------------------
The initdb arguments we determined are: --locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8
---------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------
Old database using collation settings: '--locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8'.  Initialising new database with those settings too
--------------------------------------------------------------------------------------------------------------------
Initialising PostgreSQL 15 data directory
Error loading shared library libssl.so.3: No such file or directory (needed by /usr/local/lib/libpq.so.5)
Error loading shared library libcrypto.so.3: No such file or directory (needed by /usr/local/lib/libpq.so.5)
Error loading shared library libssl.so.3: No such file or directory (needed by /usr/lib/libldap.so.2)
Error loading shared library libcrypto.so.3: No such file or directory (needed by /usr/lib/libldap.so.2)
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_get_ctrl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_get1_peer_certificate: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_use_certificate_chain_file: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ASN1_STRING_get0_data: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ASN1_STRING_length: symbol not found
Error relocating /usr/local/lib/libpq.so.5: OPENSSL_init_ssl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_sha224: symbol not found
Error relocating /usr/local/lib/libpq.so.5: TLS_method: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_use_PrivateKey_file: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_pending: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ERR_reason_error_string: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_get_gets: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_new: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_get_digestbyname: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_sha512: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_shutdown: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_NAME_ENTRY_get_data: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_STORE_load_locations: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_set_default_passwd_cb: symbol not found
Error relocating /usr/local/lib/libpq.so.5: OPENSSL_sk_pop_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_clear_options: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_get_signature_info: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_set_flags: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: OBJ_nid2sn: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_sha256: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ENGINE_init: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_new: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_set_verify: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ERR_set_error: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_clear_flags: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_MD_CTX_new: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_destroy: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_get_destroy: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ERR_new: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_NAME_get_entry: symbol not found
Error relocating /usr/local/lib/libpq.so.5: OPENSSL_sk_num: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_puts: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_use_PrivateKey: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_sha1: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_ctrl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_get_puts: symbol not found
Error relocating /usr/local/lib/libpq.so.5: OPENSSL_sk_value: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_set_default_passwd_cb_userdata: symbol not found
Error relocating /usr/local/lib/libpq.so.5: RAND_poll: symbol not found
Error relocating /usr/local/lib/libpq.so.5: HMAC_Update: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_create: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_set_options: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_read: symbol not found
Error relocating /usr/local/lib/libpq.so.5: HMAC_Final: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_get_error: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_digest: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_ctrl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_DigestUpdate: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_set_options: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_set_bio: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ENGINE_finish: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_md5: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_NAME_get_index_by_NID: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ERR_set_debug: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_get_ext_d2i: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_STORE_set_flags: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_new: symbol not found
Error relocating /usr/local/lib/libpq.so.5: HMAC_Init_ex: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_write: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_get_subject_name: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_get_create: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_get_current_compression: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_get_callback_ctrl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: HMAC_CTX_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_MD_CTX_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ENGINE_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_get_ex_data: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_gets: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_get_cert_store: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_connect: symbol not found
Error relocating /usr/local/lib/libpq.so.5: RAND_bytes: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_get_new_index: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_new: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_write: symbol not found
Error relocating /usr/local/lib/libpq.so.5: X509_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CIPHER_get_name: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_free: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_load_verify_locations: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ERR_clear_error: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_DigestInit_ex: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_read: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_set_ex_data: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_int_ctrl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_get_version: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_meth_set_callback_ctrl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: RAND_status: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ENGINE_load_private_key: symbol not found
Error relocating /usr/local/lib/libpq.so.5: BIO_s_socket: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CIPHER_get_bits: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_sha384: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_check_private_key: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_CTX_ctrl: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_set_ex_data: symbol not found
Error relocating /usr/local/lib/libpq.so.5: HMAC_CTX_new: symbol not found
Error relocating /usr/local/lib/libpq.so.5: EVP_DigestFinal_ex: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ERR_get_error: symbol not found
Error relocating /usr/local/lib/libpq.so.5: SSL_get_current_cipher: symbol not found
Error relocating /usr/local/lib/libpq.so.5: ENGINE_by_id: symbol not found
Error relocating /usr/local/lib/libpq.so.5: GENERAL_NAME_free: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_alert_type_string_long: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get1_peer_certificate: symbol not found
Error relocating /usr/lib/libldap.so.2: d2i_X509: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_cipher_list: symbol not found
Error relocating /usr/lib/libldap.so.2: PEM_read_bio_Parameters: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_use_certificate_chain_file: symbol not found
Error relocating /usr/lib/libldap.so.2: ASN1_STRING_get0_data: symbol not found
Error relocating /usr/lib/libldap.so.2: ASN1_STRING_length: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_session_id_context: symbol not found
Error relocating /usr/lib/libldap.so.2: OPENSSL_init_ssl: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_finished: symbol not found
Error relocating /usr/lib/libldap.so.2: GENERAL_NAMES_free: symbol not found
Error relocating /usr/lib/libldap.so.2: TLS_method: symbol not found
Error relocating /usr/lib/libldap.so.2: OPENSSL_sk_new_null: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_up_ref: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_free: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_pending: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_new: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_verify: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_get_digestbyname: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_shutdown: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_md4: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_NAME_ENTRY_get_data: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_ciphersuites: symbol not found
Error relocating /usr/lib/libldap.so.2: OBJ_nid2obj: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_default_verify_paths: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set0_tmp_dh_pkey: symbol not found
Error relocating /usr/lib/libldap.so.2: ERR_error_string_n: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_LOOKUP_hash_dir: symbol not found
Error relocating /usr/lib/libldap.so.2: X509V3_add_standard_extensions: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_set_flags: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_free: symbol not found
Error relocating /usr/lib/libldap.so.2: OBJ_nid2sn: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_peer_finished: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_sha256: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_new: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_set_data: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_clear_flags: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_MD_CTX_new: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_PKEY_free: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_set_destroy: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_set_init: symbol not found
Error relocating /usr/lib/libldap.so.2: OBJ_find_sigid_algs: symbol not found
Error relocating /usr/lib/libldap.so.2: CRYPTO_free: symbol not found
Error relocating /usr/lib/libldap.so.2: OBJ_cmp: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_NAME_get_entry: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_use_certificate: symbol not found
Error relocating /usr/lib/libldap.so.2: OPENSSL_sk_num: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_set_puts: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_use_PrivateKey: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_sha1: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_ctrl: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_STORE_add_cert: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_STORE_CTX_get_current_cert: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_info_callback: symbol not found
Error relocating /usr/lib/libldap.so.2: d2i_AutoPrivateKey: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_ciphers: symbol not found
Error relocating /usr/lib/libldap.so.2: OPENSSL_sk_value: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_NAME_ENTRY_get_object: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_add_dir_cert_subjects_to_stack: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_set_create: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_options: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_set_read: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_new_file: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_error: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_digest: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_set_ctrl: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_DigestUpdate: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_verify_cert_error_string: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_set_bio: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_md5: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_alert_desc_string_long: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_STORE_set_flags: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_session_reused: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_new: symbol not found
Error relocating /usr/lib/libldap.so.2: X509V3_EXT_d2i: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_get_ext: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_set_write: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_get_subject_name: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_set_ciphersuites: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_verify_result: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_MD_CTX_free: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_get_ext_by_NID: symbol not found
Error relocating /usr/lib/libldap.so.2: ERR_peek_error: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_NAME_dup: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_set_gets: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_STORE_add_lookup: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_get_cert_store: symbol not found
Error relocating /usr/lib/libldap.so.2: ERR_get_error_all: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_connect: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_accept: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_new: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_write: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_free: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CIPHER_get_name: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_meth_free: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_get_signature_nid: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_load_verify_locations: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_NAME_oneline: symbol not found
Error relocating /usr/lib/libldap.so.2: i2d_X509_PUBKEY: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_get_issuer_name: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_LOOKUP_ctrl: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CIPHER_get_version: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_DigestInit_ex: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_md_null: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_NAME_get0_der: symbol not found
Error relocating /usr/lib/libldap.so.2: OPENSSL_sk_free: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_read: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_free: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_certificate: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_NAME_entry_count: symbol not found
Error relocating /usr/lib/libldap.so.2: i2d_X509: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_version: symbol not found
Error relocating /usr/lib/libldap.so.2: OPENSSL_sk_push: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_set_client_CA_list: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_clear_options: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_use_PrivateKey_file: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CIPHER_get_bits: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_get_X509_PUBKEY: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_CTX_ctrl: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_set_cipher_list: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_STORE_CTX_get_error: symbol not found
Error relocating /usr/lib/libldap.so.2: BIO_get_data: symbol not found
Error relocating /usr/lib/libldap.so.2: EVP_DigestFinal_ex: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_get_current_cipher: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_load_client_CA_file: symbol not found
Error relocating /usr/lib/libldap.so.2: X509_STORE_CTX_get_error_depth: symbol not found
Error relocating /usr/lib/libldap.so.2: SSL_state_string_long: symbol not found

PG 14 to PG 16

PostgreSQL Database directory appears to contain a database; Skipping initialization

************************************
PostgreSQL data directory: /var/lib/postgresql/data
************************************
Creating upgrade lock file at /var/lib/postgresql/data/upgrade_in_progress.lock
*******************************************************************************************
Performing PG upgrade on version 14 database files.  Upgrading to version 16
*******************************************************************************************
----------------------------------------------------------------------
Checking for left over artifacts from a failed previous autoupgrade...
----------------------------------------------------------------------
-------------------------------------------------------------------------------
No artifacts found from a failed previous autoupgrade.  Continuing the process.
-------------------------------------------------------------------------------
---------------------------------------
Creating OLD temporary directory /var/lib/postgresql/data/old
---------------------------------------
--------------------------------------------
Creating OLD temporary directory is complete
--------------------------------------------
-------------------------------------------------------
Moving existing data files into OLD temporary directory
-------------------------------------------------------
'/var/lib/postgresql/data/PG_VERSION' -> '/var/lib/postgresql/data/old/PG_VERSION'
'/var/lib/postgresql/data/base' -> '/var/lib/postgresql/data/old/base'
'/var/lib/postgresql/data/current_logfiles' -> '/var/lib/postgresql/data/old/current_logfiles'
'/var/lib/postgresql/data/global' -> '/var/lib/postgresql/data/old/global'
'/var/lib/postgresql/data/log' -> '/var/lib/postgresql/data/old/log'
mv: can't rename '/var/lib/postgresql/data/old': Invalid argument
'/var/lib/postgresql/data/old' -> '/var/lib/postgresql/data/old/old'
'/var/lib/postgresql/data/pg_commit_ts' -> '/var/lib/postgresql/data/old/pg_commit_ts'
'/var/lib/postgresql/data/pg_dynshmem' -> '/var/lib/postgresql/data/old/pg_dynshmem'
'/var/lib/postgresql/data/pg_hba.conf' -> '/var/lib/postgresql/data/old/pg_hba.conf'
'/var/lib/postgresql/data/pg_ident.conf' -> '/var/lib/postgresql/data/old/pg_ident.conf'
'/var/lib/postgresql/data/pg_logical' -> '/var/lib/postgresql/data/old/pg_logical'
'/var/lib/postgresql/data/pg_multixact' -> '/var/lib/postgresql/data/old/pg_multixact'
'/var/lib/postgresql/data/pg_notify' -> '/var/lib/postgresql/data/old/pg_notify'
'/var/lib/postgresql/data/pg_replslot' -> '/var/lib/postgresql/data/old/pg_replslot'
'/var/lib/postgresql/data/pg_serial' -> '/var/lib/postgresql/data/old/pg_serial'
'/var/lib/postgresql/data/pg_snapshots' -> '/var/lib/postgresql/data/old/pg_snapshots'
'/var/lib/postgresql/data/pg_stat' -> '/var/lib/postgresql/data/old/pg_stat'
'/var/lib/postgresql/data/pg_stat_tmp' -> '/var/lib/postgresql/data/old/pg_stat_tmp'
'/var/lib/postgresql/data/pg_subtrans' -> '/var/lib/postgresql/data/old/pg_subtrans'
'/var/lib/postgresql/data/pg_tblspc' -> '/var/lib/postgresql/data/old/pg_tblspc'
'/var/lib/postgresql/data/pg_twophase' -> '/var/lib/postgresql/data/old/pg_twophase'
'/var/lib/postgresql/data/pg_wal' -> '/var/lib/postgresql/data/old/pg_wal'
'/var/lib/postgresql/data/pg_xact' -> '/var/lib/postgresql/data/old/pg_xact'
'/var/lib/postgresql/data/postgresql.auto.conf' -> '/var/lib/postgresql/data/old/postgresql.auto.conf'
'/var/lib/postgresql/data/postgresql.conf' -> '/var/lib/postgresql/data/old/postgresql.conf'
'/var/lib/postgresql/data/postmaster.opts' -> '/var/lib/postgresql/data/old/postmaster.opts'
'/var/lib/postgresql/data/postmaster.pid' -> '/var/lib/postgresql/data/old/postmaster.pid'
'/var/lib/postgresql/data/upgrade_in_progress.lock' -> '/var/lib/postgresql/data/old/upgrade_in_progress.lock'
-------------------------------------------------------------------
Moving existing data files into OLD temporary directory is complete
-------------------------------------------------------------------
---------------------------------------
Creating NEW temporary directory /var/lib/postgresql/data/new
---------------------------------------
--------------------------------------------
Creating NEW temporary directory is complete
--------------------------------------------
-----------------------------------------------------
Changing permissions of temporary directories to 0700
-----------------------------------------------------
---------------------------------------------------------
Changing permissions of temporary directories is complete
---------------------------------------------------------
-------------------------------------------------
Remove postmaster.pid file from PG data directory
-------------------------------------------------
------------------------------------
Determining our own initdb arguments
------------------------------------
2025-06-24 09:14:25.102 UTC [41] LOG:  database system was interrupted; last known up at 2025-06-24 08:19:24 UTC
2025-06-24 09:14:25.866 UTC [41] LOG:  database system was not properly shut down; automatic recovery in progress
2025-06-24 09:14:25.869 UTC [41] LOG:  redo starts at 25/87AA07C8
2025-06-24 09:14:25.881 UTC [41] LOG:  invalid record length at 25/87ACADD0: wanted 24, got 0
2025-06-24 09:14:25.881 UTC [41] LOG:  redo done at 25/87ACAD98 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s
---------------------------------------------------------------
The initdb arguments we determined are: --locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8
---------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------
Old database using collation settings: '--locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8'.  Initialising new database with those settings too
--------------------------------------------------------------------------------------------------------------------
Initialising PostgreSQL 16 data directory
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data/new ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... 2025-06-24 09:14:26.691 UTC [60] FATAL:  could not open collator for locale "und": U_FILE_ACCESS_ERROR
2025-06-24 09:14:26.691 UTC [60] STATEMENT:  UPDATE pg_collation SET collversion = pg_collation_actual_version(oid) WHERE collname = 'unicode';

child process exited with exit code 1
initdb: removing contents of data directory "/var/lib/postgresql/data/new"

PG 14 to PG 17

PostgreSQL Database directory appears to contain a database; Skipping initialization

************************************
PostgreSQL data directory: /var/lib/postgresql/data
************************************
Creating upgrade lock file at /var/lib/postgresql/data/upgrade_in_progress.lock
*******************************************************************************************
Performing PG upgrade on version 14 database files.  Upgrading to version 17
*******************************************************************************************
----------------------------------------------------------------------
Checking for left over artifacts from a failed previous autoupgrade...
----------------------------------------------------------------------
-------------------------------------------------------------------------------
No artifacts found from a failed previous autoupgrade.  Continuing the process.
-------------------------------------------------------------------------------
---------------------------------------
Creating OLD temporary directory /var/lib/postgresql/data/old
---------------------------------------
--------------------------------------------
Creating OLD temporary directory is complete
--------------------------------------------
-------------------------------------------------------
Moving existing data files into OLD temporary directory
-------------------------------------------------------
'/var/lib/postgresql/data/PG_VERSION' -> '/var/lib/postgresql/data/old/PG_VERSION'
'/var/lib/postgresql/data/base' -> '/var/lib/postgresql/data/old/base'
'/var/lib/postgresql/data/current_logfiles' -> '/var/lib/postgresql/data/old/current_logfiles'
'/var/lib/postgresql/data/global' -> '/var/lib/postgresql/data/old/global'
'/var/lib/postgresql/data/log' -> '/var/lib/postgresql/data/old/log'
mv: can't rename '/var/lib/postgresql/data/old': Invalid argument
'/var/lib/postgresql/data/old' -> '/var/lib/postgresql/data/old/old'
'/var/lib/postgresql/data/pg_commit_ts' -> '/var/lib/postgresql/data/old/pg_commit_ts'
'/var/lib/postgresql/data/pg_dynshmem' -> '/var/lib/postgresql/data/old/pg_dynshmem'
'/var/lib/postgresql/data/pg_hba.conf' -> '/var/lib/postgresql/data/old/pg_hba.conf'
'/var/lib/postgresql/data/pg_ident.conf' -> '/var/lib/postgresql/data/old/pg_ident.conf'
'/var/lib/postgresql/data/pg_logical' -> '/var/lib/postgresql/data/old/pg_logical'
'/var/lib/postgresql/data/pg_multixact' -> '/var/lib/postgresql/data/old/pg_multixact'
'/var/lib/postgresql/data/pg_notify' -> '/var/lib/postgresql/data/old/pg_notify'
'/var/lib/postgresql/data/pg_replslot' -> '/var/lib/postgresql/data/old/pg_replslot'
'/var/lib/postgresql/data/pg_serial' -> '/var/lib/postgresql/data/old/pg_serial'
'/var/lib/postgresql/data/pg_snapshots' -> '/var/lib/postgresql/data/old/pg_snapshots'
'/var/lib/postgresql/data/pg_stat' -> '/var/lib/postgresql/data/old/pg_stat'
'/var/lib/postgresql/data/pg_stat_tmp' -> '/var/lib/postgresql/data/old/pg_stat_tmp'
'/var/lib/postgresql/data/pg_subtrans' -> '/var/lib/postgresql/data/old/pg_subtrans'
'/var/lib/postgresql/data/pg_tblspc' -> '/var/lib/postgresql/data/old/pg_tblspc'
'/var/lib/postgresql/data/pg_twophase' -> '/var/lib/postgresql/data/old/pg_twophase'
'/var/lib/postgresql/data/pg_wal' -> '/var/lib/postgresql/data/old/pg_wal'
'/var/lib/postgresql/data/pg_xact' -> '/var/lib/postgresql/data/old/pg_xact'
'/var/lib/postgresql/data/postgresql.auto.conf' -> '/var/lib/postgresql/data/old/postgresql.auto.conf'
'/var/lib/postgresql/data/postgresql.conf' -> '/var/lib/postgresql/data/old/postgresql.conf'
'/var/lib/postgresql/data/postmaster.opts' -> '/var/lib/postgresql/data/old/postmaster.opts'
'/var/lib/postgresql/data/postmaster.pid' -> '/var/lib/postgresql/data/old/postmaster.pid'
'/var/lib/postgresql/data/upgrade_in_progress.lock' -> '/var/lib/postgresql/data/old/upgrade_in_progress.lock'
-------------------------------------------------------------------
Moving existing data files into OLD temporary directory is complete
-------------------------------------------------------------------
---------------------------------------
Creating NEW temporary directory /var/lib/postgresql/data/new
---------------------------------------
--------------------------------------------
Creating NEW temporary directory is complete
--------------------------------------------
-----------------------------------------------------
Changing permissions of temporary directories to 0700
-----------------------------------------------------
---------------------------------------------------------
Changing permissions of temporary directories is complete
---------------------------------------------------------
-------------------------------------------------
Remove postmaster.pid file from PG data directory
-------------------------------------------------
------------------------------------
Determining our own initdb arguments
------------------------------------
2025-06-24 09:15:30.756 UTC [41] LOG:  database system was interrupted; last known up at 2025-06-24 08:19:24 UTC
2025-06-24 09:15:31.545 UTC [41] LOG:  database system was not properly shut down; automatic recovery in progress
2025-06-24 09:15:31.561 UTC [41] LOG:  redo starts at 25/87AA07C8
2025-06-24 09:15:31.576 UTC [41] LOG:  invalid record length at 25/87ACADD0: wanted 24, got 0
2025-06-24 09:15:31.576 UTC [41] LOG:  redo done at 25/87ACAD98 system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.01 s
---------------------------------------------------------------
The initdb arguments we determined are: --locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8
---------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------
Old database using collation settings: '--locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8'.  Initialising new database with those settings too
--------------------------------------------------------------------------------------------------------------------
Initialising PostgreSQL 17 data directory
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data/new ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... 2025-06-24 09:15:32.476 UTC [60] FATAL:  could not open collator for locale "und": U_FILE_ACCESS_ERROR
2025-06-24 09:15:32.476 UTC [60] STATEMENT:  UPDATE pg_collation SET collversion = pg_collation_actual_version(oid) WHERE collname = 'unicode';

child process exited with exit code 1
initdb: removing contents of data directory "/var/lib/postgresql/data/new"