# Running: initdb --help [16:48:19.583](0.021s) ok 1 - initdb --help exit code 0 [16:48:19.584](0.000s) ok 2 - initdb --help goes to stdout [16:48:19.584](0.000s) ok 3 - initdb --help nothing to stderr [16:48:19.584](0.000s) ok 4 - initdb --help maximum line length # Running: initdb --version [16:48:19.589](0.005s) ok 5 - initdb --version exit code 0 [16:48:19.589](0.000s) ok 6 - initdb --version goes to stdout [16:48:19.590](0.000s) ok 7 - initdb --version nothing to stderr # Running: initdb --not-a-valid-option [16:48:19.595](0.005s) ok 8 - initdb with invalid option nonzero exit code [16:48:19.595](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_MWFQ/nonexistent initdb: error: could not access directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/nonexistent": No such file or directory [16:48:19.608](0.013s) ok 10 - sync missing data directory # Running: initdb -X /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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_MWFQ/data ... ok initdb: error: directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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_MWFQ/data" [16:48:19.623](0.015s) ok 11 - existing nonempty xlog directory # Running: initdb -X pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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_MWFQ/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_MWFQ/data" [16:48:19.637](0.014s) ok 12 - relative xlog directory not allowed # Running: initdb -U pg_test /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/data initdb: error: superuser name "pg_test" is disallowed; role names cannot begin with "pg_" [16:48:19.651](0.014s) 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_MWFQ/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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_MWFQ/data ... ok fixing permissions on existing directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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-21 16:48:20.038 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.309 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.316 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.317 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.319 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.320 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.321 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.322 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.323 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.323 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.324 UTC [32415] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:20.440 UTC [32415] 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_MWFQ/data -l logfile start [16:48:20.821](1.171s) ok 14 - successful creation [16:48:20.835](0.014s) ok 15 - check PGDATA permissions # Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/data [16:48:20.840](0.005s) ok 16 - checksums are disabled in control file: exit code 0 [16:48:20.840](0.000s) ok 17 - checksums are disabled in control file: no stderr [16:48:20.840](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_MWFQ/data pg_checksums: error: data checksums are not enabled in cluster [16:48:20.854](0.013s) ok 19 - pg_checksums fails with data checksum disabled # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/data syncing data to disk ... ok [16:48:20.934](0.080s) ok 20 - sync only # Running: initdb /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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_MWFQ/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_MWFQ/data" or run initdb with an argument other than "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/data". [16:48:20.969](0.035s) ok 21 - existing data directory # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/data --sync-method syncfs initdb: error: this build does not support sync method "syncfs" [16:48:20.984](0.015s) ok 22 - sync method syncfs # Running: initdb -g /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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_MWFQ/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-21 16:48:21.370 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.641 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.645 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.646 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.648 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.650 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.650 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.651 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.652 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.653 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.653 UTC [32626] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:21.769 UTC [32626] 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_MWFQ/data_group -l logfile start [16:48:22.151](1.167s) ok 23 - successful creation with group access [16:48:22.164](0.013s) ok 24 - check PGDATA permissions # Running: initdb --no-sync --locale-provider=icu /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/data2 [16:48:22.178](0.015s) ok 25 - locale provider ICU requires --icu-locale: exit code not 0 [16:48:22.179](0.000s) 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_MWFQ/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_MWFQ/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-21 16:48:22.555 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.825 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.830 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.831 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.833 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.834 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.835 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.836 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.837 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.837 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.838 UTC [32817] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:22.954 UTC [32817] 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_MWFQ/data3 -l logfile start [16:48:23.341](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_MWFQ/data4 [16:48:24.343](1.001s) ok 28 - options --locale-provider=icu --locale=und --lc-*=C: exit code 0 [16:48:24.343](0.001s) not ok 29 - options --locale-provider=icu --locale=und --lc-*=C: no stderr [16:48:24.344](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. [16:48:24.344](0.000s) # got: '2024-03-21 16:48:23.732 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:23.995 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:23.999 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.000 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.002 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.004 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.005 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.005 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.006 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.007 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.007 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-21 16:48:24.122 UTC [33048] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # ' # expected: '' [16:48:24.344](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_MWFQ/dataX [16:48:24.569](0.224s) ok 31 - fails for invalid ICU locale: exit code not 0 [16:48:24.569](0.000s) 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_MWFQ/dataX [16:48:24.585](0.016s) ok 33 - fails for encoding not supported by ICU: exit code not 0 [16:48:24.585](0.000s) 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_MWFQ/dataX [16:48:24.597](0.012s) ok 35 - fails for nonsense language: exit code not 0 [16:48:24.597](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_MWFQ/dataX [16:48:24.813](0.216s) ok 37 - fails for invalid collation argument: exit code not 0 [16:48:24.814](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_MWFQ/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 [16:48:24.828](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_MWFQ/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_MWFQ/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-21 16:48:25.223 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.494 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.498 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.499 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.501 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.502 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.503 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.504 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.505 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.505 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.506 UTC [33249] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:25.625 UTC [33249] 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_MWFQ/data7 -l logfile start [16:48:25.991](1.164s) 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_MWFQ/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_MWFQ/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-21 16:48:26.468 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.767 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.771 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.773 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.775 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.776 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.777 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.778 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.779 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.780 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.781 UTC [33427] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:26.910 UTC [33427] 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_MWFQ/data8 -l logfile start [16:48:27.164](1.172s) 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_MWFQ/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" [16:48:27.200](0.036s) 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_MWFQ/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_MWFQ/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-21 16:48:27.637 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.921 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.925 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.927 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.928 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.930 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.931 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.932 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.932 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.933 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:27.934 UTC [33569] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:28.061 UTC [33569] 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_MWFQ/data10 -l logfile start [16:48:28.374](1.175s) 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_MWFQ/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [16:48:28.390](0.016s) 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_MWFQ/dataX initdb: error: --icu-rules cannot be specified unless locale provider "icu" is chosen [16:48:28.406](0.016s) 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_MWFQ/dataX initdb: error: unrecognized locale provider: xyz [16:48:28.421](0.015s) 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_MWFQ/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [16:48:28.436](0.015s) 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_MWFQ/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_MWFQ/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-21 16:48:28.667 GMT [33772] LOG: unrecognized configuration parameter "foo" in file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/dataX/postgresql.conf" line 841 2024-03-21 16:48:28.667 GMT [33772] FATAL: configuration file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_MWFQ/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_MWFQ/dataX" [16:48:28.771](0.335s) 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_MWFQ/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_MWFQ/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-21 16:48:29.196 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.489 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.494 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.496 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.497 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.499 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.500 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.501 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.502 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.503 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.504 UTC [33831] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:48:29.625 UTC [33831] 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_MWFQ/dataY -l logfile start [16:48:29.941](1.170s) ok 49 - multiple -c options with different case [16:48:29.942](0.000s) ok 50 - WORK_MEM should not be configured [16:48:29.942](0.000s) ok 51 - Work_Mem should not be configured [16:48:29.942](0.000s) ok 52 - work_mem should be in config [16:48:29.942](0.000s) 1..52 [16:48:29.943](0.001s) # Looks like you failed 1 test of 52.