X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7C9783A52F5 for ; Sat, 8 Jan 2005 22:22:30 +0000 (GMT) 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 67656-03 for ; Sat, 8 Jan 2005 22:22:24 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id AE4353A52CA for ; Sat, 8 Jan 2005 22:22:25 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j08MMLRk046290 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sat, 8 Jan 2005 15:22:23 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j08MMLGP014191; Sat, 8 Jan 2005 15:22:21 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j08MMKeV014190; Sat, 8 Jan 2005 15:22:20 -0700 (MST) (envelope-from mfuhr) Date: Sat, 8 Jan 2005 15:22:20 -0700 From: Michael Fuhr To: Jimmy P Mani Cc: "pgsql-admin@postgresql.org" Subject: Re: backup Message-ID: <20050108222220.GA13960@winnie.fuhr.org> References: <48f3cd3a0501042145506b4be5@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <48f3cd3a0501042145506b4be5@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/51 X-Sequence-Number: 15910 On Tue, Jan 04, 2005 at 09:45:35PM -0800, Jimmy P Mani wrote: > i have a backup of pgsql in .tar format > how can i make the database unzipped from that Determine how the tarball was created and use the appropriate restore method. See the "Backup and Restore" chapter in the PostgreSQL documentation for details. If the tarball contains toc.dat, other .dat files, and restore.sql, then the backup was created with pg_dump and you can use pg_restore to restore it. See the documentation for pg_restore. If the tarball contains files like pgsql/base/25819/17187 then it's a file system level backup and you can restore it as you would any other directory structure. Read carefully the "File system level backup" section of the documentation before doing anything. Make sure the postmaster is shut down when you do the restore. If you need more information then please be more specific about what concerns or problems you're having. -- Michael Fuhr http://www.fuhr.org/~mfuhr/