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 1rfLzK-00H8Lf-MO for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 15:36:55 +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 1rfLzI-00Beg0-4a for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 15:36:52 +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 1rfLzG-00BefO-VI for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 15:36:52 +0000 Received: from sonic310-14.consmr.mail.bf2.yahoo.com ([74.6.135.124]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfLz8-001nfL-9X for pgsql-general@postgresql.org; Wed, 28 Feb 2024 15:36:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709134596; bh=XoNl5tcJdxbLUY0g/HqOTuvfiblbddIerQEz5X8WFDQ=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=OpTKO9FYivDhNj2jSriXp3xi9DsoDeMKt59vEJ0J09HIdltaQ2EdtK56S0CTwkC/HBm19TGRa46T/jpFQVALmwxKuGjAC4osw8w1bC2iZPnhihBX+T201aeSiDVLy6gWhh6DZLugYtpYCdZUS/Nn3ET0TdMNBdEKU0QFlRzCZIYoVhF9CpFQ+b1utIFzNI68S1ssF2VfhwJm9Gm6gZAujMiGdR2amP3dLpVc2vwFZN0FwJfi8VBu+EDLqWXNd/FJQw0XUTNVGvh1NLaKMhaY4uwYq/ScZdgRiFWVrirONSC6E9vRLMvcFLlgVkQn1l24QZ5NFs+luje6jzqP26TYoQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709134596; bh=YsaD5Vxo3BYrhjT33f9SfHIQg7Js6Ap1IZGc6lGRcT/=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=ZD7p6s4ggUwqhVIBgHiVMXEK35shMjbYjSXVFIS+rvMafIuy4B6kR3Zs8wxZ3n61t/KgJMXS2rn5xJjnO6gDxZFQwf8ZB8xDOR2PrA96CURFjc7lKSfl3p3ZEbOkiubhxzw8K9dbAYa9o6xKb6/9/QczPjf2QcPGfzTDFBrfazKN4uGd4qLQ8gSDT5vNpYMaaUfcjkayVKc13gqsp+bvK7DRXHJ2LFU3sazr57Li2cJOxFd2FF6Vt63yggjEJdCj3afcl+TN0fge3ohqGRzfDX8dOSxWxylmzCWy5UUrfI0F9ZcQf0ozCejgjteZ4l07SUG4LnOCt8D4CNeWCncxfg== X-YMail-OSG: 3gJxTvYVM1lmjEHM0a1e4.WwCx55fpSiHinhnVNO.q4zFqYf9Yv82Ykw.ehbUPq AE4ebhrPGdmTmvQU6_Z1Us9gAFR7g8qyO1vn0Y58VrxwSl7reTAVin7aZux_JajVs38N5ZOD3h8F 2hv3tsRezunRo2zM1WeA6gY1UDmbCt1KOwFy5VRohYwHiS0FmhccqFbha0y12JCh1aRDfemFJEol hmOl4ezAi6VnA1UrbgC1NXo4lcUc9Jezviz8a_sUee3guYxF0D4c4R7Y_GZv9Lb5TKstb1CGwT59 3deqhVD4wNCESM.edUI1wFHi6UacbYuG449Erz4OHVhPUUXRzm.tcquRA4GZ.4RlNV1xXmu4SiKO 6WjCJRKVZr5GSBo28KogaRR7usy.oeonKuyRxBOe6BMJ_qqNSnIkXsZY1bReRUrB4hgVriMQ9GgV Uf3m2Em382R70kzsTTt.o_Kb6fj3k39Kts.lB8FxsgrqYeov3hdihuQv2ByHIb1ob0w5kn98Tj22 xnDieXeKTODeHYxKYCLdf7X5wwTI.ZtVyZaPk6WYcBMvIT3iUe8pp6xTg.EaEXcSZTA4pZEKUzhY Hc7fxgnDs2OSmfZra_i9ueVfZFhfnAS6lMTWuPnEmlUUVwyLeIibO24VxtEvnO.oFqUJwNh6JYqW US15gHCMSNqS.cYXc.bfBtY7_5WTCBiW0g5FMRuHJYeXdI1RGKpG291ncujBQmR5ioiIWeL2Uka. Zq2cWBVamCzMcS.YM6x5guxErOLtYL8ke.4IPHyuPuLxnfsD11uNev9.axhIQUMzS95JbyhDUqR0 REbEwYZFX683uHLC1JZHwiDOjuFH26yvuSaIhp8ip4N_7UVVzobO1iTyZgAelZsF9cOmbsGrroR3 rCruetLGwJ1U1jNLTUyKb37c5WzHs7pz2AZP4A7YgyMyazq.eQQdkRyAbVKKSzEARzBSkHoezSPu PXZ9xnFs.X3aZD7SjotGvI2OdJln.N83wxzuqzjXdSjBSh4J3TR8hEL1yUXOmEnNvn9Dov4v_YOk UYQbejYijEuvIp8cSq41KgYM4aHKGVog_1ycC7tz27KzLYFq4UtLph3HTtbmDWRK0AdT7Q1pTcO0 Pjq9e_dWRvGERI7LBKANZ5aeP0HSKHUCjrjjeZAE8Uw2y8RFGiO6vZRKrO_2.gdORdUjiYA72OMp Gd8hejVuTQSFlD6LQBelBabZ7xzCKrIFpNKGnDoa1JFwsDmDl7TknN.A1CmNUjVgJCX8xMdrvrBR 4XS_VnlGYt7DdhVoP.eCm37z89HktGhwLAfIuki6vCmjwWDsiFb_HBgf8XcKhQB3O51v44CKEZNT 3B8lwckZygcfqtQwDFd.7tRKzNK0JdUUqZZsdBNkCfEpXjs_HtALlRJYW82DqIxEEWH0gwAW0WRi dgaIIpMr5cbsJoYTbJdmIAF65hMs8jYF4HzMqNysXmtEK.tndZjkv3x.TZDDJnduTY3sYAnuqw7N h3sy23Be8biHRWnHnFSmCfhSjyXtS3ZK8rcsWbsPE3ltJ1z4bCeR.R87heROa74qR4Ax2j0Sy1d. BaDxVP40xOH2vG4fp9KvhaE2xC5iMVUzroPgYr9wVFmrqdIiqGoJAzCh1ZNQZ3bTj7zzXeVljt.T laQQS57CGo9N61b_oXLGEQfGjC7z67jn.HHN2V2wJeJs8yNy85LAvnMLQ6f3YuBtRx0LREznV5QZ agtdO5J0RiJcDKgGdZKK22CGtbPt2ItaafAUwhpGn8lz7gVIPW7aF7IRLds4Mg_ZYg2uLeStw5db Uq_vUdS8Dje3tUtGBU2iakzhHtovvbSD6GI6IuHdUGQ.hvVQyLgMQdYLHVjZ_oJ8clXK6T06RmWa 8hlQu5E8Ux238fXvbHUPXoyEFyALFvU2WWYX7A5HnQWdHJBrojcjgIM.Rja4MGab4hptZxvqxWqF v52ZG3K1wApodwLLB5rK3_y7fVSFNDijhZXs9TYC6LQQ23k0dYpdj5GqqNQOiIDCXJ2jCavkn_TB _wpkjyLUuO8tssSWUcX833w7pDSTt291izxfDJltz6CQo2Zd5y6OuOSw0jfROlQpDnpXvsPNGhPu _Oxbl7uuUDCQGh2IxQDlRLvJGsR64TlFg6SwIl95nxJjO3t7GgFkZYWVRFK4f8KHpYT.RbqcXnVB aIuuiRnsZZBsmPApDzAMz2Hv5oKDZdYAbityaxji0_ldt16TECxgEwOAdjbSdJvVjbYfgazAdQXU qCI.CmxI6qIdhyDUMeyFunYS2CPr0UyeNz38KUnL3xXAcGcJibF.VxgMB.UfMo3dFFgD7Y1aH_3k 3Wqac67oSd3QcUOCj8TyNIk0jmyeoCy3vxi_fA22bymG1teoSd5sE1SgTqhH6Yh.2bXxCkaF_Rsf _o18PFgcYDzRLe9ILUA2GO58qmE5EABPcJWJ3ztgt9iGXmtlB X-Sonic-MF: X-Sonic-ID: abc967ba-5f08-46c8-91e7-53466f439730 Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.bf2.yahoo.com with HTTP; Wed, 28 Feb 2024 15:36:36 +0000 Date: Wed, 28 Feb 2024 15:36:29 +0000 (UTC) From: Jason Long Reply-To: Jason Long To: ronljohnsonjr@gmail.com Cc: Pgsql-general General Message-ID: <445189098.1062590.1709134589290@mail.yahoo.com> In-Reply-To: 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> <730983731.798844.1709053243136@mail.yahoo.com> <1668855396.866991.1709066793039@mail.yahoo.com> Subject: Re: PostgreSQL Guard MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1062589_1935342706.1709134589288" X-Mailer: WebService/1.1.22103 YahooMailAndroidMobile Content-Length: 10826 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1062589_1935342706.1709134589288 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi,Thanks again.I have another questions: 1-=C2=A0Should I just install PostgreSQL normally on the Standby server?=20 2-=C2=A0Are the steps the same for other Linux distributions like Debian? =20 On Wed, Feb 28, 2024 at 9:29 AM, Ron Johnson wro= te: As before, I encourage you to read=C2=A0https://www.tecmint.com/confi= gure-postgresql-streaming-replication-in-centos-8/. On Tue, Feb 27, 2024 at 3:48=E2=80=AFPM Jason Long wr= ote: Hi,Do I have to run this command on the server where the main database is l= ocated? Suppose you want to transfer the database of a website like Amazon.com to a= new server and delete the old one. Many users are buying and selling on th= is website at the same time and it is not possible to turn off the server. = What do you do to move a database to another server? =20 =20 On Tue, Feb 27, 2024 at 9:30 PM, Ron Johnson wro= te: I used this web page to implement hot standby via physical streaming.= =C2=A0 This command sets up everything for you:pg_basebackup \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --pgdata=3D$PGDATA \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --dbname=3Dservice=3Dbasebackup \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --verbose --progress \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --checkpoint=3Dfast \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --write-recovery-conf \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --wal-method=3Dstream \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --create-slot --slot=3Dpgstandby1= \ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 --compress=3Dserver-zstd I got it from https://www.tecmint.com/configure-postgresql-streaming-replic= ation-in-centos-8/, which I encourage you to read. For guarding, and situations with a minimal RTO SLA, I use PgPool-II to man= age the cluster, automatic failover and Virtual IP address.=C2=A0 Note that= only two database servers are needed.=C2=A0 Install PgPool on the two DB s= ervers, and a third, smaller system. There are other products which do the same thing as PgPool, and you might f= ind them better. On Tue, Feb 27, 2024 at 12:00=E2=80=AFPM Jason Long w= rote: 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 =20 =20 ------=_Part_1062589_1935342706.1709134589288 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,
Thanks again.
I have another= questions:

1- Should I just install PostgreSQL normally o= n the Standby server?

2- Are the steps the same f= or other Linux distributions like Debian?

On Wed, Feb 28, 2024 at 9:29 AM, Ron Johnson
<ronl= johnsonjr@gmail.com> wrote:

On Tue, Feb 2= 7, 2024 at 3:48=E2=80=AFPM Jason Long <hack3rcon@yahoo.com> wrote:<= br clear=3D"none">
Hi,
Do I have to run this command on the server where the main da= tabase is located?

Suppose you wan= t to transfer the database of a website like Amazon.com to a new server and= delete the old one. Many users are buying and selling on this website at t= he same time and it is not possible to turn off the server. What do you do = to move a database to another server?

On Tue, Feb 27, 2024 at = 9:30 PM, Ron Johnson
I used this web pag= e to implement hot standby via physical streaming.  This command sets = up everything for you:
pg_basebackup \            --pgdata=3D$PGDA= TA \
            --dbname= =3Dservice=3Dbasebackup \
        &nb= sp;   --verbose --progress \
      &n= bsp;     --checkpoint=3Dfast \
    &n= bsp;       --write-recovery-conf \
  =           --wal-method=3Dstream \
            --create-slot --slot=3Dpgstandb= y1 \
            --compress= =3Dserver-zstd

For guarding, and situations with a minimal RTO SLA, I use PgPool-I= I to manage the cluster, automatic failover and Virtual IP address.  N= ote that only two database servers are needed.  Install PgPool on the = two DB servers, and a third, smaller system.

<= /div>
There are other products which do the same thing as PgPool, and y= ou might find them better.

On= Tue, Feb 27, 2024 at 12:00=E2=80=AFPM Jason Long <hack3rcon@yahoo.com= > wrote:
Hi,
On Tue, Feb 27,= 2024 at 7:28 PM, Adrian Klaver
On 2/27/24 07:0= 8, Jason Long wrote:

> Hi,
> 1- Both split-brain protection and security. Any tool?
>
> 2- Consider a database relat= ed to a website, which data is regularly
> entered. N= ow you want to transfer this database to another server.
> What's the solution?


https://ww= w.postgresql.org/docs/current/high-availability.html
=


--
Adrian Klaver
adrian.klaver@aklaver.com=


------=_Part_1062589_1935342706.1709134589288--