Re: PostgreSQL Guard

2024-02-28 Thread Ron Johnson
Read https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/ . On Wed, Feb 28, 2024 at 10:36 AM Jason Long wrote: > Hi, > Thanks again. > I have another questions: > > 1- Should I just install PostgreSQL normally on the Standby server? > > 2- Are the steps the same for

Re: PostgreSQL Guard

2024-02-28 Thread Jason Long
Hi,Thanks again.I have another questions: 1- Should I just install PostgreSQL normally on the Standby server? 2- Are the steps the same for other Linux distributions like Debian? On Wed, Feb 28, 2024 at 9:29 AM, Ron Johnson wrote: As before, I encourage you to read 

Re: PostgreSQL Guard

2024-02-28 Thread Greg Sabino Mullane
On Tue, Feb 27, 2024 at 3:48 PM Jason Long wrote: > 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

Re: PostgreSQL Guard

2024-02-27 Thread Ron Johnson
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 wrote: > Hi, > Do I have to run this command on the server where the main database is > located? > > Suppose you want to transfer the

Re: PostgreSQL Guard

2024-02-27 Thread Jason Long
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

Re: PostgreSQL Guard

2024-02-27 Thread Greg Sabino Mullane
You may need to expand on / rephrase question 2.

Re: PostgreSQL Guard

2024-02-27 Thread Ron Johnson
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 \

Re: PostgreSQL Guard

2024-02-27 Thread Jason Long
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 wrote: On 2/27/24 07:08, Jason Long wrote: > Hi, > 1- Both split-brain protection and security. Any tool? > > 2- 

Re: PostgreSQL Guard

2024-02-27 Thread Adrian Klaver
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?

Re: PostgreSQL Guard

2024-02-27 Thread Jason Long
special guard to protect PostgreSQL? Guard, as in protection from a split-brain? 

Re: PostgreSQL Guard

2024-02-27 Thread Ron Johnson
lication is native in Postgresql. > 2- Is there any special guard to protect PostgreSQL? > Guard, as in protection from a split-brain?

PostgreSQL Guard

2024-02-27 Thread Jason Long
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. 2- Is there any special guard to protect PostgreSQL? Thank you.