On Wed, 2020-05-13 at 10:12 +0300, Amine Tengilimoglu wrote:
> In addition to the actively used data, there are other data that are very little accessed.
> I want to separate the less used data to save space and reduce maintenance operations.
> I want to use a separate postgres instance for this. Now the question is; How do I link
> these two instances? postgres_fdw or dblink? or what other solution? Which one would be better?
Foreign Data Wrapper is a good option, and yes, it is secure.
Another option would be to store these data as CSV files and use file_fdw
to define them as "external tables".
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com