Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 729E337C6D2 for ; Mon, 12 Nov 2007 12:47:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87159-07 for ; Mon, 12 Nov 2007 12:47:56 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 31B8137C6A7 for ; Mon, 12 Nov 2007 12:47:56 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so919549nzf for ; Mon, 12 Nov 2007 08:47:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=At4jMy9EWbmp2fXBGP1z5kptiukycuS+aKNrh4GtB1o=; b=Z5iJeBf06clyHZlFuWEm8FFv3gUdxJGJjVL6aj+BnPIYpXfjENMF07m+pa4RNOPogVdwWtjKuiTMnsYo54QYJ0TLjf9OE395IheO3YYPXRoA4O2G8AbbB1UbiNdzgBOqman1KRo19zbshQ6m1bHWUbzFpAW2OYttu0B2YiLUNZQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Vl9i5xmk45mvTJzTRGAYQjY3TvxOn6KrRsUEBdfneRnwtw83a4Btar2ikgsT3u0+rd/DUzmR8zjKIyZVV7fzQ9YOuGDakpZTCARrRFVh5eJK/S3ECXUhXpgiZ0ObyAY9kQgHPzmdT9uWk58riJc4i4nReiL9A/X9wVclRn5JRfY= Received: by 10.114.161.11 with SMTP id j11mr1443630wae.1194886073911; Mon, 12 Nov 2007 08:47:53 -0800 (PST) Received: by 10.114.171.20 with HTTP; Mon, 12 Nov 2007 08:47:53 -0800 (PST) Message-ID: Date: Mon, 12 Nov 2007 10:47:53 -0600 From: "Scott Marlowe" To: "joel zimmerli" Subject: Re: HELP: I removed file pg_log, how can I recover? Cc: pgsql-admin@postgresql.org In-Reply-To: <827339.37998.qm@web26107.mail.ukl.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <827339.37998.qm@web26107.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/97 X-Sequence-Number: 27340 On Nov 9, 2007 5:27 PM, joel zimmerli wrote: > > I made a big mistake: I deleted the pg_log file and of course I've no backup > of it. Now it seems I'm facing with big problem with my Postgres > installation! the pg_log directory on my machine just holds pg's log files. No biggie. > Actually, I'm running Postgres on Cobalt Raq4 server and Postgres is used to > administrate virtual website definition. I'm guessing this is an older version of postgresql, and you actually mean you deleted the pg_xlog directory. If this is the case then your database is toast > As this is the "only" file I've deleted, is there a way to recover the data > of this file? pg_resetxlog for your version of postgresql might allow you to get it up and running well enough to dump it out. no promises. google to find it. Search the archives on how it's used. And stop deleting things if you aren't sure what they do (unless you make a backup first, etc...)