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 EBE05DA496 for ; Thu, 6 Oct 2005 23:32:20 -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 84156-10 for ; Fri, 7 Oct 2005 02:32:10 +0000 (GMT) Received: from web8307.mail.in.yahoo.com (web8307.mail.in.yahoo.com [202.43.219.219]) by svr1.postgresql.org (Postfix) with SMTP id 7E22CD8833 for ; Thu, 6 Oct 2005 23:32:11 -0300 (ADT) Received: (qmail 92051 invoked by uid 60001); 7 Oct 2005 02:32:15 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=YW0Dv3uqTT+f/WkzyCYtSxGmxpdmOPrxCokCIYPDVxHablbCjl3PLipa3wsobr5YMDmo8LDY6k1np42D6NVJ0Vim+iXMg0DGWrLGnMRk4jlNIayrL4pxxD2kVMvOKLsLH9gqkVVP2G9C8WQ79Ov2h8frTwaHAjtMTtMU7eK4WtY= ; Message-ID: <20051007023215.92049.qmail@web8307.mail.in.yahoo.com> Received: from [164.76.128.72] by web8307.mail.in.yahoo.com via HTTP; Thu, 06 Oct 2005 19:32:15 PDT Date: Thu, 6 Oct 2005 19:32:15 -0700 (PDT) From: shailesh gavavthe Subject: hi group,, To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2108979143-1128652335=:91996" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.807 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, HTML_30_40=0.056, HTML_MESSAGE=0.001] X-Spam-Level: * X-Archive-Number: 200510/85 X-Sequence-Number: 19157 --0-2108979143-1128652335=:91996 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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.. thanx in advance.. Shail.. Shailesh gavathe 516 ,St Johns Street, Apt # 102,ypsilanti, MI-48197. Ph : 734-482-0832 URL : http://people.emich.edu/sgavathe --------------------------------- Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. --0-2108979143-1128652335=:91996 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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..
 
thanx in advance..
 
Shail..


Shailesh gavathe
516 ,St Johns Street,
Apt # 102,ypsilanti,
MI-48197.
Ph : 734-482-0832
URL : http://people.emich.edu/sgavathe


Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort. --0-2108979143-1128652335=:91996--