Allen Fair <dba@xxxxxxxxxxx> writes: > Looking at the "create tablespace " command in the docs, I was wondering > how easy it is to move a database/tablespace to another server/instance > of PostgreSQL. It's not. The contents of the tablespace are tied to the instance (because rows contain transaction numbers that won't match up with another instance). Also, a tablespace by itself is just a useless pile of bits; you can't access it unless there are system catalog entries for the tables, and there's no way to export selected catalog entries into another instance. It's possible to get around the transaction-numbering problem by doing VACUUM FREEZE before you copy the table files, but I don't see any very workable solution to the catalog-entries problem. You could possibly copy an entire database including its catalogs after freezing the whole thing ... but the tablespace feature certainly does not make that any easier. regards, tom lane
