环境:
OS:Centos 7
DB:13.8
1.直接备份
需要提前创建好备份目录
su - postgres
[postgres@host134 pg_backup]$ mkdir -p /tmp/pg_backup/
[postgres@host134 pg_backup]$ pg_basebackup -D /tmp/pg_backup/ -Ft -Pv -U postgres -h 192.168.1.134 -p15432 -R
pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "192.168.1.134", user "postgres", SSL off
解决办法:
修改 pg_hba.conf 文件,在最后面加入如下条目
host replication all 0.0.0.0/0 md5
然后重新reload
[postgres@host134 pg_backup]$pg_ctl -D /opt/pg13/data reload
[postgres@host134 data]$ pg_basebackup -D /tmp/pg_backup/ -Ft -Pv -U postgres -h 192.168.1.134 -p15432 -R Password: pg_basebackup: initiating base backup, waiting for checkpoint to complete pg_basebackup: checkpoint completed pg_basebackup: write-ahead log start point: 0/701BC98 on timeline 2 pg_basebackup: starting background WAL receiver pg_basebackup: created temporary replication slot "pg_basebackup_30091" 32246/32246 kB (100%), 1/1 tablespace pg_basebackup: write-ahead log end point: 0/701BD48 pg_basebackup: waiting for background process to finish streaming ... pg_basebackup: syncing data to disk ... pg_basebackup: renaming backup_manifest.tmp to backup_manifest pg_basebackup: base backup completed
2.查看备份的文件
[postgres@host134 pg_backup]$ pwd
/tmp/pg_backup
[postgres@host134 pg_backup]$ ls -al
total 48816
drwxrwxr-x 2 postgres postgres 63 Oct 24 10:55 .
drwxrwxrwt. 11 root root 4096 Oct 24 10:51 ..
-rw------- 1 postgres postgres 178302 Oct 24 10:55 backup_manifest
-rw------- 1 postgres postgres 33021440 Oct 24 10:55 base.tar
-rw------- 1 postgres postgres 16780288 Oct 24 10:55 pg_wal.tar
base.tar ##备份是PG_DATA目录下的文件
pg_wal.tar ##备份是的是pg_wal下面的文件
标签：postgres,自定义,备份,host134,pg,backup,basebackup From： https://www.cnblogs.com/hxlasky/p/16820989.html