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 1sGgR5-00FuO9-Da for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jun 2024 14:55: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 1sGgR4-00D62v-1C for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jun 2024 14:55:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sGgNz-00D25K-96 for pgsql-hackers@lists.postgresql.org; Mon, 10 Jun 2024 14:52:40 +0000 Received: from mail-il1-x131.google.com ([2607:f8b0:4864:20::131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sGgNx-000wwS-39 for pgsql-hackers@postgresql.org; Mon, 10 Jun 2024 14:52:39 +0000 Received: by mail-il1-x131.google.com with SMTP id e9e14a558f8ab-3758fa1cc8eso200465ab.3 for ; Mon, 10 Jun 2024 07:52:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718031156; x=1718635956; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=HLbiJ405fjFwZyMntyMv6zZRq2+ss1XN2yiobJG44lo=; b=byeYJn5eqK7w5jSPG1oEqgPmPid+jKUO1r8VKVCaW+xDIHuzDXxa0JWx011Bz3jy8m Nzg1pDIB2gG0W8X9WaUUsMwpmsPdanwdBOSQKmq1G6Qng3qvE9r1nYWyWNDASndRr9cH 17X+bKrQLNafl/fZBXMkkeKvpzlW4xvtLsfrZbV/t0/Kz0qkcSjLPoTDPXlOhg3sTzob wgunsDF972O5DkZCS18lFbfHQHR6E/xHiEkGRtrkGskE8SpOhqnHlq9aWUZml5BsDCT7 FfjzSEM53U5qRLDEyZR0JByeBHTfF5AApqyqsfX2VfQjU0e4pX/0ny2D7/nPRmf2upvb K+Hw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718031156; x=1718635956; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=HLbiJ405fjFwZyMntyMv6zZRq2+ss1XN2yiobJG44lo=; b=iyqdQ6miFINECmgoY8MLegdyH58G0Rfw4ZDHLnfFLzAfexoTVJCoHlK4NgvtG+AUDi +MkPGS0ld58O2kP74JBL808vVO8tJhx6HKfg89PmV142SJvpuL093c1wrw/T0Z/seSGt ADIdrk7y+5G6rVqqW22Ix3PXUGVJuOjlrBuJD9tepHelGKg3uCPlQysDCUU737USj26p xTYGAVpjCocXlcElVez7bnMyjjDZN2H0vwk5Hn8iOnOBeNZ/CiLC2gPK0coQhI2S/CS3 QVmfMyKJhxKeDTzHeuzaAqkqleqEfOVKXVKw3PQna1jIRGl5ButbksEX/AqzG17wCtbv 5bhw== X-Gm-Message-State: AOJu0YyVt6ki6s/O3YhMqBps/wXemWzqsbOCauvZYL6RBCqbkF8jDMU+ QxmgEcJzl8mBKQa+HYrnX7IFL5JzFUEcMFk7/UTkRz5b4TbKY8j0 X-Google-Smtp-Source: AGHT+IFOtvBuMk9sRuQt/cciezjFZXsRCp/K5A3TMqFF8zFgGINXhyR5fefuU4pbIcbs4w2txlQK7g== X-Received: by 2002:a05:6e02:1086:b0:375:8a71:4cc1 with SMTP id e9e14a558f8ab-3758a7150e1mr67474055ab.32.1718031155748; Mon, 10 Jun 2024 07:52:35 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-374bc14c92fsm22946795ab.29.2024.06.10.07.52.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 10 Jun 2024 07:52:35 -0700 (PDT) Date: Mon, 10 Jun 2024 09:52:33 -0500 From: Nathan Bossart To: Andrew Dunstan Cc: PostgreSQL-development Subject: Re: Non-text mode for pg_dumpall Message-ID: References: <8dcc13eb-d5a4-4af4-a00e-4470872aa853@dunslane.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8dcc13eb-d5a4-4af4-a00e-4470872aa853@dunslane.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jun 10, 2024 at 10:51:42AM -0400, Andrew Dunstan wrote: > On 2024-06-10 Mo 10:14, Nathan Bossart wrote: >> I'm curious why we couldn't also support the "custom" format. > > We could, but the housekeeping would be a bit harder. We'd need to keep > pointers to the offsets of the per-database TOCs (I don't want to have a > single per-cluster TOC). And we can't produce it in parallel, so I'd rather > start with something we can produce in parallel. Got it. -- nathan