Re: How do I store tables on a remote host? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How do I store tables on a remote host?
Date
Msg-id dcc563d10909031924o1b0ff4f8mf856bcf1fc7a1f4a@mail.gmail.com
Whole thread Raw
In response to How do I store tables on a remote host?  (Sergey Samokhin <prikrutil@gmail.com>)
Responses Re: How do I store tables on a remote host?
List pgsql-general
On Thu, Sep 3, 2009 at 6:10 PM, Sergey Samokhin<prikrutil@gmail.com> wrote:
> 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.

The way to do it that makes me cringe, would be to remote mount (NFS,
CIFS) another file system from a remote machine and put the table
there.

The better way is probably to look up pl/proxy and use that.

pgsql-general by date:

Previous
From: 纪晓曦
Date:
Subject: trick problem
Next
From: Gordon Shannon
Date:
Subject: Re: Getting "insufficient data left in message" on copy with binary