Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jYpfO-0000Z2-Fd for pgsql-general@arkaria.postgresql.org; Wed, 13 May 2020 11:35:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jYpfM-0006Js-Iq for pgsql-general@arkaria.postgresql.org; Wed, 13 May 2020 11:35:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jYpfM-0006Er-A0 for pgsql-general@lists.postgresql.org; Wed, 13 May 2020 11:35:12 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jYpfJ-0002o6-EM for pgsql-general@postgresql.org; Wed, 13 May 2020 11:35:11 +0000 Received: by mail-wm1-x32b.google.com with SMTP id w19so13325572wmc.1 for ; Wed, 13 May 2020 04:35:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=Cl+a2/Mskb5iVIzjaMOb2AW20MR1kLX7M4SJMi2ZAuM=; b=PTgWWBmOLdxRUguhNkBGnb6Ai7gxBst6mCINXH/gI+JW2+zuL8I/uPRTNAVW/dhS9+ JzD2xVdFASIxqXGgZjNtoTu7JQinIn6l3auf1324l2Qt2E8on/p8/CkTdanIpUjVyhUw qYOXoJeSo0qrr/5akFjrrE/qimELgPKSPnsDFTjfrytR+3EHPNAjjH9DXVdjTEYjuWxV cxz+JZO902zJWM9lP3SC3qAoYbZYqlsB66saThwJL6JXSCYMKHjDTVjWnniQKjL6qyFA TAev6zewpKLPc1/mTj4sMlGZBMNtXBV+RpbN0ZPuxTxMkAgspdUfFsSvNztOgwe75w7J fY/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=Cl+a2/Mskb5iVIzjaMOb2AW20MR1kLX7M4SJMi2ZAuM=; b=A7Hvr2ghzRqHyh3bH5way7ELjDaoeYHcR0ruFB49t4aE2muVIlExKLM54R5UBBqZNC jXl2bVkvbAyZwmjDKquHbBRFeKLhu0NnCD/Z8EhAo55sRkCbNy6HMmJ16EQvrzRV1Q6W Wl5UPa4TwUCNYqPo0Qd5ct57xip2CNbcUBcTT29xqewb8x21db+r/Bgyiku/MI9ykK+B ulscRRPX5J0VTK+Y4boH6EI14kefyoT2PGC+Io+LIaFvt/o3eJLgEdC6bSx5Nt834pcU KANwluOyTDYlu8uDmmR+S5MTipS0d/NnumKqO9vs1srqh48Iw1kcEvcrDohcIy/Pimh7 FwQg== X-Gm-Message-State: AGi0PuYC8IqbSoDT8sHcUFeWtKwOx2lddWdK0rZDGscY34zkPn3CHcGo oZw3hUrg5zq0x6U1KHzRcQEsaQ== X-Google-Smtp-Source: APiQypLkG2Y3Ix4C/H7M6SpSX+5Ncl+rcXIriAMRJWtt6pyoEzVAetIffaIpIyYMkmaAE9QTOhzyRw== X-Received: by 2002:a1c:9c0a:: with SMTP id f10mr42739975wme.139.1589369707528; Wed, 13 May 2020 04:35:07 -0700 (PDT) Received: from localhost.localdomain (217-149-168-102.nat.highway.telekom.at. [217.149.168.102]) by smtp.gmail.com with ESMTPSA id j16sm25561497wru.13.2020.05.13.04.35.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 13 May 2020 04:35:07 -0700 (PDT) Message-ID: <4871eb5b1c5127c3c0113cc0da889b93c29afc9b.camel@cybertec.at> Subject: Re: what is the best way to access cold data on another server? From: Laurenz Albe To: Amine Tengilimoglu , "pgsql-general@postgresql.org >> PG-General Mailing List" , pgsql-admin Date: Wed, 13 May 2020 13:35:06 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.32.5 (3.32.5-1.fc30) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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