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 365C0DA508 for ; Fri, 7 Oct 2005 06:04:54 -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 59395-04 for ; Fri, 7 Oct 2005 09:04:50 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 824AADA52B for ; Fri, 7 Oct 2005 06:04:51 -0300 (ADT) 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 j9794maH081557 for ; Fri, 7 Oct 2005 09:04:48 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j978gdhA024157 for pgsql-admin@postgresql.org; Fri, 7 Oct 2005 08:42:39 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: hi group,, Date: Fri, 07 Oct 2005 10:42:54 +0200 Organization: Hub.Org Networking Services Lines: 19 Message-ID: References: <20051007023215.92049.qmail@web8307.mail.in.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <20051007023215.92049.qmail@web8307.mail.in.yahoo.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.46 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.360] X-Spam-Level: X-Archive-Number: 200510/87 X-Sequence-Number: 19159 http://www.postgresql.org/docs/8.0/interactive/backup.html http://www.postgresql.org/docs/8.0/interactive/app-pgdump.html http://www.postgresql.org/docs/8.0/interactive/app-pgrestore.html On 07.10.2005 04:32, shailesh gavavthe wrote: > Am Shail,,Newbie to the group.. > using postgreSQL 8.0.. > Its working fine with the schema and tablespaces.. > My question is.. > How will you transfer the data i.e. tables, schemas of postgresql 8.0 from one server to the another server.. > Is there any package comes with postgreSQL to import, export or transfer the data.. > as far as i know,,i will have to create new table space, news schemas for every new installation, even if i have the similar structure on my other machine.. > And i wanted to avoid that.. > I need to use the same data for my another project, but to be on another server.. > Ne help would be much appreciated.. -- Regards, Hannes Dorbath