Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1egKyJ-0006OQ-HS for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Jan 2018 01:44:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1egKyI-0007S8-3b for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Jan 2018 01:44:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1egKyH-0007Ry-Pu for pgsql-hackers@lists.postgresql.org; Tue, 30 Jan 2018 01:44:25 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1egKyB-0007NI-1S for pgsql-hackers@postgresql.org; Tue, 30 Jan 2018 01:44:24 +0000 Received: from Davids-iMac.local (unknown [173.169.74.224]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id BE27554662; Tue, 30 Jan 2018 01:44:17 +0000 (UTC) Subject: Re: PATCH: Exclude unlogged tables from base backups To: Masahiko Sawada , Adam Brightwell Cc: Robert Haas , Stephen Frost , PostgreSQL-development References: <04791bab-cb04-ba43-e9c0-664a4c1ffb2c@pgmasters.net> <20171212225234.jqdwd4sp663l4znp@alap3.anarazel.de> <5e428ad7-f37f-6479-aabf-2c8b9318fb79@pgmasters.net> <20171212230740.evr7rvkzz5bztdg6@alap3.anarazel.de> <20171213014804.GH4628@tamriel.snowman.net> <0d94b6fd-71fc-f7f7-790a-2a4cfbea514b@pgmasters.net> <2b2e1879-aa33-afb5-f62d-ea912d5d9887@pgmasters.net> From: David Steele Message-ID: Date: Mon, 29 Jan 2018 20:44:16 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.5.2 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/29/18 8:10 PM, Masahiko Sawada wrote: > On Tue, Jan 30, 2018 at 5:45 AM, Adam Brightwell > wrote: >> On Mon, Jan 29, 2018 at 1:17 PM, David Steele wrote: >>> >>> Whoops, my bad. Temp relations are stored in the db directories with a >>> "t" prefix. Looks like we can take care of those easily enough but I >>> think it should be a separate patch. >>> >>> I'll plan to submit that for CF 2018-03. > > +1 > >> >> I agree, I believe this should be a separate patch. >> >> As for the latest patch above, I have reviewed, applied and tested it. >> >> It looks good to me. As well, it applies cleanly against master at >> (97d4445a03). All tests passed when running 'check-world'. >> >> If it is agreed that the temp file exclusion should be submitted as a >> separate patch, then I will mark 'ready for committer'. > > Agreed, please mark this patch as "Ready for Committer". I marked it just in case some enterprising committer from another time zone swoops in and picks it up. Fingers crossed! -- -David david@pgmasters.net