# Running: initdb --help [10:25:18.060](0.028s) ok 1 - initdb --help exit code 0 [10:25:18.061](0.000s) ok 2 - initdb --help goes to stdout [10:25:18.061](0.000s) ok 3 - initdb --help nothing to stderr [10:25:18.061](0.000s) ok 4 - initdb --help maximum line length # Running: initdb --version [10:25:18.070](0.008s) ok 5 - initdb --version exit code 0 [10:25:18.070](0.000s) ok 6 - initdb --version goes to stdout [10:25:18.070](0.000s) ok 7 - initdb --version nothing to stderr # Running: initdb --not-a-valid-option [10:25:18.078](0.008s) ok 8 - initdb with invalid option nonzero exit code [10:25:18.079](0.000s) ok 9 - initdb with invalid option prints error message # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/nonexistent initdb: error: could not access directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/nonexistent": No such file or directory [10:25:18.094](0.015s) ok 10 - sync missing data directory # Running: initdb -X /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data 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 this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data ... ok initdb: error: directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/pgxlog" exists but is not empty initdb: detail: It contains a lost+found directory, perhaps due to it being a mount point. initdb: hint: Using a mount point directly as the data directory is not recommended. Create a subdirectory under the mount point. initdb: removing data directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data" [10:25:18.130](0.036s) ok 11 - existing nonempty xlog directory # Running: initdb -X pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data 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 this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data ... ok initdb: error: WAL directory location must be an absolute path initdb: removing data directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data" [10:25:18.165](0.036s) ok 12 - relative xlog directory not allowed # Running: initdb -U pg_test /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data initdb: error: superuser name "pg_test" is disallowed; role names cannot begin with "pg_" [10:25:18.201](0.036s) ok 13 - role names cannot begin with "pg_" # Running: initdb -N -T german -c default_text_search_config=german -X /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data 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 this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". initdb: warning: specified text search configuration "german" might not match locale "en_US.UTF-8" The default text search configuration will be set to "german". Data page checksums are disabled. fixing permissions on existing directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data ... ok fixing permissions on existing directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/pgxlog ... 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 ... 2024-03-29 10:25:18.596 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.859 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.862 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.864 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.865 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.867 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.867 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.868 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.869 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.869 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.870 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:18.983 UTC [33135] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data -l logfile start [10:25:19.365](1.164s) ok 14 - successful creation [10:25:19.379](0.013s) ok 15 - check PGDATA permissions # Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data [10:25:19.384](0.005s) ok 16 - checksums are disabled in control file: exit code 0 [10:25:19.385](0.001s) ok 17 - checksums are disabled in control file: no stderr [10:25:19.385](0.000s) ok 18 - checksums are disabled in control file: matches # Running: pg_checksums -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data pg_checksums: error: data checksums are not enabled in cluster [10:25:19.399](0.014s) ok 19 - pg_checksums fails with data checksum disabled # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data syncing data to disk ... ok [10:25:19.476](0.076s) ok 20 - sync only # Running: initdb /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data 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 this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. initdb: error: directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data" exists but is not empty initdb: hint: If you want to create a new database system, either remove or empty the directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data" or run initdb with an argument other than "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data". [10:25:19.490](0.014s) ok 21 - existing data directory # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data --sync-method syncfs initdb: error: this build does not support sync method "syncfs" [10:25:19.504](0.014s) ok 22 - sync method syncfs # Running: initdb -g /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data_group 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 this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data_group ... 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 ... 2024-03-29 10:25:19.882 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.146 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.150 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.152 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.153 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.155 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.156 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.156 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.157 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.158 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.158 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:20.273 UTC [33329] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data_group -l logfile start [10:25:20.675](1.171s) ok 23 - successful creation with group access [10:25:20.688](0.012s) ok 24 - check PGDATA permissions # Running: initdb --no-sync --locale-provider=icu /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data2 [10:25:20.702](0.015s) ok 25 - locale provider ICU requires --icu-locale: exit code not 0 [10:25:20.703](0.001s) ok 26 - locale provider ICU requires --icu-locale: matches # Running: initdb --no-sync --locale-provider=icu --icu-locale=en /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data3 The files belonging to this database system will be owned by user "postgres". This user must also own the server process. Using language tag "en" for ICU locale "en". The database cluster will be initialized with this locale configuration: locale provider: icu default collation: en LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data3 ... 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 ... 2024-03-29 10:25:21.078 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.343 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.346 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.348 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.349 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.351 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.352 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.352 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.353 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.354 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.355 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:21.465 UTC [33537] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data3 -l logfile start [10:25:21.866](1.163s) ok 27 - option --icu-locale # Running: initdb --no-sync -A trust --locale-provider=icu --locale=und --lc-collate=C --lc-ctype=C --lc-messages=C --lc-numeric=C --lc-monetary=C --lc-time=C /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data4 [10:25:22.837](0.972s) ok 28 - options --locale-provider=icu --locale=und --lc-*=C: exit code 0 [10:25:22.838](0.000s) not ok 29 - options --locale-provider=icu --locale=und --lc-*=C: no stderr [10:25:22.838](0.000s) # Failed test 'options --locale-provider=icu --locale=und --lc-*=C: no stderr' # at /tmp/cirrus-ci-build/src/bin/initdb/t/001_initdb.pl line 131. [10:25:22.838](0.000s) # got: '2024-03-29 10:25:22.253 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.510 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.513 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.514 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.516 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.518 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.519 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.519 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.520 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.521 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.522 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-29 10:25:22.633 UTC [33747] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # ' # expected: '' [10:25:22.838](0.000s) ok 30 - options --locale-provider=icu --locale=und --lc-*=C: matches # Running: initdb --no-sync --locale-provider=icu --icu-locale=@colNumeric=lower /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX [10:25:23.545](0.707s) ok 31 - fails for invalid ICU locale: exit code not 0 [10:25:23.547](0.002s) ok 32 - fails for invalid ICU locale: matches # Running: initdb --no-sync --locale-provider=icu --encoding=SQL_ASCII --icu-locale=en /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX [10:25:23.560](0.013s) ok 33 - fails for encoding not supported by ICU: exit code not 0 [10:25:23.560](0.001s) ok 34 - fails for encoding not supported by ICU: matches # Running: initdb --no-sync --locale-provider=icu --icu-locale=nonsense-nowhere /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX [10:25:23.576](0.016s) ok 35 - fails for nonsense language: exit code not 0 [10:25:23.576](0.000s) ok 36 - fails for nonsense language: matches # Running: initdb --no-sync --locale-provider=icu --icu-locale=@colNumeric=lower /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX [10:25:23.783](0.207s) ok 37 - fails for invalid collation argument: exit code not 0 [10:25:23.784](0.001s) ok 38 - fails for invalid collation argument: matches # Running: initdb --no-sync --locale-provider=builtin /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data6 The files belonging to this database system will be owned by user "postgres". This user must also own the server process. initdb: error: locale must be specified if provider is builtin [10:25:23.798](0.014s) ok 39 - locale provider builtin fails without --locale # Running: initdb --no-sync --locale-provider=builtin --locale=C /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data7 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 this locale configuration: locale provider: builtin default collation: C LC_COLLATE: C LC_CTYPE: C LC_MESSAGES: C LC_MONETARY: C LC_NUMERIC: C LC_TIME: C The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data7 ... 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 ... 2024-03-29 10:25:24.170 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.428 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.431 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.433 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.435 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.436 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.437 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.437 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.438 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.439 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.440 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:24.552 UTC [34023] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data7 -l logfile start [10:25:24.965](1.167s) ok 40 - locale provider builtin with --locale # Running: initdb --no-sync --locale-provider=builtin -E UTF-8 --builtin-locale=C.UTF-8 /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data8 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 this locale configuration: locale provider: builtin default collation: C.UTF-8 LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data8 ... 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 ... 2024-03-29 10:25:25.334 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.592 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.595 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.597 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.598 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.599 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.600 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.601 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.602 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.602 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.603 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:25.715 UTC [34181] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data8 -l logfile start [10:25:26.166](1.201s) ok 41 - locale provider builtin with -E UTF-8 --builtin-locale=C.UTF-8 # Running: initdb --no-sync --locale-provider=builtin -E SQL_ASCII --builtin-locale=C.UTF-8 /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data9 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 this locale configuration: locale provider: builtin default collation: C.UTF-8 LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 initdb: error: builtin provider locale "C.UTF-8" requires encoding "UTF-8" [10:25:26.180](0.013s) ok 42 - locale provider builtin with --builtin-locale=C.UTF-8 fails for SQL_ASCII # Running: initdb --no-sync --locale-provider=builtin --lc-ctype=C --locale=C /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data10 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 this locale configuration: locale provider: builtin default collation: C LC_COLLATE: C LC_CTYPE: C LC_MESSAGES: C LC_MONETARY: C LC_NUMERIC: C LC_TIME: C The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data10 ... 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 ... 2024-03-29 10:25:26.538 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.797 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.801 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.803 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.804 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.806 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.806 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.807 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.808 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.808 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.809 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:26.924 UTC [34362] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/data10 -l logfile start [10:25:27.356](1.177s) ok 43 - locale provider builtin with --lc-ctype # Running: initdb --no-sync --locale-provider=builtin --icu-locale=en /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [10:25:27.370](0.014s) ok 44 - fails for locale provider builtin with ICU locale # Running: initdb --no-sync --locale-provider=builtin --icu-rules="" /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX initdb: error: --icu-rules cannot be specified unless locale provider "icu" is chosen [10:25:27.383](0.013s) ok 45 - fails for locale provider builtin with ICU rules # Running: initdb --no-sync --locale-provider=xyz /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX initdb: error: unrecognized locale provider: xyz [10:25:27.397](0.013s) ok 46 - fails for invalid locale provider # Running: initdb --no-sync --locale-provider=libc --icu-locale=en /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [10:25:27.410](0.013s) ok 47 - fails for invalid option combination # Running: initdb --no-sync --set foo=bar /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX 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 this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 20 selecting default shared_buffers ... 400kB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... 2024-03-29 10:25:27.571 GMT [34561] LOG: unrecognized configuration parameter "foo" in file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX/postgresql.conf" line 841 2024-03-29 10:25:27.571 GMT [34561] FATAL: configuration file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX/postgresql.conf" contains errors child process exited with exit code 1 initdb: removing data directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataX" [10:25:27.737](0.327s) ok 48 - fails for invalid --set option # Running: initdb -cwork_mem=128 -cWork_Mem=256 -cWORK_MEM=512 /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataY 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 this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataY ... 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 ... 2024-03-29 10:25:28.115 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.380 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.384 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.385 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.387 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.388 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.389 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.390 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.391 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.391 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.392 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-29 10:25:28.509 UTC [34614] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_lsTQ/dataY -l logfile start [10:25:28.905](1.168s) ok 49 - multiple -c options with different case [10:25:28.906](0.000s) ok 50 - WORK_MEM should not be configured [10:25:28.906](0.000s) ok 51 - Work_Mem should not be configured [10:25:28.906](0.000s) ok 52 - work_mem should be in config [10:25:28.906](0.000s) 1..52 [10:25:28.907](0.001s) # Looks like you failed 1 test of 52.