| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2004-12-01 13:01:19 | Re: copy |
| Previous Message | Sudhakar Kurumella | 2004-12-01 12:46:39 | Linux PostgreSQL to Windows PostgreSQL |