Postgres Pro
Downloads
Home   >   mailing lists

Thread: hi group,,

hi group,,

From
shailesh gavavthe
Date:
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.

Re: hi group,,

From
Hannes Dorbath
Date:
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
similarstructure 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