Обсуждение: Re: [GENERAL] Copy a database.

Use the copy command or the pg_dump/pg_dumpall commands.
Copy is done from an admin account in PSQL and pg_dump is run from the
command line.
Search the docs for the commands and you will find how to import the data
back in too.

-----Original Message-----
From: Manik Surtani <manik@post1.com>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Date: Tuesday, February 23, 1999 4:47 AM
Subject: [GENERAL] Copy a database.


>Hi, how do I copy a database?
>
>I currently have a whole bunch of records in a database on one machine.
>I want to copy it all to an identical postgres setup on another
>machine.  I have already created all the necessary tables, with
>identical structures.  i just want to copy the records across.
>
>
>Help much appreciated,
>
>Thanx in advance!
>
>MANIK
>
>