X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CFFD6D1B438 for ; Mon, 5 Jan 2004 22:35:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83737-01 for ; Mon, 5 Jan 2004 18:34:27 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id D27ECD1B43A for ; Mon, 5 Jan 2004 18:34:26 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i05MYQU6030231 for ; Mon, 5 Jan 2004 22:34:26 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i05MA8sB017351 for pgsql-admin@postgresql.org; Mon, 5 Jan 2004 22:10:08 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: postgresql crushed with XLogWrite error Date: Mon, 05 Jan 2004 16:36:16 -0500 Organization: Hub.Org Networking Services Lines: 37 Message-ID: <60k746yt67.fsf@dev6.int.libertyrms.info> References: <20040105134913.GA930@libertyrms.info> <20040105140953.GC930@libertyrms.info> <20040105162308.GF930@libertyrms.info> <20040105173920.GO930@libertyrms.info> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:F8xnNip5SL6Chlo+aM6vlbusvNs= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/66 X-Sequence-Number: 11929 andrew@libertyrms.info (Andrew Sullivan) writes: > On Mon, Jan 05, 2004 at 07:35:16PM +0200, Tsirkin Evgeny wrote: >> On Mon, 5 Jan 2004 11:23:08 -0500, Andrew Sullivan >> wrote: >> >> I want to keep my configs.Of course i can save my postgresql.conf >> (and other files that i changed and don't currently remember) >> to another location and then put it back in place of what rpm will >> put ,but as i said ,i don't actually remember what i have changed :( > > The only things that should make a difference to you should be in the > /etc directory, assuming the RPM follows the filesystem standard (I > believe it does). My suggestion is to back everything up, then > replace the RPM in the standard way, and then compare the files one > at a time to see what's different. I'll bet the binaries and > libraries, of course, and things under /etc/[postgres?]/, and that's > it. Most likely, it'll be postgresql.conf and pg_hba.conf, and maybe > pg_ident.conf. It's easy enough to check what files the RPM intends to update... bash-2.05a$ rpm -q -p -l netpbm-devel-9.24-3.i386.rpm /usr/include/pam.h /usr/include/pammap.h /usr/include/pbm.h /usr/include/pbmshhopt.h /usr/include/pgm.h /usr/include/pm.h ... other files omitted ... That can diminish how much is in the "everything" that needs to be backed up... -- let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];; Christopher Browne (416) 646 3304 x124 (land)