X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CFB34D1B4F6 for ; Tue, 27 Apr 2004 18:50:04 -0300 (ADT) 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 45340-02 for ; Tue, 27 Apr 2004 18:50:04 -0300 (ADT) Received: from jimsun.LinxNet.com (jimsun.linxnet.com [64.32.196.134]) by svr1.postgresql.org (Postfix) with ESMTP id F33DAD1B448 for ; Tue, 27 Apr 2004 18:50:00 -0300 (ADT) Received: by jimsun.LinxNet.com (Postfix, from userid 332) id 28805430E; Tue, 27 Apr 2004 17:50:03 -0400 (EDT) To: pgsql-admin@postgresql.org Subject: Re: Recover data X-Sun-Charset: US-ASCII Reply-To: pgsql-admin@postgresql.org In-Reply-To: <1083093931.408eb3ab15197@webmail.cefet-al.br> Message-Id: <20040427215003.28805430E@jimsun.LinxNet.com> Date: Tue, 27 Apr 2004 17:50:03 -0400 (EDT) From: jseymour@LinxNet.com (Jim Seymour) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/328 X-Sequence-Number: 13301 eups@cefet-al.br wrote: > > > Hello, > I have a problem and I would like somebody help me. > Well, i have a data base server that was formated, unfortunatelly it wasn't > made the dump of the postgres, but it was saved the directory of the postgres. > How can to recover my data, is it possible? It sounds like what you're saying is that, although you didn't do a dump, from which you can restore, you do have a copy of the old pgsql database directory still intact. If so: Just shut down pgsql, point PGDATA at the old directory (which I would carefully back up, first!) and re-start pgsql. Providing the server version hasn't changed, all should be well. -- Jim Seymour | Spammers sue anti-spammers: jseymour@LinxNet.com | http://www.LinxNet.com/misc/spam/slapp.php http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund: | http://www.spamcon.org/legalfund/