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 1sVwOT-00CQL2-G0 for pgsql-sql@arkaria.postgresql.org; Mon, 22 Jul 2024 17:00:13 +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 1sVwOR-004L3b-6y for pgsql-sql@arkaria.postgresql.org; Mon, 22 Jul 2024 17:00:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sVwOQ-004L3S-Tv for pgsql-sql@lists.postgresql.org; Mon, 22 Jul 2024 17:00:11 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sVwOP-000urK-4k for pgsql-sql@lists.postgresql.org; Mon, 22 Jul 2024 17:00:10 +0000 Content-Type: multipart/alternative; boundary="------------0MBs1ekIFd1gne0Xe56O50fu" Message-ID: <1e354854-9095-4de5-ab5b-8443ed581818@cloud.gatewaynet.com> Date: Mon, 22 Jul 2024 20:00:00 +0300 MIME-Version: 1.0 Subject: Re: Using replication to upgrade db from 12 to 16 To: pgsql-sql@lists.postgresql.org References: Content-Language: en-US From: Achilleas Mantzios In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------0MBs1ekIFd1gne0Xe56O50fu Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Στις 20/7/24 20:01, ο/η Frank Komsic έγραψε: > > Hi, > > Is it possible to maintain our MASTER db in Pgsql-12 and a replica > database in Pgsql-16 as SLAVE for application testing with the latest > live data? > absolutely > > Thanks > > > Frank > -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only) --------------0MBs1ekIFd1gne0Xe56O50fu Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Στις 20/7/24 20:01, ο/η Frank Komsic έγραψε:

Hi,

Is it possible to maintain our MASTER db in Pgsql-12 and a replica database in Pgsql-16 as SLAVE for application testing with the latest live data?

absolutely

Thanks

Frank

-- 
Achilleas Mantzios
 IT DEV - HEAD
 IT DEPT
 Dynacom Tankers Mgmt (as agents only)

--------------0MBs1ekIFd1gne0Xe56O50fu--