X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 58282D7990 for ; Tue, 11 Oct 2005 22:20:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52485-03 for ; Wed, 12 Oct 2005 01:20:26 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id AE339D798D for ; Tue, 11 Oct 2005 22:20:28 -0300 (ADT) Received: from localhost (av.hub.org [200.46.204.144]) by hub.org (Postfix) with ESMTP id 44A1B64B878 for ; Tue, 11 Oct 2005 22:20:33 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46718-05 for ; Wed, 12 Oct 2005 01:20:23 +0000 (GMT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 1505B64B938 for ; Tue, 11 Oct 2005 22:20:27 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 41E7C3BBF9; Tue, 11 Oct 2005 22:20:31 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 40CD33BBA6 for ; Tue, 11 Oct 2005 22:20:31 -0300 (ADT) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Tue, 11 Oct 2005 15:15:47 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 3547B3D8A7 for ; Tue, 11 Oct 2005 15:15:47 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5.2) for scrappy@localhost (single-drop); Tue, 11 Oct 2005 15:15:47 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.12) with LMTPA; Tue, 11 Oct 2005 15:12:48 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2D095D7295 for ; Tue, 11 Oct 2005 15:12:48 -0300 (ADT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86548-05 for ; Tue, 11 Oct 2005 18:12:45 +0000 (GMT) X-Received: from mxfep02.bredband.com (mxfep02.bredband.com [195.54.107.73]) by svr1.postgresql.org (Postfix) with ESMTP id 6C07FD7282 for ; Tue, 11 Oct 2005 15:12:43 -0300 (ADT) X-Received: from kakmonster.int.dactylis.com ([213.114.232.12] [213.114.232.12]) by mxfep02.bredband.com with ESMTP id <20051011181243.KDIR11792.mxfep02.bredband.com@kakmonster.int.dactylis.com> for ; Tue, 11 Oct 2005 20:12:43 +0200 X-Received: from [192.168.100.1] ([192.168.100.1]) (authenticated bits=0) by kakmonster.int.dactylis.com (8.13.4/8.13.4) with ESMTP id j9BICeBV021829 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Tue, 11 Oct 2005 20:12:42 +0200 Message-ID: <434C0098.1010300@better.se> Date: Tue, 11 Oct 2005 20:12:40 +0200 From: Marcus Better User-Agent: Debian Thunderbird 1.0.2 (X11/20050602) X-Accept-Language: en-us, en MIME-Version: 1.0 To: psql-admin@postgresql.org Subject: Restoring database from alternative location X-Enigmail-Version: 0.91.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH authentication, not delayed by milter-greylist-2.0 (kakmonster.int.dactylis.com [192.168.1.2]); Tue, 11 Oct 2005 20:12:42 +0200 (CEST) X-Scanned-By: MIMEDefang 2.53 on 192.168.1.2 X-Virus-Scanned: by amavisd-new at hub.org ReSent-Date: Tue, 11 Oct 2005 22:20:27 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-admin@postgresql.org ReSent-Subject: Restoring database from alternative location ReSent-Message-ID: <20051011222027.W1477@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.946 required=5 tests=[AWL=0.896, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/178 X-Sequence-Number: 19250 Hi all, I used initlocation to create a database in some directory other than the default, with Postgresl 7.4. I have a file-system level backup of this data directory, but the main data directory (which did not contain any real data) was lost. Is there a way to restore the database from this backup? The backed-up directory has the following layout: base base/17142 base/17142/{lots of files here} Can I add this data directory to a fresh Postgresql installation? I would be very grateful for any comments on this problem! I am running Postgresql 7.4 on Debian i386. Please CC replies to me, since I'm not (yet) subscribed to the list. Regards, Marcus B.