Postgres Pro
Downloads
Home   >   mailing lists

Re: Exporting database - Mailing list pgsql-admin

From Anthony E. Greene
Subject Re: Exporting database
Date
Msg-id 3.0.5.32.20000629152926.007c2bb0@fmol.5sigcmd.army.mil
Whole thread Raw
In response to Exporting database  ("Anupam Sanghera" <anupams@sapientinfotech.com>)
List pgsql-admin
Tree view 
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@pobox.com>
 PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
 Linux: The choice of a GNU Generation.

pgsql-admin by date:

Previous
From: Karel Zak
Date:
Subject: Re: URGENT PROBLEM: connection time-outs of postgresql backend/frontend
Next
From: "Irfan Qaiser"
Date:
Subject: problem in pg_hba.conf file