view host/doc/backup.txt @ 1694:09aaca079ff3

add backup script
author Vadim Filimonov <fffilimonov@yandex.ru>
date Mon, 20 Jun 2022 11:12:25 +0300
parents fd3d56f39450
children
line wrap: on
line source

s1.luan.software - master db
test.luan.software - slave db

install:

brew tap caskroom/versions
brew install postgresql@9.5

cd macos
./addStartupScriptsPostgres.sh slave_ip

create replica

1) mkdir /Users/administrator/replica/s1 (must be empty)

2) pg_basebackup -h s1.luan.software -D /Users/administrator/replica/s1 -R -P -U administrator --xlog-method=stream

replace configs with files *.slave from startup/postgres