Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMrXm-0057aD-Mp for pgsql-general@arkaria.postgresql.org; Thu, 27 Jun 2024 16:00:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sMrXj-00BVma-NW for pgsql-general@arkaria.postgresql.org; Thu, 27 Jun 2024 16:00:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMrXj-00BVmQ-CU for pgsql-general@lists.postgresql.org; Thu, 27 Jun 2024 16:00:15 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMrXg-003POK-TS for pgsql-general@lists.postgresql.org; Thu, 27 Jun 2024 16:00:14 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 45RG0Cb01747823; Thu, 27 Jun 2024 12:00:12 -0400 From: Tom Lane To: Dhritman Roy cc: "pgsql-general@lists.postgresql.org" Subject: Re: dblink Future support vs FDW In-reply-to: <609c8cd402e145e2af12bcfe20ac22e1@NetCracker.com> References: <609c8cd402e145e2af12bcfe20ac22e1@NetCracker.com> Comments: In-reply-to Dhritman Roy message dated "Thu, 27 Jun 2024 15:32:13 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1747821.1719504012.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 27 Jun 2024 12:00:12 -0400 Message-ID: <1747822.1719504012@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Dhritman Roy writes: > My organization is building something which is using dblink and what we = are building shall take several months and then to be offered to a client. > I just wanted to check what is the future/roadmap of dblink? > Is it going to be obsolete/removed from PostGreSQL in upcoming versions? I don't foresee us removing it any time soon, because there are things you can do with it that aren't possible in the FDW model (particularly, issue DDL to the remote server). Even if we did kick it out of the core distribution at some point, it could live on as an externally-maintained extension. Having said that, it is a bit of a development backwater, so you should probably not count on anyone being interested enough to add new features to it. regards, tom lane