Postgresql: sharing a database between different machines

Question

I want to break up a very large PostgreSQL 8.3 database. Quote guide ,

Separation can provide several benefits:

...

Rarely used data can be migrated to a cheaper and slower media storage.

What is the right way to move tables to another media or computer? Adam

Answer 1

What you are talking about is usually called replication or clustering, depending on how the system is configured.

What you want to do is clustering, and you can do it on PostgreSQL .

:

• Greenplum ( Bizgres MPP), . , . ExtenDB, PostgreSQL.
• GridSQL EnterpriseDB Advanced Server ( ExtenDB)
• sequoia (jdbc, c-jdbc)
• PL/Proxy - , PL.
• HadoopDB - MapReduce backgres back end. .