# Running: initdb --help [23:54:05.212](0.019s) ok 1 - initdb --help exit code 0 [23:54:05.212](0.000s) ok 2 - initdb --help goes to stdout [23:54:05.212](0.000s) ok 3 - initdb --help nothing to stderr [23:54:05.212](0.000s) ok 4 - initdb --help maximum line length # Running: initdb --version [23:54:05.217](0.005s) ok 5 - initdb --version exit code 0 [23:54:05.217](0.000s) ok 6 - initdb --version goes to stdout [23:54:05.217](0.000s) ok 7 - initdb --version nothing to stderr # Running: initdb --not-a-valid-option [23:54:05.222](0.005s) ok 8 - initdb with invalid option nonzero exit code [23:54:05.222](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_YZb1/nonexistent initdb: error: could not access directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/nonexistent": No such file or directory [23:54:05.234](0.012s) ok 10 - sync missing data directory # Running: initdb -X /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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_YZb1/data ... ok initdb: error: directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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_YZb1/data" [23:54:05.247](0.013s) ok 11 - existing nonempty xlog directory # Running: initdb -X pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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_YZb1/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_YZb1/data" [23:54:05.261](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_YZb1/data initdb: error: superuser name "pg_test" is disallowed; role names cannot begin with "pg_" [23:54:05.275](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_YZb1/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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_YZb1/data ... ok fixing permissions on existing directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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-26 23:54:05.653 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.917 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.921 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.923 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.924 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.926 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.927 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.927 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.928 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.929 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:05.930 UTC [32635] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:06.044 UTC [32635] 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_YZb1/data -l logfile start [23:54:06.438](1.163s) ok 14 - successful creation [23:54:06.451](0.013s) ok 15 - check PGDATA permissions # Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/data [23:54:06.456](0.005s) ok 16 - checksums are disabled in control file: exit code 0 [23:54:06.457](0.000s) ok 17 - checksums are disabled in control file: no stderr [23:54:06.457](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_YZb1/data pg_checksums: error: data checksums are not enabled in cluster [23:54:06.471](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_YZb1/data syncing data to disk ... ok [23:54:06.551](0.080s) ok 20 - sync only # Running: initdb /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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_YZb1/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_YZb1/data" or run initdb with an argument other than "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/data". [23:54:06.586](0.035s) ok 21 - existing data directory # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/data --sync-method syncfs initdb: error: this build does not support sync method "syncfs" [23:54:06.592](0.007s) ok 22 - sync method syncfs # Running: initdb -g /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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_YZb1/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-26 23:54:06.966 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.226 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.229 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.230 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.232 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.233 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.234 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.235 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.235 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.236 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.237 UTC [32833] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:07.349 UTC [32833] 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_YZb1/data_group -l logfile start [23:54:07.758](1.166s) ok 23 - successful creation with group access [23:54:07.771](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_YZb1/data2 [23:54:07.784](0.013s) ok 25 - locale provider ICU requires --icu-locale: exit code not 0 [23:54:07.784](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_YZb1/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_YZb1/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-26 23:54:08.170 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.433 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.437 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.439 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.441 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.443 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.443 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.444 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.445 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.445 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.446 UTC [33044] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:08.577 UTC [33044] 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_YZb1/data3 -l logfile start [23:54:08.949](1.164s) 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_YZb1/data4 [23:54:09.922](0.974s) ok 28 - options --locale-provider=icu --locale=und --lc-*=C: exit code 0 [23:54:09.923](0.000s) not ok 29 - options --locale-provider=icu --locale=und --lc-*=C: no stderr [23:54:09.923](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. [23:54:09.923](0.000s) # got: '2024-03-26 23:54:09.335 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.594 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.598 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.599 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.601 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.603 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.603 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.604 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.605 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.605 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.606 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-26 23:54:09.716 UTC [33256] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # ' # expected: '' [23:54:09.924](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_YZb1/dataX [23:54:10.127](0.204s) ok 31 - fails for invalid ICU locale: exit code not 0 [23:54:10.128](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_YZb1/dataX [23:54:10.142](0.014s) ok 33 - fails for encoding not supported by ICU: exit code not 0 [23:54:10.142](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_YZb1/dataX [23:54:10.156](0.014s) ok 35 - fails for nonsense language: exit code not 0 [23:54:10.156](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_YZb1/dataX [23:54:10.874](0.718s) ok 37 - fails for invalid collation argument: exit code not 0 [23:54:10.875](0.000s) 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_YZb1/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 [23:54:10.888](0.013s) 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_YZb1/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_YZb1/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-26 23:54:11.263 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.523 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.527 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.529 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.530 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.532 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.532 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.533 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.534 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.535 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.535 UTC [33526] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:11.653 UTC [33526] 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_YZb1/data7 -l logfile start [23:54:12.058](1.170s) 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_YZb1/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_YZb1/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-26 23:54:12.436 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.700 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.704 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.705 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.707 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.709 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.709 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.710 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.711 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.711 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.712 UTC [33693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:12.827 UTC [33693] 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_YZb1/data8 -l logfile start [23:54:13.221](1.163s) 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_YZb1/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" [23:54:13.260](0.039s) 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_YZb1/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_YZb1/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-26 23:54:13.633 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.896 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.903 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.904 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.906 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.909 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.910 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.911 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.912 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.916 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:13.916 UTC [33851] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:14.040 UTC [33851] 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_YZb1/data10 -l logfile start [23:54:14.459](1.200s) 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_YZb1/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [23:54:14.473](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_YZb1/dataX initdb: error: --icu-rules cannot be specified unless locale provider "icu" is chosen [23:54:14.489](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_YZb1/dataX initdb: error: unrecognized locale provider: xyz [23:54:14.502](0.014s) 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_YZb1/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [23:54:14.516](0.014s) 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_YZb1/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_YZb1/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-26 23:54:14.705 GMT [34072] LOG: unrecognized configuration parameter "foo" in file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/dataX/postgresql.conf" line 841 2024-03-26 23:54:14.705 GMT [34072] FATAL: configuration file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_YZb1/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_YZb1/dataX" [23:54:14.848](0.332s) 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_YZb1/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_YZb1/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-26 23:54:15.224 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.484 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.487 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.489 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.490 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.492 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.492 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.493 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.494 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.495 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.495 UTC [34117] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-26 23:54:15.611 UTC [34117] 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_YZb1/dataY -l logfile start [23:54:16.032](1.184s) ok 49 - multiple -c options with different case [23:54:16.032](0.000s) ok 50 - WORK_MEM should not be configured [23:54:16.032](0.000s) ok 51 - Work_Mem should not be configured [23:54:16.032](0.000s) ok 52 - work_mem should be in config [23:54:16.033](0.000s) 1..52 [23:54:16.033](0.001s) # Looks like you failed 1 test of 52.