# Checking port 59022 # Found port 59022 Name: main Data directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup Archive directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/archives Connection string: port=59022 host=/tmp/nkdhUZphOn Log file: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_main.log [06:37:56.990](0.048s) # initializing database system by running initdb # Running: initdb -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata -A trust -N -U regress_postgres --locale=C --encoding=LATIN1 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 locale "C". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/src/bin/pg_dump/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata # Running: /tmp/cirrus-ci-build/src/bin/pg_dump/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata --user regress_postgres --create-role regress_  !"x"#$%&'()*+-./0123456,regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~,regress_,regress_ ### Starting node "main" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata -l /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_main.log -o --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 33621 # Running: createdb -U regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: createuser -U regress_postgres -s regress_  !"x"#$%&'()*+-./0123456 # Running: createdb -U regress_postgres regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~ # Running: createuser -U regress_postgres -s regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~ # Running: createdb -U regress_postgres regression # Running: createuser -U regress_postgres -s regress_ # Running: createdb -U regress_postgres regression # Running: createuser -U regress_postgres -s regress_ # Running: pg_dumpall -r -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=59022 host=/tmp/nkdhUZphOn dbname='regression  !"x"#$%&\'()*+-./0123456' -U regress_ [06:38:00.617](3.627s) ok 1 - pg_dumpall with long ASCII name 1 # Running: pg_dumpall --no-sync -r -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=59022 host=/tmp/nkdhUZphOn dbname='regression789:;<=>?@AXYZ[\\]^_`abcxyz{|}~' -U regress_ [06:38:00.781](0.164s) ok 2 - pg_dumpall with long ASCII name 2 # Running: pg_dumpall --no-sync -r -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=59022 host=/tmp/nkdhUZphOn dbname='regression' -U regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~ [06:38:00.856](0.075s) ok 3 - pg_dumpall with long ASCII name 3 # Running: pg_dumpall --no-sync -r -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=59022 host=/tmp/nkdhUZphOn dbname='regression' -U regress_  !"x"#$%&'()*+-./0123456 [06:38:00.889](0.033s) ok 4 - pg_dumpall with long ASCII name 4 # Running: pg_dumpall -U regress_postgres --no-sync -r -l dbname=template1 -- -- PostgreSQL database cluster dump -- SET default_transaction_read_only = off; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; -- -- Roles -- CREATE ROLE "regress_  !""x""#$%&'()*+-./0123456"; ALTER ROLE "regress_  !""x""#$%&'()*+-./0123456" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; CREATE ROLE "regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~"; ALTER ROLE "regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; CREATE ROLE regress_postgres; ALTER ROLE regress_postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS; CREATE ROLE "regress_"; ALTER ROLE "regress_" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; CREATE ROLE "regress_"; ALTER ROLE "regress_" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; -- -- User Configurations -- -- -- PostgreSQL database cluster dump complete -- [06:38:00.970](0.081s) ok 5 - pg_dumpall -l accepts connection string # Running: createdb -U regress_postgres foo bar # Running: pg_dumpall -U regress_postgres --no-sync -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql shell command argument contains a newline or carriage return: "user=regress_postgres dbname='foo bar'" [06:38:01.368](0.398s) ok 6 - pg_dumpall with \n\r in database name # Running: dropdb -U regress_postgres foo bar # Running: pg_dump -Fd --no-sync -j2 -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/dirfmt -U regress_  !"x"#$%&'()*+-./0123456 port=59022 host=/tmp/nkdhUZphOn dbname='regression  !"x"#$%&\'()*+-./0123456' [06:38:01.894](0.526s) ok 7 - parallel dump # Running: dropdb -U regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: createdb -U regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: pg_restore -v -d template1 -j2 -U regress_  !"x"#$%&'()*+-./0123456 /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/dirfmt pg_restore: connecting to database for restore pg_restore: processing item 3977 ENCODING ENCODING pg_restore: processing item 3978 STDSTRINGS STDSTRINGS pg_restore: processing item 3979 SEARCHPATH SEARCHPATH pg_restore: processing item 3980 DATABASE regression  !"x"#$%&'()*+-./0123456 pg_restore: processing item 217 TABLE t0 pg_restore: creating TABLE "public.t0" pg_restore: processing item 3981 STATISTICS DATA TABLE t0 pg_restore: creating STATISTICS DATA "public.TABLE t0" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 3981; 0 0 STATISTICS DATA TABLE t0 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.t0'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: entering main parallel loop pg_restore: launching item 3974 TABLE DATA t0 pg_restore: processing data for table "public.t0" pg_restore: finished item 3974 TABLE DATA t0 pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 1 [06:38:02.091](0.196s) not ok 8 - parallel restore [06:38:02.091](0.000s) [06:38:02.091](0.000s) # Failed test 'parallel restore' # at t/010_dump_connstr.pl line 152. # Running: dropdb -U regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: pg_restore -C -v -d template1 -j2 -U regress_  !"x"#$%&'()*+-./0123456 /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/dirfmt pg_restore: connecting to database for restore pg_restore: processing item 3977 ENCODING ENCODING pg_restore: processing item 3978 STDSTRINGS STDSTRINGS pg_restore: processing item 3979 SEARCHPATH SEARCHPATH pg_restore: processing item 3980 DATABASE regression  !"x"#$%&'()*+-./0123456 pg_restore: creating DATABASE "regression  !"x"#$%&'()*+-./0123456" pg_restore: connecting to new database "regression  !"x"#$%&'()*+-./0123456" pg_restore: processing item 217 TABLE t0 pg_restore: creating TABLE "public.t0" pg_restore: processing item 3981 STATISTICS DATA TABLE t0 pg_restore: creating STATISTICS DATA "public.TABLE t0" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 3981; 0 0 STATISTICS DATA TABLE t0 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.t0'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: entering main parallel loop pg_restore: launching item 3974 TABLE DATA t0 pg_restore: processing data for table "public.t0" pg_restore: finished item 3974 TABLE DATA t0 pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 1 [06:38:02.494](0.403s) not ok 9 - parallel restore with create [06:38:02.494](0.000s) [06:38:02.494](0.000s) # Failed test 'parallel restore with create' # at t/010_dump_connstr.pl line 161. # Running: pg_dumpall --no-sync -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql -U regress_  !"x"#$%&'()*+-./0123456 [06:38:03.639](1.145s) ok 10 - take full dump # Running: cat /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql -- -- PostgreSQL database cluster dump -- SET default_transaction_read_only = off; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; -- -- Roles -- CREATE ROLE "regress_  !""x""#$%&'()*+-./0123456"; ALTER ROLE "regress_  !""x""#$%&'()*+-./0123456" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; CREATE ROLE "regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~"; ALTER ROLE "regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; CREATE ROLE regress_postgres; ALTER ROLE regress_postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS; CREATE ROLE "regress_"; ALTER ROLE "regress_" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; CREATE ROLE "regress_"; ALTER ROLE "regress_" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION NOBYPASSRLS; -- -- User Configurations -- -- -- Databases -- -- -- Database "template1" dump -- \connect template1 -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: t0; Type: TABLE; Schema: public; Owner: regress_postgres -- CREATE TABLE public.t0 ( ); ALTER TABLE public.t0 OWNER TO regress_postgres; -- -- Name: TABLE t0; Type: STATISTICS DATA; Schema: public; Owner: - -- SELECT pg_catalog.pg_set_relation_stats( relation => 'public.t0'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); -- -- Data for Name: t0; Type: TABLE DATA; Schema: public; Owner: regress_postgres -- COPY public.t0 FROM stdin; \. -- -- PostgreSQL database dump complete -- -- -- Database "postgres" dump -- \connect postgres -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- PostgreSQL database dump complete -- -- -- Database "regression  !"x"#$%&'()*+-./0123456" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: regression  !"x"#$%&'()*+-./0123456; Type: DATABASE; Schema: -; Owner: regress_postgres -- CREATE DATABASE "regression  !""x""#$%&'()*+-./0123456" WITH TEMPLATE = template0 ENCODING = 'LATIN1' LOCALE_PROVIDER = libc LOCALE = 'C'; ALTER DATABASE "regression  !""x""#$%&'()*+-./0123456" OWNER TO regress_postgres; \connect -reuse-previous=on "dbname='regression  !""x""#$%&\'()*+-./0123456'" SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: t0; Type: TABLE; Schema: public; Owner: regress_postgres -- CREATE TABLE public.t0 ( ); ALTER TABLE public.t0 OWNER TO regress_postgres; -- -- Name: TABLE t0; Type: STATISTICS DATA; Schema: public; Owner: - -- SELECT pg_catalog.pg_set_relation_stats( relation => 'public.t0'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); -- -- Data for Name: t0; Type: TABLE DATA; Schema: public; Owner: regress_postgres -- COPY public.t0 FROM stdin; \. -- -- PostgreSQL database dump complete -- -- -- Database "regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~; Type: DATABASE; Schema: -; Owner: regress_postgres -- CREATE DATABASE "regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~" WITH TEMPLATE = template0 ENCODING = 'LATIN1' LOCALE_PROVIDER = libc LOCALE = 'C'; ALTER DATABASE "regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~" OWNER TO regress_postgres; \connect -reuse-previous=on "dbname='regression789:;<=>?@AXYZ[\\]^_`abcxyz{|}~'" SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- PostgreSQL database dump complete -- -- -- Database "regression" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: regression; Type: DATABASE; Schema: -; Owner: regress_postgres -- CREATE DATABASE "regression" WITH TEMPLATE = template0 ENCODING = 'LATIN1' LOCALE_PROVIDER = libc LOCALE = 'C'; ALTER DATABASE "regression" OWNER TO regress_postgres; \connect -reuse-previous=on "dbname='regression'" SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- PostgreSQL database dump complete -- -- -- Database "regression" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: regression; Type: DATABASE; Schema: -; Owner: regress_postgres -- CREATE DATABASE "regression" WITH TEMPLATE = template0 ENCODING = 'LATIN1' LOCALE_PROVIDER = libc LOCALE = 'C'; ALTER DATABASE "regression" OWNER TO regress_postgres; \connect -reuse-previous=on "dbname='regression'" SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'LATIN1'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- PostgreSQL database dump complete -- -- -- PostgreSQL database cluster dump complete -- # Checking port 59023 # Found port 59023 Name: destination_envar Data directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/backup Archive directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/archives Connection string: port=59023 host=/tmp/nkdhUZphOn Log file: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_envar.log [06:38:03.659](0.020s) # initializing database system by running initdb # Running: initdb -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata -A trust -N -U boot --locale=C --encoding=LATIN1 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 locale "C". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/src/bin/pg_dump/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata --user boot --create-role regress_a'b\c=d\ne"f ### Starting node "destination_envar" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata -l /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_envar.log -o --cluster-name=destination_envar start waiting for server to start.... done server started # Postmaster PID for node "destination_envar" is 35117 # Running: createuser -U boot -s regress_a'b\c=d\ne"f # Running: psql -X -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql SET SET SET CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE You are now connected to database "template1" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET CREATE TABLE ALTER TABLE COPY 0 You are now connected to database "postgres" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression  !"x"#$%&'()*+-./0123456" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET CREATE TABLE ALTER TABLE COPY 0 SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET [06:38:05.994](2.335s) ok 11 - restore full dump using environment variables for connection parameters [06:38:05.994](0.000s) not ok 12 - no dump errors [06:38:05.994](0.000s) [06:38:05.994](0.000s) # Failed test 'no dump errors' # at t/010_dump_connstr.pl line 204. [06:38:05.995](0.000s) # got: 'psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:88: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist # LINE 1: SELECT pg_catalog.pg_set_relation_stats( # ^ # HINT: No function matches the given name and argument types. You might need to add explicit type casts. # psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:201: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist # LINE 1: SELECT pg_catalog.pg_set_relation_stats( # ^ # HINT: No function matches the given name and argument types. You might need to add explicit type casts. # ' # expected: '' # Checking port 59024 # Found port 59024 Name: destination_cmdline Data directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/backup Archive directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/archives Connection string: port=59024 host=/tmp/nkdhUZphOn Log file: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_cmdline.log [06:38:06.004](0.009s) # initializing database system by running initdb # Running: initdb -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata -A trust -N -U boot --locale=C --encoding=LATIN1 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 locale "C". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/src/bin/pg_dump/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata --user boot --create-role regress_a'b\c=d\ne"f ### Starting node "destination_cmdline" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata -l /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_cmdline.log -o --cluster-name=destination_cmdline start waiting for server to start.... done server started # Postmaster PID for node "destination_cmdline" is 35527 # Running: createuser -U boot -s regress_a'b\c=d\ne"f # Running: psql -p 59024 -U regress_a'b\c=d\ne"f -X -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql SET SET SET CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE CREATE ROLE ALTER ROLE You are now connected to database "template1" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET CREATE TABLE ALTER TABLE COPY 0 You are now connected to database "postgres" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression  !"x"#$%&'()*+-./0123456" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET CREATE TABLE ALTER TABLE COPY 0 SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE DATABASE ALTER DATABASE You are now connected to database "regression" as user "regress_a'b\c=d\ne"f". SET SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET [06:38:08.228](2.224s) ok 13 - restore full dump with command-line options for connection parameters [06:38:08.228](0.000s) not ok 14 - no dump errors [06:38:08.228](0.000s) [06:38:08.229](0.000s) # Failed test 'no dump errors' # at t/010_dump_connstr.pl line 231. [06:38:08.229](0.000s) # got: 'psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:88: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist # LINE 1: SELECT pg_catalog.pg_set_relation_stats( # ^ # HINT: No function matches the given name and argument types. You might need to add explicit type casts. # psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:201: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist # LINE 1: SELECT pg_catalog.pg_set_relation_stats( # ^ # HINT: No function matches the given name and argument types. You might need to add explicit type casts. # ' # expected: '' [06:38:08.229](0.000s) 1..14 ### Stopping node "main" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "main" ### Stopping node "destination_envar" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "destination_envar" ### Stopping node "destination_cmdline" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "destination_cmdline" [06:38:08.541](0.312s) # Looks like you failed 4 tests of 14.