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 1rez49-00Ejed-N9 for pgsql-general@arkaria.postgresql.org; Tue, 27 Feb 2024 15:08:22 +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 1rez48-003iqM-3C for pgsql-general@arkaria.postgresql.org; Tue, 27 Feb 2024 15:08:20 +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 1rez47-003iqE-D4 for pgsql-general@lists.postgresql.org; Tue, 27 Feb 2024 15:08:20 +0000 Received: from sonic312-20.consmr.mail.bf2.yahoo.com ([74.6.128.82]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rez44-001U6q-5U for pgsql-general@postgresql.org; Tue, 27 Feb 2024 15:08:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709046492; bh=1Pg8xF+nhFJaju2Qa6xZUhaEUWO70GDNs3AfsQZc5Vs=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=DeJJHrwj3vIQ/T17bduhtOy/0+zrFCcLx2uteWURl1tMZ7PppdR0lPD9wLq4exuxLBkxeUuFGvuCMrAWtNrTUQ1KM7bMyzCxcA1eXv1ZBMZNxRHaVqJ2DNMj0Dq1krI3JhU5Uvy9bipNhtA9x4Ih15KEB2KkBLxnHLf9n7/xf0DuiiGRT9RxT7HNUIPkc4HDUVqTARvHErYy18AjXjDziWncKO3MdKDKXfxncFP/JN7DKYcdMvM3DpjFiX4+U0L2DApifQZuC+MDr/+B/ZoQ9oPP6i8u3HGHU6ngOowN2WGrXGdOSvoyHTVMs580SWqtaSne6I74VTw4iThnHVMfvQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709046492; bh=7c7TQLwGvgkhqJT/2J1uQXmV3ezq3OfiQLVkKbhTSfZ=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=aEscZy6KxoMlh/scXeoEExz/lk9qFwCu0UR9hXjBi5BzM765KXQI7isbeegFQlOHratAmCG2JepNIDX/kJ2rwmD0xKwOi+2VZuXhReQRaPSDKHcWRcAi3D0JZ2wq3g5hIZzGYmQSEK0HDdHoAselSIwiHFygT6MyNBWwdXAAyMrh4YCh9rR5t+8hptORD/Hi20f2Uiw5i4XtapprXjIoRZCN0i2loJ0UhlKrzqOpnuhBD+cv1u+UHjfzIe8fa0FZjqKL3b0+kNkYEEKoQ0n87esvY6dewPP06mq+RL3l2vE7o+Y5ChPe0sOpwaGBWt665iS4lRWE5Pdc0Zz07MzkjQ== X-YMail-OSG: TMzxw1gVM1kFfOjLktC4HW3ERHL1y_smrfdR2WL3tZeJzRJphAeOOMriHCBjsBl fCBkkYaWAz9JkH2ZgcszaJUd0CK57_ruGqySdJhoeKaaKhHSRgFXb_v6vdN7Jl0.DtVSFkfzM8RV L3kTJltyRdKmk4TDbXFN1CLPTMdAybYqvh5JL3CfQc5w_6hDfNOd3qoFJfFHqy4g1yQO5Zod8UCp qZZ2ZU1DC.Wlh1hSCe3hzNstXbvhGkuaAcWGZCokUApMz2vrL8rXjvkVoEB8wqQY21ESsWKsWlvZ 98KRjiMG.4dpO59.5L9aakLPjg.FeQrX8u0RNI1HtddoKZv.0KaxhU235J4eVdzJ2JY4FU64Y28B NYu2tShEwKROqznYteUCYeAif0f4Fp6yf1tCqTIflgLHTRcVKzMaNxfupyGyePIk.CQ_7j_gjNzW q_LZaIEEYwHWfoiF6e0mnrLxr9YqRxGYDbjWdfjJ5wdhaSbzbF7eI.c.QFsuYBxfZLc3R9xm9UJk uVGHDq2b1lA1q9SCXXU8mQH8S988QlcRNP7dHrMw6v7ruSsMmJio_5A383z80YgO.blKvoPKDRST S.JtalH_70Hds2TblXtf8VuoHmEet7Aud21f._AXDIiMVkK2DqwrbdtPiIpveX9wNgCCqNUJw3oN Xmp27OKpTFOceh3f9ZqixTsEpEd0em1XcK1KvICNJR4jC2ih0Wcp7sdFwuPCpJ3ldtkG5myz7YYZ 8Br7Zd9w6Ya3E7.MfFHEo35VpaGp2_X.3ONIRouW9.0vSd48RKI1wXl2U8MrgBdU_AiBZOSj5A26 uq0ovajmDFMctbP0eQaiaa.0s6WQmAliIvnTi0DKhUNjQ03QpmJJKjj1cto__l48ZW1pdRLNUvmx HBFvIxSgNuPqovdpAWj7rATdX_DCsp6bqZ0f3aAhHb74kqGPw1h65wKmkFZ0TrqT7cKDDoIJLo.G 92ah.63pLl95WohnMBKuwJxohQfIf42jhucXl_awpEkOFNBmAjMo6tI51DJTIHvXusISqYhXtWSX IXDXIofwWOM0BZET4uwY2PlEbarwHs.FC6e5s0zyFA1M4YUouvxk3Xm_OClA8UYRQ6VYPlwvQCTo t_RMCMbkcBiFy02xOPMphueiLX9r_BKFzIqpjlVk.Kc7.z_xb6vyRl2IZglgteTcy3RebFBwqH.n 38mRDO.t.ovPOnHjBi4UzcssbABO13dMoT.G0MraLtpC5KBz596__x.DbAty7STtChYRZAm6KO25 xJI40HSRlOCDmWsP7ioNKufrhXBW9SwOztKIlOz4Sa2KVDGz2Zkx8zoFvPC6hn0t.wxB4hxcyv0R .ePETEpMtDmhHw3dDU4q6ZXu.CiTdWEioss6VETdMmKEsy9ZoyiowjUtptDSfiwrjvnxjFSlIpLq aLprSYzqGyaDQAnMw3cdjX1MJ5ADjXJEmnxxlTxdtUR1b5dhXfyeCGe40hbWmW4p44hg9X_3hGQo ytiqipvQwCA3dG_fU3UmF3XiWAYtg1EIGpj3wXUFNQGqn5jMGTvlFpueui8tJZTKljB1q2D3Yo9Y nx3LY6aeXYC7aDvlKpY1khBtN4h7aHZfzzheBWDRWgVlAlocXKElIRHkK7g3C7Ses.8rG8ss6dZl Bd2YYQsZ71eCWN5NZ1vLNUeAdzxNgx9VAv9PBEwu26bMg9iJlRkJUjgv8XHeRe0_6A6yRpgpF5nh z_v1PxaDGCvvKf4JM3tZm1VHBnYdgT.mz9nE.Cy7bYYsTChrdxuXHQTFeG2gPO0MT1cpsC2GFvwN _G0RHq_uZ.wkW2VouivPUXQmQF3q.Zm6YgpfwdaklIUwT6iGMV4aIE2w39EBc5BCqS21nNPttoqm Hhho7EZ.2eZCB53ZE25XgZNIUa8a800zmJsx.nKcL3StuPu5NCXaEyqAa2Aw.7MXsbkQCBpx4ElD ILEm.VCY_r0.0LhdglmUfQ20c5IaQFi.ny698ZJUohiuBAaI.l2j3u6tTFAg6uf06BDsfOvNAREa V6QHqAO8GWtijdQqIDmNSlrdZv32kRdcjPFcn.b1MWr_3Y24oFumYPfgQOubu4ZFA1q2FdwOEngX lEVXjZC_lCv0YEQNb1cotNh6zTX44YGAHijhJm88gQCfj16OcFPRiqDvVrC6pOICxLX7rGn5BPPc iEfigpIRFAH0Lj_jowglBDYAD7yS9MzCb3TCWbHID6IV.zsDhYTzl_Mc3gnENOx6VP8aI6.GONV9 LV2zUNv6nJ0pUMCC6IZ.z.bTLesG4Iq_PLkA3FuwDBA.jjBe9yoUIQ8QDGdOlMjBrbEHQ41bBVYD .OkAqNhDv1Y5V8CekQPfL1HP87HOkmxsC9N4bEneNGmfozqDZ1_jA_iAN5Uh6vdJpWpUH68Evirf qLbRKg1dXHATUu3To6ZlxwP7WuTM49hP65Gf90LjRbYlG X-Sonic-MF: X-Sonic-ID: 96995642-54ae-46ec-abe1-75880e950a6f Received: from sonic.gate.mail.ne1.yahoo.com by sonic312.consmr.mail.bf2.yahoo.com with HTTP; Tue, 27 Feb 2024 15:08:12 +0000 Date: Tue, 27 Feb 2024 15:08:04 +0000 (UTC) From: Jason Long Reply-To: Jason Long To: ronljohnsonjr@gmail.com Cc: Pgsql-general General Message-ID: <1267802730.758412.1709046484381@mail.yahoo.com> In-Reply-To: References: <2131161806.698565.1709023412017.ref@mail.yahoo.com> <2131161806.698565.1709023412017@mail.yahoo.com> Subject: Re: PostgreSQL Guard MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_758411_943874044.1709046484380" X-Mailer: WebService/1.1.22103 YahooMailAndroidMobile Content-Length: 3520 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_758411_943874044.1709046484380 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi,1- Both split-brain protection and security. Any tool? 2-=C2=A0Consider a database related to a website, which data is regularly e= ntered. Now you want to transfer this database to another server. What's th= e solution? =20 =20 On Tue, Feb 27, 2024 at 5:39 PM, Ron Johnson wro= te: On Tue, Feb 27, 2024 at 3:43=E2=80=AFAM Jason Long wrote: Hello, I have some questions about the=C2=A0PostgreSQL database: 1-=C2=A0If I want to distribute the PostgreSQL database on several servers = at the same time. what should I do? Something similar to high availability. HA replication is native in Postgresql.=C2=A0 2-=C2=A0Is there any special guard to protect PostgreSQL? Guard, as in protection from a split-brain?=C2=A0 =20 ------=_Part_758411_943874044.1709046484380 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,
1- Both split-brain protection and security. Any tool?

2- Consider a database related to a website, which data is regularly= entered. Now you want to transfer this database to another server. What's = the solution?


On Tue, Feb 27, 2024 at 5:39 PM, Ron Johnso= n
<ronljohnsonjr@gmail.com> wrote:
On = Tue, Feb 27, 2024 at 3:43=E2=80=AFAM Jason Long <hack3rcon@yahoo.com&g= t; wrote:
<= blockquote style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,= 204,204);padding-left:1ex;" class=3D"yiv7101847790gmail_quote">Hello,
I have some questions about the PostgreSQL database:

1- If I want to distribute the PostgreSQL database on several servers = at the same time. what should I do? Something similar to high availability.=

HA repli= cation is native in Postgresql.
 
2- I= s there any special guard to protect PostgreSQL?


Guard, as in protection from = a split-brain?
 
------=_Part_758411_943874044.1709046484380--