Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 191121337B34 for ; Wed, 24 Nov 2010 17:15:34 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 53785-02 for ; Wed, 24 Nov 2010 21:15:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from eagle.jhcloos.com (eagle.jhcloos.com [207.210.242.212]) by mail.postgresql.org (Postfix) with ESMTP id C05E01337B85 for ; Wed, 24 Nov 2010 17:15:26 -0400 (AST) Received: by eagle.jhcloos.com (Postfix, from userid 10) id 2ADCF40365; Wed, 24 Nov 2010 21:15:01 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jhcloos.com; s=eagle; t=1290633325; bh=rmlXYCorQTuQgS/8R9chTphd+HFyDd/srz1z5vlq19k=; h=From:To:Cc:Subject:In-Reply-To:References:Date:Message-ID: MIME-Version:Content-Type; b=MfWms0mMfJ8IB8rTtQFaj2RhNFSiV6PUOvzs6iUaSFXzHdZv68bYmCYThMRH2tpxM dLwBoQ39CQ+d5gSWWlnws9KKtJtyFnJ0tgcyR9nmALxANz7oFYwVlXmendRHPZuMtd kL70+HPdKmWaROBMieyVwHWm4l7i4jnMfjkXRyXo= Received: from carbon (localhost [127.0.0.1]) by carbon.jhcloos.org (Postfix) with ESMTP id 2AF4530002B; Wed, 24 Nov 2010 20:59:30 +0000 (UTC) From: James Cloos To: Tom Lane Cc: "Kevin Grittner" , "pgsql-admin" , "Lou Picciano" , jd@commandprompt.com Subject: Re: binary logs: a location other than pg_xlog?? In-Reply-To: <14940.1290453941@sss.pgh.pa.us> (Tom Lane's message of "Mon, 22 Nov 2010 14:25:41 -0500") References: <1557390103.902044.1290397034758.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> <4788.1290402707@sss.pgh.pa.us> <4788.1290402707@sss.pgh.pa.us> <4CEA69F30200002500037D0B@gw.wicourts.gov> <14940.1290453941@sss.pgh.pa.us> User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/24.0.50 (gnu/linux) Face: iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAI1J REFUOE+lU9ESgCAIg64P1y+ngUdxhl5H8wFbbM0OmUiEhKkCYaZThXCo6KE5sCbA1DDX3genvO4d eBQgEMaM5qy6uWk4SfBYfdu9jvBN9nSVDOKRtwb+I3epboOsOX5pZbJNsBJFvmQQ05YMfieIBnYX FK2N6dOawd97r/e8RjkTLzmMsiVgrAoEugtviCM3v2WzjgAAAABJRU5ErkJggg== Copyright: Copyright 2009 James Cloos OpenPGP: ED7DAEA6; url=http://jhcloos.com/public_key/0xED7DAEA6.asc OpenPGP-Fingerprint: E9E9 F828 61A4 6EA9 0F2B 63E7 997A 9F17 ED7D AEA6 Date: Wed, 24 Nov 2010 15:59:30 -0500 Message-ID: Lines: 12 MIME-Version: 1.0 Content-Type: text/plain X-Hashcash: 1:30:101124:tgl@sss.pgh.pa.us::DJpDCYHq8GMpDly3:0000000000000000000000000000000000000000000pgbcH X-Hashcash: 1:30:101124:kevin.grittner@wicourts.gov::6SSYQx1a8IMNfq9B:000000000000000000000000000000000jtkx0 X-Hashcash: 1:30:101124:pgsql-admin@postgresql.org::oeeo178gnM39OXvG:0000000000000000000000000000000000yhCK5 X-Hashcash: 1:30:101124:loupicciano@comcast.net::eptvOu4ow4IhoUKP:0000000000000000000000000000000000000yqoKx X-Hashcash: 1:30:101124:jd@commandprompt.com::rbuRjK3BCoZP3BBm:0000000000000000000000000000000000000000SfIoo X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/217 X-Sequence-Number: 36183 >>>>> "TL" == Tom Lane writes: TL> Here is the problem: what if someday that filesystem happens not to TL> be mounted? Then you have a bare mountpoint directory, with no real TL> way for the postmaster to notice that that wasn't what you intended. TL> Hilarity ensues. That is a convincing argument. -JimC -- James Cloos OpenPGP: 1024D/ED7DAEA6