On 11/01/12 12:48 AM, zhangbonian wrote:
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?
no, that won't work, as there is a whole lot of metadata in the system
catalog that won't travel with that data, further, the OID's can be
different from system to system.
I would use: pg_dump -Fc -t partitionname -f dumpfile dbname
then restore this data on the other system with pg_restore ...
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
