Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 57D592E0056 for ; Mon, 24 Mar 2008 14:46:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 59133-08-2 for ; Mon, 24 Mar 2008 14:45:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rn-out-0910.google.com (rn-out-0910.google.com [64.233.170.191]) by postgresql.org (Postfix) with ESMTP id 08FFD2E0057 for ; Mon, 24 Mar 2008 14:45:53 -0300 (ADT) Received: by rn-out-0910.google.com with SMTP id e11so1251879rng.17 for ; Mon, 24 Mar 2008 10:45:51 -0700 (PDT) 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=ABGhqwNAMMqcgxILgHImRs4TsTVC1/jBaDzJcn/0ABI=; b=jIXK4iUmfnZbuv3+JEK9WJDX8eIP262aivGR1+CnivTPl+S9GlpN66sw8s073NQFP+gRzsSVXd+VAhix9V2p/khcSGZHeYAncvMyXz2uTu8+bk28nPgKP61RyAdsZUEipLGFX0M9hbVM4SLNscLo6F/QhQ94l2WcGhqALUCZqaI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SDEDOuqiDdhcAuhrAAhUDdYtCzwPqCwcM06HUhhcIpMuGaOK0Zkz5KjTU9nGIzvFnDl0RtXOvlRNVRfp2raH41C71Ppm3BWoY6vkcmW6hlXOWQLZ9o6aMd2i4o0+oMpOQNr/1Kx0n7EZ2bw9ZBj3qF9LKs6I33HL9bEAQ8A+gpw= Received: by 10.114.191.1 with SMTP id o1mr12245343waf.66.1206380750880; Mon, 24 Mar 2008 10:45:50 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Mon, 24 Mar 2008 10:45:50 -0700 (PDT) Message-ID: Date: Mon, 24 Mar 2008 11:45:50 -0600 From: "Scott Marlowe" To: veejar Subject: Re: Database file names Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/193 X-Sequence-Number: 28676 On Mon, Mar 24, 2008 at 8:38 AM, veejar wrote: > Hello! > > We have database PostgreSQL 8.2.3 on FreeBSD 6.0. > After reboot & fsck we have lost many files from base folder in > PostgreSQL PGDATA > Data Recovery Company can only restore files, but without file names. > Is it possible to restore filename by file content or another method? It might be possible to do so, but it's not some simple operation. Do you have a recent backup?