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
>
>
>
>
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? |
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 |