As before, I encourage you to read https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/ .
On Tue, Feb 27, 2024 at 3:48 PM Jason Long <hack3r...@yahoo.com> wrote: > Hi, > Do I have to run this command on the server where the main database is > located? > > 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 > this 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? > > On Tue, Feb 27, 2024 at 9:30 PM, Ron Johnson > <ronljohnso...@gmail.com> wrote: > I used this web page to implement hot standby via physical streaming. > This command sets up everything for you: > pg_basebackup \ > --pgdata=$PGDATA \ > --dbname=service=basebackup \ > --verbose --progress \ > --checkpoint=fast \ > --write-recovery-conf \ > --wal-method=stream \ > --create-slot --slot=pgstandby1 \ > --compress=server-zstd > I got it from > https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/, > which I encourage you to read. > > For guarding, and situations with a minimal RTO SLA, I use PgPool-II to > manage the cluster, automatic failover and Virtual IP address. Note that > only two database servers are needed. Install PgPool on the two DB > servers, and a third, smaller system. > > There are other products which do the same thing as PgPool, and you might > find them better. > > On Tue, Feb 27, 2024 at 12:00 PM Jason Long <hack3r...@yahoo.com> wrote: > > Hi, > Should I read > https://www.postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP > for question number 2? > > On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver > <adrian.kla...@aklaver.com> wrote: > On 2/27/24 07:08, Jason Long wrote: > > > 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? > > > https://www.postgresql.org/docs/current/high-availability.html > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > >
