Skip site navigation (1) Skip section navigation (2)

Re: Export/Import

From: "Vishal Kashyap (at) [SaiHertz]" <vishalonlist(at)gmail(dot)com>
To: Sudhakar Kurumella <kurumella(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Export/Import
Date: 2004-12-01 12:53:18
Message-ID: 77b69d2104120104534e023ec@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Dear Sudhakar ,


>   
> I am new to PostgreSQL, 

Welcome .

> 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. 



PostgreSQL does not have any GUI tool for that but pg_dump and
pg_restore would do your job.

Please read the docs for more.

http://www.postgresql.org/docs/7.4/interactive/app-pgrestore.html

http://www.postgresql.org/docs/current/static/app-pgdump.html

-- 
With Best Regards,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk

In response to

pgsql-admin by date

Next:From: GeoffreyDate: 2004-12-01 13:01:19
Subject: Re: copy
Previous:From: Sudhakar KurumellaDate: 2004-12-01 12:46:39
Subject: Linux PostgreSQL to Windows PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group