How do I store tables on a remote host?

From: Sergey Samokhin <prikrutil(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How do I store tables on a remote host?
Date: 2009-09-04 00:10:33
Message-ID: e42595410909031710g51ca017fr310339c23e7755bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

Is this possible to move a table from one machine to another and then
redirect queries involving this table to the remote host in a
transparent way?

As I have just read, tablespaces let us define where given tables
should be stored on the file system. What I'm looking for is like
tablespaces, but with the ability to use a remote host as location.

Although it of course will make any queries that need remote tables to
look at slower, I think it's a good idea to move, say, old fragments
of table containing log entries to remote machines.

An exotic idea to use both remote file systems and tablepaces has just
come to my mind, but I have a feel that there may be an analouge built
into PG.

Thanks.

--
Sergey Samokhin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2009-09-04 00:10:44 Re: column level, uid based authorization to update columns
Previous Message Christopher Condit 2009-09-03 23:21:48 Re: query speed question