Re: Exporting database

From: "Anthony E(dot) Greene" <agreene(at)pobox(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Exporting database
Date: 2000-06-29 13:29:26
Message-ID: 3.0.5.32.20000629152926.007c2bb0@fmol.5sigcmd.army.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

At 17:01 2000-06-26 +0530, Anupam Sanghera wrote:
>
>How can I export a postgres database to another server ?
>

Put the data into a file like this:

psql -D dbname dbname.dump.gz

Then copy the file to the new machine and do this:

createdb dbname
psql dbname < dbname.dump

Tony
--
Anthony E. Greene <agreene(at)pobox(dot)com>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Linux: The choice of a GNU Generation.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2000-06-29 15:37:03 Re: Mergin a old dir with current system
Previous Message Karel Zak 2000-06-29 09:50:56 Re: URGENT PROBLEM: connection time-outs of postgresql backend/frontend