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 1rf0p8-00Ev1f-N1 for pgsql-general@arkaria.postgresql.org; Tue, 27 Feb 2024 17:00:59 +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 1rf0p5-004A87-FT for pgsql-general@arkaria.postgresql.org; Tue, 27 Feb 2024 17:00:55 +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 1rf0p5-004A7z-55 for pgsql-general@lists.postgresql.org; Tue, 27 Feb 2024 17:00:55 +0000 Received: from sonic308-2.consmr.mail.bf2.yahoo.com ([74.6.130.41]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rf0p1-001Y4l-Ay for pgsql-general@postgresql.org; Tue, 27 Feb 2024 17:00:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709053248; bh=wzSruGQVlOVu3IXJy2832ZDQGY4QOb1BDyWei+fKt+8=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=XUumA6v4omhjXiCet4kOUnzSF+xtnxStWvo22sskKYP3/j/a7+y3Cz5S67f9qxLPWUOo6LyIERxU+z8ACf8ck5O3uIRpIO5Sjj6tWNjQHMUi0eD+CQ7GOhZFcH6Z8rE+ClHzSMBm4spuFLLyuYt8TWy30aDfAsG1RGSWtY8dYIzhdB9rufeK8oXBlWaBBi3j2BmZKVgubK3CpKZ/MPQZqfXMaizLUhdtLYFvzVhAAzvsvd1CjEZZgl/ph2ne3yvq9aKN326GK1fG6x2G09xQoNTpOPevQDG0Z0X5OKAtqkHeufUkHQV3Q8XQcdE5dUdXTkbMpy39FsYYaEroUYUZhA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709053248; bh=yLtG4Iz8xLoUvIfocQtym2o8IyO+Pi0B1KeA4HexJmV=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=JodlSiR+OwjeLvjYCuxU9oHRF8Npb1WZpIud3CO1de9vFtJ0soQZBdadq36hQlickGxV/pnD6/x4K5FkP49i3OBOQEVItyr299plwqQ+qLPyAe3EqTuWq6L0bA7bPqVXccuuQfanXGtjAr3JF6WrsbhX8E7RuPz5vTmk3KNOr5PGDVodmRvmOQveKMadEL08B7QnRWOf9lxV2Lf695KZZ1Z9l0J6+0UitSO1YmlMZ/4cCQNMKmpRt/cXjyb/OZaCfhzoPbZLKxaskYTEnk3+YMven64cM4525S3XN2RbxmhlNb7xUsAenFN4fFG+1NEHkrfjdiE9KFW5/fTrYme1oQ== X-YMail-OSG: TzH1ttIVM1mhSfETrqLp0GDv_5QGAVOXZvcKGXzbJ0JSjslyXfP..Lm9OKXZwrw mr3CYi_QZT8YqHO4GG9.8F28DIHln0XhX6Q7TQic9HtDavHUHnVQ2IfIV36eBpXF9ppEsX5wkPiV JrKrC9S9QD0az4j0AlOsOXPxEWx.xcTKYBhosqUDCixXw1KLtUtOp1w_P9ciCO0tNPm_wWEJbGQ2 fFF4tv7JcR5vCr2eCuSzNBwRHkX23FQ_CXQeNLqy5ZHg.5aaNcKIs0DfZvg0X8awqiW7j9MKnXUx bknBEfbQFmsng6Wa.hR6k67KfxTcAiOCei8K.D5JlgLJO8o7SIUSPKTaurOVz8LDXjcwW4ST9clP IMyZWkye4rGYsgwtEMvCEkwEH3Y5vfCgRs7Og3SP1zZzOkXWZ7I28XZMZfJKTDyL_syQwdAFvf8Y 4Ib93DJUnUPCHw_.JnoaN5xe.JDfJ2qdexIeHliMDurKY0uIeP3ED8b5T0Nb4o3m_EFPNo3nqgC0 d5YeU7W7Cb10gJDQsZPx.n2cbAinqwPZ97QOTcaNLH3ioyz5DlKw8qh5VLTcdl3D_7tbNDbB5SRn Eefpl.x2Sx1m_IPEbMXaR7G35lda8LobRh73A7VbLHsc4SLCrCxL3mk3HM1mK2SeFhkd3tx2nS4s 8KHre7vXQqOswZmCYWwDKallz4MewtLZFM3T.QWf3e4zbFDGBQcSP3U_REk79Llnl3IzZ.Td794A aMPb9SJ3NrDLd0mMNNi0HEz7Z4xH1Yqw_6lt0O49vVrgFKjCfjOVTuSLzAWTNqAI8BPBUvc7AVWy ZPjX8FknxwOxmQLn719XsjU1.Ak0bPhfb6Z9CeN.fdGsoaR8LNY_nJUJi5DvZIp2P3G181jUXVfN nf7Q7xqtgk.QYNw0.aJPWUbmSzwLm7H1.tMv80.e1h3bems23HZd8QAdWD0kDWRfjaJjpBim6FVk 81UftFcZXE6IYOPAY3cSRTyhN5wlU4QZpeorgudnpHo8YfrGhKQpWYRgCUxJEbjGQYh9igV17TN3 c6vVwvcucUwv5oUawqxGnk4AyzX_4i_NGE4PfgNR9lTEIPX8MaUv90E3E_q1hCxlZ5b9CfiqEbDB s8Q.rhAkqJlcYXj.H3f_dKCyKnlCWyVg9FGCr4gdbQymDvReRbh9mZ30xkl9AmTU2K2ziFlF9wNm OYbE5O6K5jBcAo_3XConpihIyO_.xSaDytv6ESU1eexfzuWVzCs.5uhUUlIGN5v7lxuDy7smkr1H 9wyRCBDyXuc4TuU.uFUGZStgAsnRgRAbOidIdq2JqKOmutJ_htlVgJZOPdtkocmuQAPFgbCNbD3J bzBKxz6fGBSBxTPmTx9hh_3RdaZxGVxjkhYPQep6o_bqTpLx4oVux5GP0aP8CW81hI7NYVgWj80Q UUsG0rZNODUXW4E2io9jdFX37YQFBRmE3QyUvZajXA1i0iJLMywfxe48xfYsyMXygREHQD3TiMAR FmSoeli8iFkfUmX9ZgS2MPFIaEfOi6OzdNzHUBx5Wkhf3P_aMwf4KqmXNspr6q1TLrKEe2VuWOEn 8RRqRTyeUyvoSgQVJmKnEpawPuWwjVN2wGTmSJ2PmTOo6_96158ggNUXOytSWrDsxzPgG9Bbq_Y2 WrdwDsFHq00GoBxm6fj7Asbo9tv5bo_LkHuMLSqteyyVSv.l2F8aTO1oTYGaOCTzOMhv5D5qN9wm wPOgcvOtDXuAZtF3ACwIOBeYywsDfc.hnSca60_67tlsEizU_w4KZiJ7sofi8cbwm0Y63udx1M00 sqAOP3mtTH1wf4GNsmAz.eDE2lYrmWGpy6_v_yDTs0MIR9_swJ3nRiydbJtkaGfhhwVNT2Z3EjCc QFqTr0dRBIyqpy3ncgikvnugrqHd7Ku6c.qDaGCRgsCdpYvWtoogPGbL8ZgQN3RJjRt.Y_Vd9ETB fgsJ4NjGpMyaCYpwrOcFhxCceFTVuzqEGIhQ7MFEF3u6ZqGwy.xsG09gbYNUA3.3CoPXsnWfUYOH v.c2tG4ZUZC_zhct_tjDAlmkU65IyZQZtmaRkkzAU81Y22ArLWZgVzMQlsgErCmGhlasHcSv_FD_ gYBIgIP3BRmxGz9szlwMQenT7H9BVOuq73rv67sf8MiIxmptnlX48RqfB_Jq5cyO3813Uqzl_jx3 5rLu9QU.k4fVY3.ClWKf5OE8xtDLvvWomb8guZH6kT_2hWs6197QwMStxTHqnukSZYIMwf83Gpyy mb_uwOq9be7OT7VpCxTC4awcz9s3IIch0LVRPVc88L8_encN7vqM172rePFmgfxgaQM_OalO8i81 _vyNwxlRPD8htOb2U8DVPA5NH5UdYT5c89ZCx4wLigROA3RBJ6ixmBaXIbFLdOPyMTFD84wz6lER zyGpEWHUAcqiUeC0Rypm1kvSlea36XiuWRFQ9SvQInIi1BD8vzlcwCnE- X-Sonic-MF: X-Sonic-ID: 52f76184-c60b-4e2a-9d69-f7875aaccdae Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.bf2.yahoo.com with HTTP; Tue, 27 Feb 2024 17:00:48 +0000 Date: Tue, 27 Feb 2024 17:00:43 +0000 (UTC) From: Jason Long Reply-To: Jason Long To: adrian.klaver@aklaver.com, ronljohnsonjr@gmail.com Cc: Pgsql-general General Message-ID: <730983731.798844.1709053243136@mail.yahoo.com> In-Reply-To: <225b8b45-3e54-4c4e-bf7f-f4a9950621c8@aklaver.com> References: <2131161806.698565.1709023412017.ref@mail.yahoo.com> <2131161806.698565.1709023412017@mail.yahoo.com> <1267802730.758412.1709046484381@mail.yahoo.com> <225b8b45-3e54-4c4e-bf7f-f4a9950621c8@aklaver.com> Subject: Re: PostgreSQL Guard MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_798841_921504017.1709053243134" X-Mailer: WebService/1.1.22103 YahooMailAndroidMobile Content-Length: 2524 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_798841_921504017.1709053243134 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi,Should I read https://www.postgresql.org/docs/current/warm-standby.html#= STANDBY-SERVER-SETUP for question number 2? =20 =20 On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver= wrote: On 2/27/24 07:08, Jason Long wrote: > Hi, > 1- Both split-brain protection and security. Any tool? >=20 > 2-=C2=A0Consider a database related to a website, which data is regularly= =20 > entered. Now you want to transfer this database to another server.=20 > What's the solution? https://www.postgresql.org/docs/current/high-availability.html --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_798841_921504017.1709053243134 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,
Should I read https://www.postgresql.org/docs/current/warm-standby.ht= ml#STANDBY-SERVER-SETUP for question number 2?

On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver
=
<adrian.klaver@aklaver.com> wrote:
= On 2/27/24 07:08, Jason Long wrote:

> Hi,
> 1- Both split-br= ain protection and security. Any tool?
>
> 2- Consider a database related to a website, which data is = regularly
> entered. Now you want to transfer this da= tabase to another server.
> What's the solution?

htt= ps://www.postgresql.org/docs/current/high-availability.html



--
Adrian Klaver
ad= rian.klaver@aklaver.com
<= br clear=3D"none">
------=_Part_798841_921504017.1709053243134--