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 2522B3A46C1 for ; Wed, 1 Dec 2004 13:07:21 +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 03316-08 for ; Wed, 1 Dec 2004 13:07:08 +0000 (GMT) Received: from guppy.vub.ac.be (www.vub.ac.be [134.184.129.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5AD903A558C for ; Wed, 1 Dec 2004 13:07:10 +0000 (GMT) Received: from mach.vub.ac.be (mach.vub.ac.be [134.184.129.8]) by guppy.vub.ac.be (8.9.1b+Sun/3.17.1.ap (guppy)) id OAA08800; Wed, 1 Dec 2004 14:07:08 +0100 (MET) for Received: from olivier.amaze.ulb.ac.be (ucmbsgi10.ulb.ac.be [164.15.109.34]) by mach.vub.ac.be (Postfix) with ESMTP id 9A3B32354 for ; Wed, 1 Dec 2004 14:07:08 +0100 (CET) To: pgsql-admin@postgresql.org Subject: Re: Export/Import References: <20041201123644.51602.qmail@web60401.mail.yahoo.com> Message-ID: Date: Wed, 01 Dec 2004 14:07:07 +0100 From: "Olivier Hubaut" Organization: aMAZE Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <20041201123644.51602.qmail@web60401.mail.yahoo.com> User-Agent: Opera M2/7.54 (MacPPC, build 1840) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/11 X-Sequence-Number: 15597 On Wed, 1 Dec 2004 04:36:44 -0800 (PST), Sudhakar Kurumella wrote: > Hello Everyone, > I am new to PostgreSQL, i have a question, i'll appreciate if anybody > helps me. > How can i export/import a complete database running on one machine to > another machine. I have gone through the docs, what i gather is,,that i > can export only tables only..not entire database like we do in MS SQL > Server. > thanks, > kuru A simple pg_dump -C -f dump.sql dbname should give you what you want. -- Downloading signature ... 99% *CRC FAILED* signature aborted