# Running: initdb --help [13:53:38.592](0.022s) ok 1 - initdb --help exit code 0 [13:53:38.593](0.000s) ok 2 - initdb --help goes to stdout [13:53:38.593](0.000s) ok 3 - initdb --help nothing to stderr [13:53:38.593](0.000s) ok 4 - initdb --help maximum line length # Running: initdb --version [13:53:38.599](0.006s) ok 5 - initdb --version exit code 0 [13:53:38.599](0.000s) ok 6 - initdb --version goes to stdout [13:53:38.599](0.000s) ok 7 - initdb --version nothing to stderr # Running: initdb --not-a-valid-option [13:53:38.605](0.006s) ok 8 - initdb with invalid option nonzero exit code [13:53:38.605](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_9YIQ/nonexistent initdb: error: could not access directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/nonexistent": No such file or directory [13:53:38.619](0.014s) ok 10 - sync missing data directory # Running: initdb -X /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/data ... ok initdb: error: directory "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/data" [13:53:38.633](0.014s) ok 11 - existing nonempty xlog directory # Running: initdb -X pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/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_9YIQ/data" [13:53:38.648](0.015s) ok 12 - relative xlog directory not allowed # Running: initdb -U pg_test /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/data initdb: error: superuser name "pg_test" is disallowed; role names cannot begin with "pg_" [13:53:38.662](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_9YIQ/pgxlog /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/data ... ok fixing permissions on existing directory /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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-19 13:53:39.037 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.301 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.304 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.306 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.307 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.309 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.309 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.310 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.311 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.311 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.312 UTC [33055] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:39.423 UTC [33055] 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_9YIQ/data -l logfile start [13:53:39.836](1.174s) ok 14 - successful creation [13:53:39.849](0.013s) ok 15 - check PGDATA permissions # Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/data [13:53:39.854](0.005s) ok 16 - checksums are disabled in control file: exit code 0 [13:53:39.854](0.000s) ok 17 - checksums are disabled in control file: no stderr [13:53:39.854](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_9YIQ/data pg_checksums: error: data checksums are not enabled in cluster [13:53:39.868](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_9YIQ/data syncing data to disk ... ok [13:53:39.946](0.078s) ok 20 - sync only # Running: initdb /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/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_9YIQ/data" or run initdb with an argument other than "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/data". [13:53:39.961](0.015s) ok 21 - existing data directory # Running: initdb -S /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/data --sync-method syncfs initdb: error: this build does not support sync method "syncfs" [13:53:39.976](0.014s) ok 22 - sync method syncfs # Running: initdb -g /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/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-19 13:53:40.350 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.614 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.618 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.619 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.621 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.622 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.623 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.623 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.624 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.625 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.626 UTC [33248] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:40.738 UTC [33248] 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_9YIQ/data_group -l logfile start [13:53:41.143](1.167s) ok 23 - successful creation with group access [13:53:41.155](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_9YIQ/data2 [13:53:41.169](0.014s) ok 25 - locale provider ICU requires --icu-locale: exit code not 0 [13:53:41.169](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_9YIQ/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_9YIQ/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-19 13:53:41.547 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.809 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.813 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.814 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.816 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.817 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.818 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.819 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.819 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.820 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.821 UTC [33451] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:41.938 UTC [33451] 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_9YIQ/data3 -l logfile start [13:53:42.342](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_9YIQ/data4 [13:53:43.802](1.460s) ok 28 - options --locale-provider=icu --locale=und --lc-*=C: exit code 0 [13:53:43.803](0.000s) not ok 29 - options --locale-provider=icu --locale=und --lc-*=C: no stderr [13:53:43.803](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. [13:53:43.803](0.000s) # got: '2024-03-19 13:53:42.721 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.979 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.983 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.984 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.986 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.987 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.988 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.989 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.990 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.990 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:42.991 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # 2024-03-19 13:53:43.101 UTC [33671] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree # ' # expected: '' [13:53:43.804](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_9YIQ/dataX [13:53:44.513](0.709s) ok 31 - fails for invalid ICU locale: exit code not 0 [13:53:44.513](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_9YIQ/dataX [13:53:44.529](0.016s) ok 33 - fails for encoding not supported by ICU: exit code not 0 [13:53:44.530](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_9YIQ/dataX [13:53:44.545](0.015s) ok 35 - fails for nonsense language: exit code not 0 [13:53:44.545](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_9YIQ/dataX [13:53:44.752](0.207s) ok 37 - fails for invalid collation argument: exit code not 0 [13:53:44.752](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_9YIQ/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 [13:53:44.766](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_9YIQ/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_9YIQ/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-19 13:53:45.126 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.376 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.380 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.381 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.383 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.384 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.385 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.386 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.386 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.387 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.388 UTC [34010] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:45.500 UTC [34010] 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_9YIQ/data7 -l logfile start [13:53:45.932](1.166s) ok 40 - locale provider builtin with --locale # Running: initdb --no-sync --locale-provider=builtin --lc-ctype=C --locale=C /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/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-19 13:53:46.308 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.566 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.570 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.571 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.573 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.574 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.575 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.576 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.576 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.577 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.578 UTC [34155] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:46.697 UTC [34155] 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_9YIQ/data10 -l logfile start [13:53:47.094](1.162s) ok 41 - 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_9YIQ/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [13:53:47.108](0.014s) ok 42 - 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_9YIQ/dataX initdb: error: --icu-rules cannot be specified unless locale provider "icu" is chosen [13:53:47.123](0.014s) ok 43 - 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_9YIQ/dataX initdb: error: unrecognized locale provider: xyz [13:53:47.137](0.014s) ok 44 - 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_9YIQ/dataX initdb: error: --icu-locale cannot be specified unless locale provider "icu" is chosen [13:53:47.151](0.014s) ok 45 - fails for invalid option combination # Running: initdb --no-sync --set foo=bar /tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/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-19 13:53:47.341 GMT [34382] LOG: unrecognized configuration parameter "foo" in file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/dataX/postgresql.conf" line 841 2024-03-19 13:53:47.341 GMT [34382] FATAL: configuration file "/tmp/cirrus-ci-build/build/testrun/initdb/001_initdb/data/tmp_test_9YIQ/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_9YIQ/dataX" [13:53:47.482](0.331s) ok 46 - 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_9YIQ/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_9YIQ/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-19 13:53:47.852 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.111 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.115 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.116 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.118 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.119 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.120 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.121 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.121 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.122 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.123 UTC [34420] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 13:53:48.232 UTC [34420] 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_9YIQ/dataY -l logfile start [13:53:48.683](1.201s) ok 47 - multiple -c options with different case [13:53:48.684](0.000s) ok 48 - WORK_MEM should not be configured [13:53:48.684](0.000s) ok 49 - Work_Mem should not be configured [13:53:48.684](0.000s) ok 50 - work_mem should be in config [13:53:48.684](0.000s) 1..50 [13:53:48.685](0.001s) # Looks like you failed 1 test of 50.