annotate host/doc/backup.txt @ 1699:e6750146faa1

no restart on backup
author Vadim Filimonov <fffilimonov@yandex.ru>
date Tue, 28 Jun 2022 16:13:37 +0300
parents fd3d56f39450
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1632
0344a535b1db add doc
fffilimonov
parents:
diff changeset
1 s1.luan.software - master db
0344a535b1db add doc
fffilimonov
parents:
diff changeset
2 test.luan.software - slave db
0344a535b1db add doc
fffilimonov
parents:
diff changeset
3
0344a535b1db add doc
fffilimonov
parents:
diff changeset
4 install:
0344a535b1db add doc
fffilimonov
parents:
diff changeset
5
0344a535b1db add doc
fffilimonov
parents:
diff changeset
6 brew tap caskroom/versions
0344a535b1db add doc
fffilimonov
parents:
diff changeset
7 brew install postgresql@9.5
0344a535b1db add doc
fffilimonov
parents:
diff changeset
8
1635
fd3d56f39450 rearrange startup files
Franklin Schmidt <fschmidt@gmail.com>
parents: 1633
diff changeset
9 cd macos
1633
665049cffc02 fix path
fffilimonov
parents: 1632
diff changeset
10 ./addStartupScriptsPostgres.sh slave_ip
1632
0344a535b1db add doc
fffilimonov
parents:
diff changeset
11
0344a535b1db add doc
fffilimonov
parents:
diff changeset
12 create replica
0344a535b1db add doc
fffilimonov
parents:
diff changeset
13
0344a535b1db add doc
fffilimonov
parents:
diff changeset
14 1) mkdir /Users/administrator/replica/s1 (must be empty)
0344a535b1db add doc
fffilimonov
parents:
diff changeset
15
0344a535b1db add doc
fffilimonov
parents:
diff changeset
16 2) pg_basebackup -h s1.luan.software -D /Users/administrator/replica/s1 -R -P -U administrator --xlog-method=stream
0344a535b1db add doc
fffilimonov
parents:
diff changeset
17
0344a535b1db add doc
fffilimonov
parents:
diff changeset
18 replace configs with files *.slave from startup/postgres