[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] Exporting database
From: "Anthony E. Greene" <agreene () pobox ! com>
Date: 2000-06-29 13:29:26
[Download RAW message or body]
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.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic