Moving Postgres table spaces and tables through an EC2 instance

Question

I have a postgres database running on an Amazon EC2 instance. I have few table spaces created for some monthly tables, so each table is in a separate table space. To get maximum performance, I created each table space on a separate amazon ebs volume.

I want to move some of these tables to different instances and a database. I will explain this with one example. Let’s say.

• I have an EC2 A instance with postgres setup as described above.

• I have another instance of Amazon B, and I also installed postgres on it.

• I want to create the same table structure for some of the tables present in on B. I want to separate the volumes from instance A and attach it to instance B.

• Also, I want to create table spaces in instance B, which will point to newly attached volumes.

• And when I run these postgres created, I expect to see tables filled with data from these volumes (databases).

• Finally, I will delete these tables from A

I know that I am rusty in writing, but could not find a better way to ask a question.

Is something possible in this direction? Are there any signs of achieving something like this?

Answer 1

No.

- . , pg_catalog, pg_clog pg_xlog .

, ( , pg_default). pg_dump/pg_restore .