X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B75A59DC9C0 for ; Tue, 28 Mar 2006 12:27:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98992-05 for ; Tue, 28 Mar 2006 12:27:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id E3DBD9DCBEC for ; Tue, 28 Mar 2006 12:27:06 -0400 (AST) Received: by nproxy.gmail.com with SMTP id k27so1122605nfc for ; Tue, 28 Mar 2006 08:27:05 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=aIcbJLLL13N8TSV3lttXM6oyBnp/7YrbCTb3jKSXEg9O50UVEPBlNbx3zOnLddvvOrfTsMxQoXeYwW1I/72draiLCdbWzTE5O4TS1jhZr7BpScHRedu70kDYSsQLaOBDAkwYSv5YPSWgDhY6YN5UPdGD7DarcItTLIZGosyfmto= Received: by 10.49.36.3 with SMTP id o3mr368001nfj; Tue, 28 Mar 2006 08:27:05 -0800 (PST) Received: by 10.49.27.1 with HTTP; Tue, 28 Mar 2006 08:27:05 -0800 (PST) Message-ID: Date: Tue, 28 Mar 2006 21:57:05 +0530 From: "Rajesh Kumar Mallah" To: "Tom Lane" Subject: Re: FW: Setting up of PITR system. Cc: andy.shellam@mailnetwork.co.uk, pgsql-admin@postgresql.org In-Reply-To: <1976.1143559769@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1976.1143559769@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.356 required=5 tests=[AWL=0.023, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.356 X-Spam-Level: * X-Archive-Number: 200603/309 X-Sequence-Number: 21066 Hi, Thanks everyone for the reply, is it reasonable/advisable to start with the output of pg_stop_backup() in a shell script to find the WAL file being discussed, ie the FILE which can be used as a reference for removing the older files ? secondly , i was asking about the tool for copying the database directory not the one for archiving the logs. when i use tar , it gives warning that the file changed while it was reading the file, i need a tool that does not give warning for this kind of activity. Regds Rajesh Kumar Mallah. On 3/28/06, Tom Lane wrote: > "Andy Shellam" writes: > > The DOCs say that filenames numerically less than the WAL record that > > pg_stop_backup() suggests can be removed. Will an alphabetical sorting > > be different from numerically sorted filename ? > > If you're worried about that, try "LANG=3DC ls ..." to make sure the > sorting is done in C locale. I don't know of any locales that would > sort hex numbers differently from C, but maybe there are some. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >