Thread: Export/Import
Hello Everyone,
I am new to PostgreSQL, i have a question, i'll appreciate if anybody helps me.
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.
thanks,
kuru
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
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
On Wed, 1 Dec 2004 04:36:44 -0800 (PST), Sudhakar Kurumella <kurumella@yahoo.com> wrote: > Hello Everyone, > I am new to PostgreSQL, i have a question, i'll appreciate if anybody > helps me. > 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. > thanks, > kuru A simple pg_dump -C -f dump.sql dbname should give you what you want. -- Downloading signature ... 99% *CRC FAILED* signature aborted
You would be wanting to use pg_dump It's pretty quick and efficient. Try its man page or docs. Hal On Wed, 1 Dec 2004, Sudhakar Kurumella wrote: > Hello Everyone, > > I am new to PostgreSQL, i have a question, i'll appreciate if anybody helps me. > > How can i export/import a complete database running on one machine to another machine. I have gone through the docs, whati gather is,,that i can export only tables only..not entire database like we do in MS SQL Server. > > thanks, > kuru > > > --------------------------------- > Do you Yahoo!? > Yahoo! Mail - You care about security. So do we.