Re: what is the best way to access cold data on another server?

From: Amine Tengilimoglu <aminetengilimoglu(at)gmail(dot)com>
To: Holger Jakobs <holger(at)jakobs(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: what is the best way to access cold data on another server?
Date: 2020-05-13 07:34:35
Message-ID: CADTdw-yYDbwpHL8kipRFhMPH27Ust67S0psAA2Wgdhtz=JD6MQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

I am concerned about the security of fdw. so I actually asked for its
comparison with dblink and wondered if there was any other technique to do
this.

Holger Jakobs <holger(at)jakobs(dot)com>, 13 May 2020 Çar, 10:24 tarihinde şunu
yazdı:

> dblink is outdated, postgres_fdw is current.
>
> Am 13.05.20 um 09:12 schrieb Amine Tengilimoglu:
> > 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..
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-05-13 11:35:06 Re: what is the best way to access cold data on another server?
Previous Message Holger Jakobs 2020-05-13 07:24:41 Re: what is the best way to access cold data on another server?

Browse pgsql-general by date

  From Date Subject
Next Message otar shavadze 2020-05-13 08:13:20 Column reset all values
Previous Message Michael Paquier 2020-05-13 07:25:55 Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails