From: Jie Liang <jie@stbernard.com>
To: pgsql-sql@postgresql.org
Subject: FW: RESTORE A TABLE
Date: Fri, 21 Jun 2002 11:32:32 -0700
Message-ID: <7C760DAA511DC74B99E7D22189F786F101BF20E2@MAIL01.stbernard.com> (raw)
I have serveral tables that they have more then 2 millions,
I want dump they out from one server and then restore them back on
another server every day, the questions are:
1. What is the fastest way to dump/restore my data, I am try to use:
pg_dump -aRt mytable -Fc -f mytable dbname
pg_restore -aRt mytable -d dbname mytable
but this takes too long to restore.
2. Is any way to disable unique index checking when loading, then enable
the index after restored?
Jie Liang
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jie@stbernard.com
Subject: Re: FW: RESTORE A TABLE
In-Reply-To: <7C760DAA511DC74B99E7D22189F786F101BF20E2@MAIL01.stbernard.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox