Search Postgresql Archives

How do I store tables on a remote host?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux