Replication pgsql

Chalro — Wed, 12 Aug 2026 13:44:16 GMT

← Starší verze		Verze z 12. 8. 2026, 15:44
Řádek 6:		Řádek 6:
	listen_addresses = '*'		listen_addresses = '*'
	wal_level = replica		wal_level = replica
	max_wal_senders = 10		max_wal_senders = 10 #if valuechange, slave have to have the same value


Řádek 14:		Řádek 14:

	pg_hba.conf		pg_hba.conf
	host replication all 0.0.0.0/0 scram-sha-256		##host replication all 0.0.0.0/0 scram-sha-256
			host replication all 10.200.201.0/24 md5


Řádek 21:		Řádek 22:
	slave ->		slave ->
	rm -rf /var/lib/postgresql/12/main/*		rm -rf /var/lib/postgresql/12/main/*
	pg_basebackup -h 10.200.200.4 -p 9005 -D /var/lib/postgresql/12/main/ -U replica_user -P -R -X stream -c fast -S slave_node_1 #pwd		##pg_basebackup -h 10.200.200.4 -p 9005 -D /var/lib/postgresql/12/main/ -U replica_user -P -R -X stream -c fast -S slave_node_1 #pwd
			pg_basebackup -h 10.200.201.6 -p 5432 -D /var/lib/postgresql/12/main/ -U replica_user -P -R -X stream -c fast -C -S slave_node_1 #pwd
	systemctl start postgresql		systemctl start postgresql

wiki - Poslední změny [cs]