@@ -6475,7 +6475,7 @@ X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
6475
6475
X-Spam-Status: Yes, hits=5.0 required=5.0 tests=RCVD_IN_OSIRUSOFT_COM,X_OSIRU_SPAM_SRC version=2.20
6476
6476
X-Spam-Flag: YES
6477
6477
X-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 $)
6479
6479
X-Spam-Report: Detailed Report
6480
6480
SPAM: -------------------- Start SpamAssassin results ----------------------
6481
6481
SPAM: This mail is probably spam. The original message has been altered
@@ -7503,3 +7503,65 @@ Mike Mascari
7503
7503
mascarm@mascari.com
7504
7504
7505
7505
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
+
0 commit comments