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 1hF2VQ-0001hj-IC for pgsql-admin@arkaria.postgresql.org; Fri, 12 Apr 2019 20:10:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hF2VN-0004xT-CO for pgsql-admin@arkaria.postgresql.org; Fri, 12 Apr 2019 20:10:33 +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 1hF2VN-0004x0-0v for pgsql-admin@lists.postgresql.org; Fri, 12 Apr 2019 20:10:33 +0000 Received: from mail-ot1-x342.google.com ([2607:f8b0:4864:20::342]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hF2VK-0006ie-IE for pgsql-admin@postgresql.org; Fri, 12 Apr 2019 20:10:32 +0000 Received: by mail-ot1-x342.google.com with SMTP id 64so9461454otb.8 for ; Fri, 12 Apr 2019 13:10:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=BQ5xrPi4Fsz+VGfWalRrJPUjGJiomtea79vgn4KNPOk=; b=COjrbtSP7Fg1IISfYZ+6qMWtuKmOYTcxhzLCYpQOZuQRQINURCkCFS8N7lJUkGR3di o4NoBHdv7xhZ2OJGD02YLaYHC+epOTqxDs6GRms6nvMeCC7Akze1KvxJGJiA5ux0qbEL lxohj3fg0S6EBGIY7JmbeV+IAaLKEhZTvuyW20r/7R/NZAHTPDWUJtvJXwqwPpflgbvF wdIcPE7tZuf+ZTcRAXvbX49CM40NzU2Mbxdlj+QdsUqg44bUIMrm/hZuUIa9C471ywOk zNXDYKdeLSOn2fx9/gwjyole2WRd1J/ItwW1ozUaUFEnEnkXhYaeXMdHJbENibWaZ6Cp R+6w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=BQ5xrPi4Fsz+VGfWalRrJPUjGJiomtea79vgn4KNPOk=; b=jr7dcB2XXvff8BTZrva7tHfyXu7eOFXqwcl2cFLh6GihVvPHd2KFkXKq1wmwIkGt80 EBZN5u2y+RRPTRAl37eRHN6nPQw3Uxa6Qg+aab8Gwgae+NIm+yCmnLsCYvvN6dV/zycN 6ThM6XJhj9xM3k4mwSSOqsZhrp+wgPr8aDC1DJr8Lbo4SNutRFywMnzUVEJ6cyh5Auz8 Gp7ZgDcxPoyUiXAz692uOA1hZqttljJRmj1G5oRy48WoBRT1VZVXerdPJozgsUuaQvCe d+91UdDehPZB5SSCcW8uMWBsYG0KucAi7EqVCO+5MTn5lMaFlBG0Humbfm6ulqU4HnHu 1rVA== X-Gm-Message-State: APjAAAXYqHVXVFRARQHz1Rzxnr9ePs9ubxq1KqOmZggW/YVFfNWBU2at mBcx4ESHMF86b8tIMihV+WR0g3hpdtM= X-Google-Smtp-Source: APXvYqwr5IgM3PAQupMs0ROcuz1yiIDiOVgUJ8/KhD2qDDQ/HyVr0jqPhQu1ngFqoyUzwfkV6oqiXg== X-Received: by 2002:a9d:172b:: with SMTP id i43mr10055727ota.176.1555099828019; Fri, 12 Apr 2019 13:10:28 -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 q124sm11300435oia.13.2019.04.12.13.10.26 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 12 Apr 2019 13:10:27 -0700 (PDT) To: pgsql-admin From: Ron Subject: pg_dump using anything other than custom and directory Message-ID: <93bf4376-6167-a89f-83c5-36aa0dadae2e@gmail.com> Date: Fri, 12 Apr 2019 15:10:26 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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.