can a partition be loaded from file?

From: zhangbonian <zhangbonian17(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: can a partition be loaded from file?
Date: 2012-11-01 07:48:29
Message-ID: 79b492f0.a68b.13abaf15677.Coremail.zhangbonian17@163.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have a question that if a partition can be loaded from a file?
A table in the database is partitioned, and each partition is saved to a separate tablespace, so each located in a separate directory. We want to transfer the data in a specific partition (a directory with files in it) to a remote machine then load this partition to the db for processing. The remote DB has the same db schema to the local machine. and the data in this table doesn't depend on other tables. I'm not sure if it is workable. we can stop the database when doing backup (but not the database engine, Postgresql process) for data consistency.
If it is not workable, does the COPY TO file function is the best solution for this situation?
Thanks!

BR,
Emmett Zhang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-11-01 08:05:32 Re: can a partition be loaded from file?
Previous Message Christophe Pettus 2012-11-01 05:44:17 SET PATH / DROP SCHEMA lock conflict