甜橘子，专注成都网站制作网站设计与营销型网站建设与优化
QQ :532337155
电话：028-86922220
测试环境：
10年积累的网站设计制作、成都网站设计经验，可以快速应对客户对网站的新想法和需求。提供各种问题对应的解决方案。让选择我们的客户得到更好、更有力的网络服务。我虽然不认识你，你也不认识我。但先网站设计后付款的网站建设流程，更有屏南免费网站建设让你可以放心的选择与我们合作。
CentOS Linux release 7.4.1708 (Core) X64
PostgreSQL: 10.1(Source)
pgbackrest: pgbackrest-release-1.27.tar.gz
1.Test-Simple-1.302120.tar.gz
# perl Makefile.PL
# make
# make test
......
......
All tests successful.
Files=220, Tests=2514, 29 wallclock secs ( 1.10 usr 0.60 sys + 17.97 cusr 4.61 csys = 24.28 CPU)
Result: PASS
#
# make install
2.DBI-1.637.tar.gz
# tar zxvf DBI-1.637.tar.gz
# cd DBI-1.637
# perl Makefile.PL
# make
# make test
......
......
All tests successful.
Files=194, Tests=9005, 113 wallclock secs ( 2.57 usr 0.80 sys + 94.07 cusr 12.95 csys = 110.39 CPU)
Result: PASS
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
test.pl
DBI test application $Revision$
Switch: DBI 1.637 by Tim Bunce, 1.637
Available Drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge
dbi:ExampleP:: testing 3 sets of 20 connections:
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
connect 20 and disconnect them, 3 times: 0.0040s / 60 = 0.0001s
Testing handle creation speed...
51282 NullP sth/s perl 5.016003 x86_64-linux-thread-multi (gcc 4.8.5 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic) 0.000019s
test.pl done
#
# make install
3.version-0.9918.tar.gz
# perl Makefile.PL
# make
# make test
......
......
All tests successful.
Test Summary Report
-------------------
t/07locale.t (Wstat: 0 Tests: 8 Failed: 0)
TODO passed: 7
Files=12, Tests=2502, 2 wallclock secs ( 0.45 usr 0.12 sys + 1.05 cusr 1.13 csys = 2.75 CPU)
Result: PASS
make[1]: Entering directory `/home/soft/dbd-pg/version-0.9918/vutil'
No tests defined for version::vxs extension.
make[1]: Leaving directory `/home/soft/dbd-pg/version-0.9918/vutil'
# make install
4.DBD-Pg-3.7.0.tar.gz
export PATH=/opt/pgsql/10.1/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
export LD_LIBRARY_PATH=/opt/pgsql/10.1/lib
export MANPATH=/opt/pgsql/10.1/share/man:$MANPATH
# perl Makefile.PL
Configuring DBD::Pg 3.7.0
PostgreSQL version: 100001 (default port: 5432)
POSTGRES_HOME: (not set)
POSTGRES_INCLUDE: /opt/pgsql/10.1/include
POSTGRES_LIB: /opt/pgsql/10.1/lib
OS: linux
Checking if your kit is complete...
Looks good
Using DBI 1.637 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/
Writing Makefile for DBD::Pg
#
# make
cp lib/Bundle/DBD/Pg.pm blib/lib/Bundle/DBD/Pg.pm
cp Pg.pm blib/lib/DBD/Pg.pm
/usr/bin/perl -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" /usr/local/lib64/perl5/auto/DBI/Driver.xst > Pg.xsi
/usr/bin/perl /usr/share/perl5/vendor_perl/ExtUtils/xsubpp -typemap /usr/share/perl5/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c
gcc -c -I/opt/pgsql/10.1/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=100001 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.7.0\" -DXS_VERSION=\"3.7.0\" -fPIC "-I/usr/lib64/perl5/CORE" Pg.c
gcc -c -I/opt/pgsql/10.1/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=100001 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.7.0\" -DXS_VERSION=\"3.7.0\" -fPIC "-I/usr/lib64/perl5/CORE" dbdimp.c
gcc -c -I/opt/pgsql/10.1/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=100001 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.7.0\" -DXS_VERSION=\"3.7.0\" -fPIC "-I/usr/lib64/perl5/CORE" quote.c
In file included from Pg.h:59:0,
from quote.c:10:
/usr/local/lib64/perl5/auto/DBI/DBIXS.h:491:25: warning: ‘dbi_get_state’ defined but not used [-Wunused-function]
static dbistate_t** dbi_get_state(pTHX) { \
^
/usr/local/lib64/perl5/auto/DBI/DBIXS.h:504:27: note: in expansion of macro ‘_DBISTATE_DECLARE_COMMON’
# define DBISTATE_DECLARE _DBISTATE_DECLARE_COMMON
^
Pg.h:65:1: note: in expansion of macro ‘DBISTATE_DECLARE’
DBISTATE_DECLARE;
^
gcc -c -I/opt/pgsql/10.1/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=100001 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.7.0\" -DXS_VERSION=\"3.7.0\" -fPIC "-I/usr/lib64/perl5/CORE" types.c
In file included from Pg.h:59:0,
from types.c:15:
/usr/local/lib64/perl5/auto/DBI/DBIXS.h:491:25: warning: ‘dbi_get_state’ defined but not used [-Wunused-function]
static dbistate_t** dbi_get_state(pTHX) { \
^
/usr/local/lib64/perl5/auto/DBI/DBIXS.h:504:27: note: in expansion of macro ‘_DBISTATE_DECLARE_COMMON’
# define DBISTATE_DECLARE _DBISTATE_DECLARE_COMMON
^
Pg.h:65:1: note: in expansion of macro ‘DBISTATE_DECLARE’
DBISTATE_DECLARE;
^
Running Mkbootstrap for DBD::Pg ()
chmod 644 Pg.bs
rm -f blib/arch/auto/DBD/Pg/Pg.so
gcc -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -Wl,-z,relro Pg.o dbdimp.o quote.o types.o -o blib/arch/auto/DBD/Pg/Pg.so \
-L/opt/pgsql/10.1/lib -lpq -lm \
chmod 755 blib/arch/auto/DBD/Pg/Pg.so
cp Pg.bs blib/arch/auto/DBD/Pg/Pg.bs
chmod 644 blib/arch/auto/DBD/Pg/Pg.bs
Manifying blib/man3/Bundle::DBD::Pg.3pm
Manifying blib/man3/DBD::Pg.3pm
[root@localhost DBD-Pg-3.7.0]# make test
PGINITDB="/opt/pgsql/10.1/bin/initdb" PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00_signature.t .... skipped: Set the environment variable TEST_SIGNATURE to enable this test
t/00basic.t ......... ok
t/01connect.t ....... 1/15 #
# DBI Version 1.637
# DBD::Pg Version 3.7.0
# Perl Version 5.16.3
# OS linux
# PostgreSQL (compiled) 100001
# PostgreSQL (target) 100001
# PostgreSQL (reported) PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit
# Default port 5432
# DBI_DSN dbi:Pg:
# DBI_USER postgres
# Test schema dbd_pg_testschema
# LANG en_US.UTF-8
# array_nulls on
# backslash_quote safe_encoding
# client_encoding UTF8
# server_encoding UTF8
# standard_conforming_strings on
# Adjusted: DBI_DSN
t/01connect.t ....... ok
t/01constants.t ..... ok
t/02attribs.t ....... ok
t/03dbmethod.t ...... ok
t/03smethod.t ....... ok
t/04misc.t .......... ok
t/06bytea.t ......... ok
t/07copy.t .......... ok
t/08async.t ......... ok
t/09arrays.t ........ ok
t/12placeholders.t .. ok
t/20savepoints.t .... ok
t/30unicode.t ....... ok
t/99cleanup.t ....... ok
All tests successful.
Files=16, Tests=2129, 26 wallclock secs ( 0.57 usr 0.13 sys + 3.78 cusr 4.35 csys = 8.83 CPU)
Result: PASS
[root@localhost DBD-Pg-3.7.0]# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib64/perl5/auto/DBD/Pg/Pg.so
Installing /usr/local/lib64/perl5/auto/DBD/Pg/Pg.bs
Installing /usr/local/lib64/perl5/DBD/Pg.pm
Installing /usr/local/lib64/perl5/Bundle/DBD/Pg.pm
Installing /usr/local/share/man/man3/Bundle::DBD::Pg.3pm
Installing /usr/local/share/man/man3/DBD::Pg.3pm
Appending installation info to /usr/lib64/perl5/perllocal.pod
#
5.other perl module
# yum install -y perl-IO-Socket-SSL perl-XML-LibXML openssl-devel perl-Digest-SHA perl-JSON-PP
6.pgbackrest
# tar zxvf pgbackrest-release-1.27.tar.gz
# cd pgbackrest-release-1.27
###### lib ######
# cp -r lib/pgBackRest /usr/share/perl5
# find /usr/share/perl5/pgBackRest -type f -exec chmod 644 {} +
# find /usr/share/perl5/pgBackRest -type d -exec chmod 755 {} +
###### bin ######
# cp bin/pgbackrest /usr/bin/pgbackrest
# chmod 755 /usr/bin/pgbackrest
###### log ######
# mkdir -m 770 /var/log/pgbackrest
# chown postgres:postgres /var/log/pgbackrest
###### conf ######
# touch /etc/pgbackrest.conf
# chmod 640 /etc/pgbackrest.conf
# chown postgres:postgres /etc/pgbackrest.conf
###### Build and Install C Library ######
# cd libc/
# perl Makefile.PL INSTALLMAN1DIR=none INSTALLMAN3DIR=none
Writing Makefile for pgBackRest::LibC
#
# make test
......
......
All tests successful.
Files=1, Tests=4, 1 wallclock secs ( 0.02 usr 0.01 sys + 0.12 cusr 0.03 csys = 0.18 CPU)
Result: PASS
#
# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib64/perl5/auto/pgBackRest/LibC/LibC.so
Installing /usr/local/lib64/perl5/auto/pgBackRest/LibC/LibC.bs
Installing /usr/local/lib64/perl5/pgBackRest/LibC.pm
Installing /usr/local/lib64/perl5/pgBackRest/LibCAuto.pm
Installing /usr/local/lib64/perl5/auto/pgBackRest/LibC/autosplit.ix
Appending installation info to /usr/lib64/perl5/perllocal.pod
#
# su - postgres
Last login: Thu Dec 21 15:50:54 CST 2017 on pts/1
[postgres@localhost ~]$ pgbackrest --help
Unknown option: help
pgBackRest 1.27 - General help
Usage:
pgbackrest [options] [command]
Commands:
archive-get Get a WAL segment from the archive.
archive-push Push a WAL segment to the archive.
backup Backup a database cluster.
check Check the configuration.
expire Expire backups that exceed retention.
help Get help.
info Retrieve information about backups.
restore Restore a database cluster.
stanza-create Create the required stanza data.
stanza-upgrade Upgrade a stanza.
start Allow pgBackRest processes to run.
stop Stop pgBackRest processes from running.
version Get version.
Use 'pgbackrest help [command]' for more information.
[postgres@localhost ~]$
###### root ######
# mkdir /var/lib/pgbackrest
# chmod 750 /var/lib/pgbackrest
# chown postgres:postgres /var/lib/pgbackrest
# su - postgres
$ vi postgresql.conf
listen_addresses = '*'
wal_level = logical
archive_mode = on
archive_command = 'pgbackrest --stanza=db archive-push %p'
#log_line_prefix = '%m [%p] '
#max_wal_senders = 10
wal_keep_segments = 5000
#hot_standby = on
$ openssl rand -base64 48
lFhhFeDQPazx59LPvztsWu5leUqsiOwhI8JT7gMAmACMVX+Kcwak5qDOVNiiNkqX
$ vi /etc/pgbackrest.conf
# 仅包含字母，不能为db01
[db]
db-path=/pgdata10
[global]
repo-cipher-pass=lFhhFeDQPazx59LPvztsWu5leUqsiOwhI8JT7gMAmACMVX+Kcwak5qDOVNiiNkqX
repo-cipher-type=aes-256-cbc
repo-path=/var/lib/pgbackrest
retention-full=2
process-max=3
start-fast=y
stop-auto=y
$ vi .bash_profile
# User specific environment and startup programs
export LD_LIBRARY_PATH=/opt/pgsql/10.1/lib
export MANPATH=/opt/pgsql/10.1/share/man:$MANPATH
export PATH=/opt/pgsql/10.1/bin:$PATH:$HOME/.local/bin:$HOME/bin
1).create repository
$ pgbackrest --stanza=db --log-level-console=info stanza-create
2017-12-21 16:14:25.331 P00 INFO: stanza-create command begin 1.27: --db1-path=/pgdata10 --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=db01
2017-12-21 16:14:25.801 P00 INFO: stanza-create command end: completed successfully
$
$ pgbackrest --stanza=db --log-level-console=info check
2017-12-21 16:46:45.886 P00 INFO: check command begin 1.27: --db1-path=/pgdata10 --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=db
2017-12-21 16:46:48.243 P00 INFO: WAL segment 000000010000000000000005 successfully stored in the archive at '/var/lib/pgbackrest/archive/db/10-1/0000000100000000/000000010000000000000005-a85cb846cee3a5a47b487415a2570ce7b5fbf2f8.gz'
2017-12-21 16:46:48.244 P00 INFO: check command end: completed successfully
$
2).备份操作
###### full ######
pgbackrest --stanza=db --type=full --log-level-console=info backup
###### incremental ######
$ pgbackrest --stanza=db --type=incr --log-level-console=info backup
###### diff ######
pgbackrest --stanza=db --type=diff --log-level-console=info backup
###### display backup ######
$ pgbackrest --stanza=db --log-level-console=info info
###### restore(--delta, PGDATA base exist part file,miss some files ) ######
$ pgbackrest --stanza=db --delta --log-level-console=info restore
###### restore(--delta, PGDATA none file) ######
$ pgbackrest --stanza=db --log-level-console=info restore