🟢 Lesson 8: PostgreSQL - setting up simple replication using a basic backup
To put it simply, replication is copying the state of one server to another using wal logs. Well, to be more precise, absolutely any changes that occur on the main server will be copied to the replica server.
0:00 Start
1:04 Initializing the Primary database
2:28 Setting the pg_hba.conf connection file to primary
4:02 Creating a replication user
5:03 Open port 5432 on Firewall
6:02 Migrate a basic database backup from Primary to Standby
7:30 On Standby, configure rights to the directory with the database
7:51 Launch Standby
8:10 On Primary we check Standby database connections
10:50 The end
#postgresql #dbms #postgres #replication #primary #standby
