# Running: initdb --help [22:53:51.253](0.023s) ok 1 - initdb --help exit code 0 [22:53:51.253](0.000s) ok 2 - initdb --help goes to stdout [22:53:51.254](0.000s) ok 3 - initdb --help nothing to stderr [22:53:51.254](0.000s) ok 4 - initdb --help maximum line length # Running: initdb --version [22:53:51.262](0.008s) ok 5 - initdb --version exit code 0 [22:53:51.262](0.000s) ok 6 - initdb --version goes to stdout [22:53:51.263](0.000s) ok 7 - initdb --version nothing to stderr # Running: initdb --not-a-valid-option [22:53:51.270](0.007s) ok 8 - initdb with invalid option nonzero exit code [22:53:51.270](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_w3X7/nonexistent initdb: error: could not access directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/nonexistent": No such file or directory [22:53:51.283](0.013s) ok 10 - sync missing data directory # Running: initdb -X /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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_w3X7/data ... ok initdb: error: directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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_w3X7/data" [22:53:51.298](0.015s) ok 11 - existing nonempty xlog directory # Running: initdb -X pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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_w3X7/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_w3X7/data" [22:53:51.334](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_w3X7/data initdb: error: superuser name "pg_test" is disallowed; role names cannot begin with "pg_" [22:53:51.369](0.035s) 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_w3X7/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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_w3X7/data ... ok fixing permissions on existing directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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-27 22:53:51.772 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.047 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.051 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.053 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.054 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.056 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.057 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.058 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.059 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.059 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.060 UTC [33150] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:52.179 UTC [33150] 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_w3X7/data -l logfile start [22:53:52.555](1.186s) ok 14 - successful creation [22:53:52.568](0.014s) ok 15 - check PGDATA permissions # Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/data [22:53:52.574](0.005s) ok 16 - checksums are disabled in control file: exit code 0 [22:53:52.574](0.000s) ok 17 - checksums are disabled in control file: no stderr [22:53:52.574](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_w3X7/data pg_checksums: error: data checksums are not enabled in cluster [22:53:52.579](0.005s) ok 19 - pg_checksums fails with data checksum disabled # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/data syncing data to disk ... ok [22:53:52.656](0.077s) ok 20 - sync only # Running: initdb /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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_w3X7/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_w3X7/data" or run initdb with an argument other than "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/data". [22:53:52.692](0.036s) ok 21 - existing data directory # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/data --sync-method syncfs initdb: error: this build does not support sync method "syncfs" [22:53:52.706](0.014s) ok 22 - sync method syncfs # Running: initdb -g /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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_w3X7/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-27 22:53:53.104 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.368 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.372 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.373 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.375 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.376 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.377 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.378 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.378 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.379 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.380 UTC [33366] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:53.495 UTC [33366] 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_w3X7/data_group -l logfile start [22:53:53.869](1.162s) ok 23 - successful creation with group access [22:53:53.881](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_w3X7/data2 [22:53:53.896](0.014s) ok 25 - locale provider ICU requires --icu-locale: exit code not 0 [22:53:53.896](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_w3X7/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_w3X7/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-27 22:53:54.291 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.557 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.561 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.562 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.564 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.566 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.566 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.567 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.568 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.569 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.569 UTC [33564] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:54.687 UTC [33564] 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_w3X7/data3 -l logfile start [22:53:55.069](1.173s) 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_w3X7/data4 [22:53:56.569](1.500s) ok 28 - options --locale-provider=icu --locale=und --lc-*=C: exit code 0 [22:53:56.570](0.001s) not ok 29 - options --locale-provider=icu --locale=und --lc-*=C: no stderr [22:53:56.570](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. [22:53:56.570](0.000s) # got: '2024-03-27 22:53:55.460 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.719 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.723 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.724 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.726 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.728 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.728 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.729 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.730 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.731 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.732 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-27 22:53:55.850 UTC [33782] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # ' # expected: '' [22:53:56.570](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_w3X7/dataX [22:53:57.299](0.728s) ok 31 - fails for invalid ICU locale: exit code not 0 [22:53:57.299](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_w3X7/dataX [22:53:57.313](0.014s) ok 33 - fails for encoding not supported by ICU: exit code not 0 [22:53:57.314](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_w3X7/dataX [22:53:57.328](0.014s) ok 35 - fails for nonsense language: exit code not 0 [22:53:57.329](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_w3X7/dataX [22:53:57.548](0.220s) ok 37 - fails for invalid collation argument: exit code not 0 [22:53:57.549](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_w3X7/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 [22:53:57.584](0.035s) 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_w3X7/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_w3X7/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-27 22:53:57.977 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.242 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.245 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.247 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.248 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.250 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.251 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.251 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.252 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.253 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.253 UTC [34134] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:58.366 UTC [34134] 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_w3X7/data7 -l logfile start [22:53:58.753](1.169s) 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_w3X7/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_w3X7/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-27 22:53:59.139 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.401 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.405 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.407 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.409 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.411 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.412 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.412 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.413 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.414 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.415 UTC [34280] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:53:59.528 UTC [34280] 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_w3X7/data8 -l logfile start [22:53:59.932](1.179s) 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_w3X7/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" [22:53:59.968](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_w3X7/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_w3X7/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-27 22:54:00.351 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.615 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.619 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.621 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.623 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.624 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.625 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.626 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.626 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.627 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.628 UTC [34465] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:00.745 UTC [34465] 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_w3X7/data10 -l logfile start [22:54:01.131](1.164s) 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_w3X7/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [22:54:01.146](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_w3X7/dataX initdb: error: --icu-rules cannot be specified unless locale provider "icu" is chosen [22:54:01.159](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_w3X7/dataX initdb: error: unrecognized locale provider: xyz [22:54:01.173](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_w3X7/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [22:54:01.186](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_w3X7/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_w3X7/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-27 22:54:01.422 GMT [34659] LOG: unrecognized configuration parameter "foo" in file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/dataX/postgresql.conf" line 841 2024-03-27 22:54:01.422 GMT [34659] FATAL: configuration file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_w3X7/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_w3X7/dataX" [22:54:01.509](0.323s) 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_w3X7/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_w3X7/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-27 22:54:01.889 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.149 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.152 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.154 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.155 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.157 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.157 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.158 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.159 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.159 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.160 UTC [34693] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-27 22:54:02.280 UTC [34693] 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_w3X7/dataY -l logfile start [22:54:02.693](1.184s) ok 49 - multiple -c options with different case [22:54:02.694](0.000s) ok 50 - WORK_MEM should not be configured [22:54:02.694](0.000s) ok 51 - Work_Mem should not be configured [22:54:02.694](0.000s) ok 52 - work_mem should be in config [22:54:02.694](0.000s) 1..52 [22:54:02.695](0.001s) # Looks like you failed 1 test of 52.