From: | "K(dot)T(dot)" <kanet(at)calmarconsulting(dot)com> |
---|---|
To: | <manik(at)post1(dot)com>, <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Copy a database. |
Date: | 1999-02-23 10:18:00 |
Message-ID: | 000f01be5f15$dc84df80$3cd8a5ce@p2-400-death |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)post1(dot)com>
To: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1999-02-23 10:39:47 | Re: [GENERAL] Transaction logging |
Previous Message | Tom Ivar Helbekkmo | 1999-02-23 10:07:19 | Re: [GENERAL] Copy a database. |