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 B04CCDB966 for ; Thu, 17 Nov 2005 11:48:08 -0400 (AST) 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 53663-04 for ; Thu, 17 Nov 2005 15:48:12 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5BE6ADB91B for ; Thu, 17 Nov 2005 11:48:06 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jAHFm3XA045156 for ; Thu, 17 Nov 2005 15:48:03 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jAHFY3OZ041532 for pgsql-admin@postgresql.org; Thu, 17 Nov 2005 15:34:04 GMT (envelope-from news) From: "codeWarrior" X-Newsgroups: pgsql.admin Subject: Re: restore challenge Date: Thu, 17 Nov 2005 07:36:49 -0800 Organization: Hub.Org Networking Services Lines: 32 Message-ID: References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.891 required=5 tests=[ALL_TRUSTED=-1.44, FORGED_HOTMAIL_RCVD2=0.549] X-Spam-Score: -0.891 X-Spam-Level: X-Archive-Number: 200511/224 X-Sequence-Number: 19597 it doesnt work that way.... this is postgreSQL -- a relational database..... you can't just copy the data directory like you can with mySQL or DBase, or BTrieve or any of the "old-school" databases... if you need to backup and restore data you need to look at pg_dump and pg_dumpall and the import statements in psql... ""Yogvinder Singh"" wrote in message news:012701c5ea9a$dbab31a0$5605a8c0@ng3054... hi, I have the backup of the usr/local/pgsql/data folder can i use this to manually export all the databases to some other same version installation of postgres? if possible, how come... if not possible why ? thnks in advance yogi Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, coping, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unlessthe sender does so expressly with due authority of Newgen Software TechnologiesLtd and / or its subsidiary Companies, as applicable.