Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hF4iW-00009g-A3 for pgsql-admin@arkaria.postgresql.org; Fri, 12 Apr 2019 22:32:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hF4iU-00037Y-If for pgsql-admin@arkaria.postgresql.org; Fri, 12 Apr 2019 22:32:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hF4iU-00037R-77 for pgsql-admin@lists.postgresql.org; Fri, 12 Apr 2019 22:32:14 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hF4iR-0001XV-RC for pgsql-admin@postgresql.org; Fri, 12 Apr 2019 22:32:13 +0000 Received: by mail-ot1-x32c.google.com with SMTP id m10so9793722otp.2 for ; Fri, 12 Apr 2019 15:32:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=Xwk+Qht7qs16tKq2/Z6RydBJuuY6Hk2JIVXeCbz/d1A=; b=U+W3kZwf1T/vB1G/u7WkR3AUegsn7IJlZgWBtDufeGcak6y9ZDtU2zCjSsudNuQEZd ohlGn8Wu+t0dZfDbE54Co3I66swHSTgg3gTMSnqgsdTOALC/ny8kz2W9LNsDfvJB7JTH qJu176gBFd731s7Ed1auF84LosmWS1mgS1VomPhH8nW2uT0pwFXM1bI4US/fi0qIdxL7 xeMmutLJ9DNYjBXPaXYGhTrNMBc/AZQpOk8LjX2dvvbAWvZNyeBR5x3db0mtMw3JPyno m8G3K/88OMB2vXyV+LD/qBiYJv+zrdd5Onv/+5b9otoa6B9VyI3NV2wYyxTgNYPsaPLH Qteg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=Xwk+Qht7qs16tKq2/Z6RydBJuuY6Hk2JIVXeCbz/d1A=; b=SSoPZREE3ZCGnzpkvFl4QxR895NYnsvMEyP8eTCeWKL9mwc5o6JqorrYt9nk7R3bPq CckjFutsryfOXzYGw/ISKTon/SzX7vNg97yTFVLuscu4z9+mkhnswe/zgJWdppB8ziAW mnBv2GUAt61YWj+jjhJilGmP89ccpCPGG5qPc665lZojN5Byd7jG1Cxfy1kCo0BAVvxS xuGmty3PYy2SlnR2l1UGZPy8aQlZGwE2SlLEfJ7UoOSGmtuKrmt51r3q6npU6iH4ZAAD FRZqtT+2HJ5EpII6p717jY3kc6TAM31SwieRJj0MOFcdTf5h1/cqSwPROHARyxaRULAT M6ag== X-Gm-Message-State: APjAAAXd501SgIVfCA4SQXZA9r1e8ezxkNbxCyhKLMQtqKU0DLTtz37h NsJbF6bhCywHiw8cq25XDZ5ejQRqOCo= X-Google-Smtp-Source: APXvYqzWY5d70qRGYqu+5gdxAW/ut1o5xBhGRd11bvv+Iav2FIakeKIV6Kt1CVsj8/1GFYMsZcFwEQ== X-Received: by 2002:a9d:6a56:: with SMTP id h22mr39322808otn.26.1555108329223; Fri, 12 Apr 2019 15:32:09 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id o1sm18691821otj.11.2019.04.12.15.32.08 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 12 Apr 2019 15:32:08 -0700 (PDT) Subject: Re: pg_dump using anything other than custom and directory To: pgsql-admin References: <93bf4376-6167-a89f-83c5-36aa0dadae2e@gmail.com> From: Ron Message-ID: Date: Fri, 12 Apr 2019 17:32:07 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------FB9E287CD9AF5244D7365AB6" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------FB9E287CD9AF5244D7365AB6 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit What makes -Ft and -Fp so much better than -Fc and -Fd at setting up test environments? On 4/12/19 3:50 PM, Derek Viljoen wrote: > Setting up test environments. > > On Fri, Apr 12, 2019 at 3:10 PM Ron > wrote: > > Hi, > > In 2019 using supported versions of PostgreSQL, what practical use is > there > to use the tar format, and -- other than migrating trivially sized > databases > to other RDBMSs -- the plain format? > > Thanks > -- Angular momentum makes the world go 'round. --------------FB9E287CD9AF5244D7365AB6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit What makes -Ft and -Fp so much better than -Fc and -Fd at setting up test environments?

On 4/12/19 3:50 PM, Derek Viljoen wrote:
Setting up test environments. 

On Fri, Apr 12, 2019 at 3:10 PM Ron <ronljohnsonjr@gmail.com> wrote:
Hi,

In 2019 using supported versions of PostgreSQL, what practical use is there
to use the tar format, and -- other than migrating trivially sized databases
to other RDBMSs -- the plain format?

Thanks


--
Angular momentum makes the world go 'round.
--------------FB9E287CD9AF5244D7365AB6--