Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u8U1I-0056Bo-5X for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Apr 2025 01:07:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u8U1F-00GwQ6-8B for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Apr 2025 01:07:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u8U1E-00GwPy-Nx for pgsql-hackers@lists.postgresql.org; Sat, 26 Apr 2025 01:07:49 +0000 Received: from mail-ot1-x330.google.com ([2607:f8b0:4864:20::330]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u8U1D-001yrv-0v for pgsql-hackers@postgresql.org; Sat, 26 Apr 2025 01:07:48 +0000 Received: by mail-ot1-x330.google.com with SMTP id 46e09a7af769-72b938f6014so325650a34.3 for ; Fri, 25 Apr 2025 18:07:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745629666; x=1746234466; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=nL+QhdLZfp0iewmmcEFR/MIV+2IoQDwDko4/LpeJppg=; b=FyaT34JGp1gn8xVf0CtGJ9Ug+wa2Ja7s1j5+CyWfWDNGLVMEBfXVBbkf0x6Mze/7+k ezmwzHr2EcE7+SHXVGV/Phha7WiKM5m1+wlmLs1AXMh2OSPgKAUdbXr6knkzB6TYMu9k ynfllW6M0zUFZE3H+mpyxPDucscfk+SKBQekt6plPcinPK645U8YoICMwk59D8ITC1RP +2e20jXy54LvXdQazJpp+BrrFO1GWzT5owo6t0hgS6ozI1XWfDGJIdGhvy8sxlXvAeHB MhBEEhuAHrpDIdd1biDlIRC2SRKr9LVCgyeLeFmVRjYXyaQHhGhuANMkUhMxmcFqIlfQ O7jw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745629666; x=1746234466; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=nL+QhdLZfp0iewmmcEFR/MIV+2IoQDwDko4/LpeJppg=; b=SBsCELQ7RohyX091l0Sx7dekM2MI1Qe6WvZlTuSRd68uRkjjmNnAZGKPCMO/4k15mf 1ITz7UFHBwNV9yHZixLjEKR9PvYjmK2XoeoUG/T5yNwQr8MA0EgJ1jEm5TIgich0AYIL DXG1rOgVFtBEMUWouqcJnwT+tFpGHO1Z3/3YlaQDmSP6eWdNBuZnA+7aBvuUnnNtN0L/ GbxEhQcd7NcItorpa2uv6Y+enzHB+KjZE8FmjNoQr/uklRxq7vmP7fbraKXl2eY28Cfo fQ+l1FWSEhoE+hzDGCDW6+AY0Vm8zbitNBQ7GY4vWQw4kovpIS0vKf16tMLI1pk9D/Mu ik+A== X-Gm-Message-State: AOJu0YxQg+dv77RGuLVFJMmos9igdA8D3hpWjMynyuo0Ilcwf4NsT3xr 59sqAypa1VlQrNkYjwmNzZ1hyUseWwPq3/qn13rrPHnmSsATFhV3deTFOXBfEcvasVrqo5H1HHY 2Mjh6gKnQCq/PwyixwG+e0HTrx/ocT5vP X-Gm-Gg: ASbGncvzocLBboyxheypMphT2OR+nJYY7C2T8DZu9ttHKaLNdZhNiSs5fc5Cc9zYBtu ZB+g7IZOnBOFcGaZUVFxM18o34sNPP47lpOAZnZ2LNkblkySIpVkwBvBSUOGiOv3EyC52D3628t jQzF6hMvS0LiVH+8jsafvNemzi/vpUqLPRf7f/IrUY4LPVUcFc2FbaBBhm X-Google-Smtp-Source: AGHT+IGTI9xREy9tkJ8Ojv/92prHW79HENptoOLyVIH7Rsjg1IdpXUz1opMuskK/XfvYS1bUODOBE34I8/dX2j1k0fQ= X-Received: by 2002:a05:6871:a4c7:b0:2d4:ce45:6986 with SMTP id 586e51a60fabf-2d99d7521d9mr795233fac.4.1745629666464; Fri, 25 Apr 2025 18:07:46 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Thomas Munro Date: Sat, 26 Apr 2025 13:07:09 +1200 X-Gm-Features: ATxdqUGHsTtsjTl8lStOWR68QD87Azx8cmXW5mrtBiQcvEkT2KTvFEbmNN-F3xU Message-ID: Subject: Re: Adding pg_dump flag for parallel export to pipes To: Hannu Krosing Cc: pgsql-hackers@postgresql.org, Nitin Motiani Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 8, 2025 at 7:48=E2=80=AFAM Hannu Krosing wr= ote: > Just to bring this out separately : Does anybody have any idea why pipe c= ommands close inside tests ? > > Re: 003-pg_dump_basic_tests has a few basic validation tests for > correctmflag combinations. We need to write more automated tests in > 002_pg_dump.pl but have been running into some issues with environment > setup due to which certain pipe commands result in the shell process > becoming defunct. These same commands are working fine in manual > testing. We are still looking into this. No comment on the wider project except that it looks generally useful, and I can see that it's not possible to use the conventional POSIX filename "-" to represent stdout, because you need to write to multiple files so you need to come up with *something* along the lines you're proposing here. But I was interested in seeing if I could help with that technical problem you mentioned above, and I don't see that happening with the current patches. Do I understand correctly that the problem you encountered is in some other tests that you haven't attached yet? Could you post what you have so that others can see the problem and perhaps have a chance of helping? I also recommend using git format-patch when you post patches so that you have a place to write a commit message including a note about which bits are WIP and known not to work correctly yet.