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 E65FFD1D552 for ; Tue, 13 Jan 2004 20:25:09 +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 26323-09 for ; Tue, 13 Jan 2004 16:24:39 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id D7670D1B52F for ; Tue, 13 Jan 2004 16:24:37 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HRG00I013CQEV@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Wed, 14 Jan 2004 01:54:38 +0530 (IST) Received: from sancharnet.in ([61.0.95.101]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HRG00IUE3CNEF@ndl1mr1-a-fixed.sancharnet.in>; Wed, 14 Jan 2004 01:54:38 +0530 (IST) Date: Wed, 14 Jan 2004 02:00:45 +0530 From: Sai Hertz And Control Systems Subject: Re: Snapshot as Backup In-reply-to: <000901c3d9f8$db4a1cd0$33a48796@ilc.arizona.edu> To: emurphy1@email.arizona.edu Cc: pgsql-admin@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <40045575.60007@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 References: <000901c3d9f8$db4a1cd0$33a48796@ilc.arizona.edu> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/110 X-Sequence-Number: 11973 Dear Ed Murphy , > and all the PostgreSQL files. My question is if I restore this > snapshot will PostgreSQL work? I know if doing a typical file system > backup of PostgreSQL I must first stop the postmaster or the backup > will not produce a useable PostgreSQL system. Is it necessary to stop > the postmaster for this snapshot backup also? > Yes if the snapshot (filesystem) backup and restore is performed when postmaster is NOT running you can reproduce it. I have done this with command dump <-- for file system backup Filesystem ext3 Regards Vishal Kashyap