# Checking port 13436 # Found port 13436 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=13436 host=/tmp/4_HY9g0JdE Log file: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_main.log [08:04:32.500](0.057s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata --auth trust --username 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 enabled. 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 --wait --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata --log /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_main.log --options --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 48541 # Running: createdb --username regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: createuser --username regress_postgres --superuser regress_  !"x"#$%&'()*+-./0123456 # Running: createdb --username regress_postgres regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~ # Running: createuser --username regress_postgres --superuser regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~ # Running: createdb --username regress_postgres regression # Running: createuser --username regress_postgres --superuser regress_ # Running: createdb --username regress_postgres regression # Running: createuser --username regress_postgres --superuser regress_ # Running: pg_dumpall --roles-only --file /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=13436 host=/tmp/4_HY9g0JdE dbname='regression  !"x"#$%&\'()*+-./0123456' --username regress_ [08:04:38.055](5.555s) ok 1 - pg_dumpall with long ASCII name 1 # Running: pg_dumpall --no-sync --roles-only --file /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=13436 host=/tmp/4_HY9g0JdE dbname='regression789:;<=>?@AXYZ[\\]^_`abcxyz{|}~' --username regress_ [08:04:38.298](0.243s) ok 2 - pg_dumpall with long ASCII name 2 # Running: pg_dumpall --no-sync --roles-only --file /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=13436 host=/tmp/4_HY9g0JdE dbname='regression' --username regress_789:;<=>?@AXYZ[\]^_`abcxyz{|}~ [08:04:38.426](0.128s) ok 3 - pg_dumpall with long ASCII name 3 # Running: pg_dumpall --no-sync --roles-only --file /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/discard.sql --dbname port=13436 host=/tmp/4_HY9g0JdE dbname='regression' --username regress_  !"x"#$%&'()*+-./0123456 [08:04:38.570](0.144s) ok 4 - pg_dumpall with long ASCII name 4 # Running: pg_dumpall --no-sync --roles-only --username regress_postgres --dbname 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; -- -- PostgreSQL database cluster dump complete -- [08:04:38.730](0.160s) ok 5 - pg_dumpall --dbname accepts connection string # Running: createdb --username regress_postgres foo bar # Running: pg_dumpall --no-sync --username regress_postgres --file /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'" [08:04:39.323](0.593s) ok 6 - pg_dumpall with \n\r in database name # Running: dropdb --username regress_postgres foo bar # Running: pg_dump --format directory --no-sync --jobs 2 --file /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/dirfmt --username regress_  !"x"#$%&'()*+-./0123456 port=13436 host=/tmp/4_HY9g0JdE dbname='regression  !"x"#$%&\'()*+-./0123456' [08:04:39.979](0.656s) ok 7 - parallel dump # Running: dropdb --username regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: createdb --username regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: pg_restore --verbose --dbname template1 --jobs 2 --username 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: executing SELECT pg_catalog.set_config('search_path', '', false); pg_restore: processing item 4021 ENCODING ENCODING pg_restore: processing item 4022 STDSTRINGS STDSTRINGS pg_restore: processing item 4023 SEARCHPATH SEARCHPATH pg_restore: processing item 4024 DATABASE regression  !"x"#$%&'()*+-./0123456 pg_restore: processing item 219 TABLE t0 pg_restore: creating TABLE "public.t0" pg_restore: entering main parallel loop pg_restore: launching item 4018 TABLE DATA t0 pg_restore: launching item 4025 STATISTICS DATA t0 pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false); pg_restore: finished item 4025 STATISTICS DATA t0 pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false); pg_restore: processing data for table "public.t0" pg_restore: finished item 4018 TABLE DATA t0 pg_restore: finished main parallel loop pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false); [08:04:40.245](0.265s) ok 8 - parallel restore # Running: dropdb --username regress_postgres regression  !"x"#$%&'()*+-./0123456 # Running: pg_restore --create --verbose --dbname template1 --jobs 2 --username 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: executing SELECT pg_catalog.set_config('search_path', '', false); pg_restore: processing item 4021 ENCODING ENCODING pg_restore: processing item 4022 STDSTRINGS STDSTRINGS pg_restore: processing item 4023 SEARCHPATH SEARCHPATH pg_restore: processing item 4024 DATABASE regression  !"x"#$%&'()*+-./0123456 pg_restore: creating DATABASE "regression  !"x"#$%&'()*+-./0123456" pg_restore: connecting to new database "regression  !"x"#$%&'()*+-./0123456" pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false); pg_restore: processing item 219 TABLE t0 pg_restore: creating TABLE "public.t0" pg_restore: entering main parallel loop pg_restore: launching item 4018 TABLE DATA t0 pg_restore: launching item 4025 STATISTICS DATA t0 pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false); pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false); pg_restore: processing data for table "public.t0" pg_restore: finished item 4018 TABLE DATA t0 pg_restore: finished item 4025 STATISTICS DATA t0 pg_restore: finished main parallel loop pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false); [08:04:40.525](0.280s) ok 9 - parallel restore with create # Running: pg_dumpall --no-sync --file /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql --username regress_  !"x"#$%&'()*+-./0123456 [08:04:42.517](1.993s) 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; -- -- Databases -- -- -- Database "template1" dump -- \connect template1 -- -- PostgreSQL database dump -- -- Dumped from database version 18beta1 -- Dumped by pg_dump version 18beta1 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; -- -- Data for Name: t0; Type: TABLE DATA; Schema: public; Owner: regress_postgres -- COPY public.t0 FROM stdin; \. -- -- Statistics for Name: t0; Type: STATISTICS DATA; Schema: public; Owner: - -- SELECT * FROM pg_catalog.pg_restore_relation_stats( 'version', '180000'::integer, 'schemaname', 'public', 'relname', 't0', 'relpages', '0'::integer, 'reltuples', '-1'::real, 'relallvisible', '0'::integer, 'relallfrozen', '0'::integer ); -- -- PostgreSQL database dump complete -- -- -- Database "postgres" dump -- \connect postgres -- -- PostgreSQL database dump -- -- Dumped from database version 18beta1 -- Dumped by pg_dump version 18beta1 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 18beta1 -- Dumped by pg_dump version 18beta1 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; \encoding SQL_ASCII \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; -- -- Data for Name: t0; Type: TABLE DATA; Schema: public; Owner: regress_postgres -- COPY public.t0 FROM stdin; \. -- -- Statistics for Name: t0; Type: STATISTICS DATA; Schema: public; Owner: - -- SELECT * FROM pg_catalog.pg_restore_relation_stats( 'version', '180000'::integer, 'schemaname', 'public', 'relname', 't0', 'relpages', '0'::integer, 'reltuples', '-1'::real, 'relallvisible', '0'::integer, 'relallfrozen', '0'::integer ); -- -- PostgreSQL database dump complete -- -- -- Database "regression789:;<=>?@AXYZ[\]^_`abcxyz{|}~" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 18beta1 -- Dumped by pg_dump version 18beta1 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; \encoding SQL_ASCII \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 18beta1 -- Dumped by pg_dump version 18beta1 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; \encoding SQL_ASCII \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 18beta1 -- Dumped by pg_dump version 18beta1 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; \encoding SQL_ASCII \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 13437 # Found port 13437 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=13437 host=/tmp/4_HY9g0JdE Log file: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_envar.log [08:04:42.535](0.018s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata --auth trust --username 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 enabled. 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 --wait --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata --log /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_envar.log --options --cluster-name=destination_envar start waiting for server to start.... done server started # Postmaster PID for node "destination_envar" is 49420 # Running: createuser --username boot --superuser regress_a'b\c=d\ne"f # Running: psql --no-psqlrc --file /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 pg_restore_relation_stats --------------------------- t (1 row) 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 pg_restore_relation_stats --------------------------- t (1 row) 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 [08:04:48.095](5.559s) ok 11 - restore full dump using environment variables for connection parameters [08:04:48.095](0.001s) not ok 12 - no dump errors [08:04:48.095](0.000s) [08:04:48.095](0.000s) # Failed test 'no dump errors' # at t/010_dump_connstr.pl line 269. [08:04:48.096](0.000s) # got: 'psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:80: error: invalid command \. # psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:197: error: invalid command \. # ' # expected: '' # Checking port 13438 # Found port 13438 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=13438 host=/tmp/4_HY9g0JdE Log file: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_cmdline.log [08:04:48.113](0.017s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata --auth trust --username 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 enabled. 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 --wait --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata --log /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/010_dump_connstr_destination_cmdline.log --options --cluster-name=destination_cmdline start waiting for server to start.... done server started # Postmaster PID for node "destination_cmdline" is 49800 # Running: createuser --username boot --superuser regress_a'b\c=d\ne"f # Running: psql --port 13438 --username regress_a'b\c=d\ne"f --no-psqlrc --file /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 pg_restore_relation_stats --------------------------- t (1 row) 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 pg_restore_relation_stats --------------------------- t (1 row) 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 [08:04:52.534](4.421s) ok 13 - restore full dump with command-line options for connection parameters [08:04:52.535](0.000s) not ok 14 - no dump errors [08:04:52.535](0.001s) [08:04:52.535](0.000s) # Failed test 'no dump errors' # at t/010_dump_connstr.pl line 307. [08:04:52.535](0.000s) # got: 'psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:80: error: invalid command \. # psql:/tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/backup/plain.sql:197: error: invalid command \. # ' # expected: '' [08:04:52.536](0.000s) 1..14 ### Stopping node "main" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_main_data/pgdata --mode 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 --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_envar_data/pgdata --mode 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 --pgdata /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_010_dump_connstr_destination_cmdline_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "destination_cmdline" [08:04:52.953](0.418s) # Looks like you failed 2 tests of 14.