what is the best way to access cold data on another server? - Mailing list pgsql-general

From Amine Tengilimoglu
Subject what is the best way to access cold data on another server?
Date
Msg-id CADTdw-yP_n1zDWPzNhBMe4z2siSoeU9rX4M7DLZCbtJfs1ThDQ@mail.gmail.com
Whole thread Raw
Responses Re: what is the best way to access cold data on another server?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: what is the best way to access cold data on another server?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Hello everyone;

    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?



thanks in advance..

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
Next
From: Michael Paquier
Date:
Subject: Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewindfails