@@ -6475,7 +6475,7 @@ X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
64756475X-Spam-Status: Yes, hits=5.0 required=5.0 tests=RCVD_IN_OSIRUSOFT_COM,X_OSIRU_SPAM_SRC version=2.20
64766476X-Spam-Flag: YES
64776477X-Spam-Level: *****
6478- X-Spam-Checker-Version: SpamAssassin 2.20 (devel $Id: win32,v 1.2 2002/09/16 02:47:05 momjian Exp $)
6478+ X-Spam-Checker-Version: SpamAssassin 2.20 (devel $Id: win32,v 1.3 2002/09/16 02:50:20 momjian Exp $)
64796479X-Spam-Report: Detailed Report
64806480SPAM: -------------------- Start SpamAssassin results ----------------------
64816481 SPAM: This mail is probably spam. The original message has been altered
@@ -7503,3 +7503,65 @@ Mike Mascari
75037503mascarm@mascari.com
75047504
75057505
7506+ From pgsql-hackers-owner+M28774@postgresql.org Thu Sep 12 15:12:54 2002
7507+ Return-path: <pgsql-hackers-owner+M28774@postgresql.org>
7508+ Received: from postgresql.org (postgresql.org [64.49.215.8])
7509+ by candle.pha.pa.us (8.11.6/8.10.1) with ESMTP id g8CJCqE21744
7510+ for <pgman@candle.pha.pa.us>; Thu, 12 Sep 2002 15:12:52 -0400 (EDT)
7511+ Received: from localhost (postgresql.org [64.49.215.8])
7512+ by postgresql.org (Postfix) with ESMTP
7513+ id 77755476CA2; Thu, 12 Sep 2002 15:12:48 -0400 (EDT)
7514+ Received: from postgresql.org (postgresql.org [64.49.215.8])
7515+ by postgresql.org (Postfix) with SMTP
7516+ id 98016476ABD; Thu, 12 Sep 2002 15:12:31 -0400 (EDT)
7517+ Received: from localhost (postgresql.org [64.49.215.8])
7518+ by postgresql.org (Postfix) with ESMTP
7519+ id 3A604476A7F; Thu, 12 Sep 2002 15:12:28 -0400 (EDT)
7520+ Received: from sss.pgh.pa.us (unknown [192.204.191.242])
7521+ by postgresql.org (Postfix) with ESMTP
7522+ id B93FD475D87; Thu, 12 Sep 2002 15:12:20 -0400 (EDT)
7523+ Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
7524+ by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8CJC9Ko009064;
7525+ Thu, 12 Sep 2002 15:12:09 -0400 (EDT)
7526+ To: Curt Sampson <cjs@cynic.net>
7527+ cc: Justin Clift <justin@postgresql.org>,
7528+ PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
7529+ Subject: Re: [HACKERS] PGXLOG variable worthwhile?
7530+ In-Reply-To: <Pine.NEB.4.44.0209130127550.891-100000@angelic.cynic.net>
7531+ References: <Pine.NEB.4.44.0209130127550.891-100000@angelic.cynic.net>
7532+ Comments: In-reply-to Curt Sampson <cjs@cynic.net>
7533+ message dated "Fri, 13 Sep 2002 01:28:39 +0900"
7534+ Date: Thu, 12 Sep 2002 15:12:09 -0400
7535+ Message-ID: <9063.1031857929@sss.pgh.pa.us>
7536+ From: Tom Lane <tgl@sss.pgh.pa.us>
7537+ X-Virus-Scanned: by AMaViS new-20020517
7538+ Precedence: bulk
7539+ Sender: pgsql-hackers-owner@postgresql.org
7540+ X-Virus-Scanned: by AMaViS new-20020517
7541+ Status: ORr
7542+
7543+ Curt Sampson <cjs@cynic.net> writes:
7544+ > On Thu, 12 Sep 2002, Justin Clift wrote:
7545+ >> Am just wondering if we've ever considered adding a PGXLOG environment
7546+ >> variable that would point to the pg_xlog directory?
7547+
7548+ > IMHO, a much better way to support this is to put this information into
7549+ > the config file. That way it can't easily change when you happen to, say,
7550+ > start postgres in the wrong window.
7551+
7552+ Yes. We rejected environment-variable-based xlog location for reasons
7553+ that apply equally well to Windows. The xlog location *must* be stored
7554+ in a physical file in the data directory; anything else is too unsafe.
7555+ The current technology for that is a symlink.
7556+
7557+ While it doesn't have to be a symlink as opposed to some sort of config
7558+ file, I don't have the slightest problem with saying that we don't
7559+ support relocation of xlog on older Windoid platforms.
7560+
7561+ regards, tom lane
7562+
7563+ ---------------------------(end of broadcast)---------------------------
7564+ TIP 5: Have you checked our extensive FAQ?
7565+
7566+ http://www.postgresql.org/users-lounge/docs/faq.html
7567+