In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
[root@wallet01] # rpm-ivh pg_rman-1.3.8-1.pg96.rhel6.x8664.rpm [root @ wallet01 ~] # su-postgres [postgres@wallet01 ~] $mkdir archive [postgres@wallet01 ~] $mkdir backup [postgres@wallet01 ~] $vi / var/lib/pgsql/9.6/data/postgresql.confarchive_mode = onarchive_command ='cp% p / home/postgres/archive/%f' wal_level = archive [postgres@wallet01 ~] $pg_ctl restartwaiting for server to shut down. Doneserver stoppedserver starting [postgres@wallet01 ~] $export PGDATA=/var/lib/pgsql/9.6/data [postgres@wallet01 ~] $export ARCLOG_PATH=/home/postgres/ Archive [Postgres @ wallet01 ~] $export BACKUP_PATH=/home/postgres/backup [postgres@wallet01 ~] $pg_rman initINFO: ARCLOG_PATH is set to'/ home/postgres/archive'INFO: SRVLOG_PATH is set to'/ var/lib/pgsql/9.6/data/pg_log' [postgres@wallet01 ~] $pg_rman Backup--backup-mode=fullINFO: copying database filesINFO: copying archived WAL filesINFO: backup completeINFO: Please execute 'pg_rman validate' to verify the files are correctly copied. [postgres@wallet01 ~] $pg_rman validateINFO: validate: "2019-04-12 16:02:15" backup and archive log files by CRCINFO: backup "2019-04-12 16:02:15" is valid [postgres@wallet01 ~] $pg_rman show==== StartTime EndTime Mode Size TLI Status = 2019-04-12 16:02:15 2019-04-12 16:03:21 FULL 1572MB 1 OK [postgres@wallet01 ~] $pg_rman backup--backup-mode=incrementalINFO: copying database filesINFO: copying archived WAL filesINFO: backup completeINFO: Please execute 'pg_rman validate' to verify the files are correctly copied. [postgres@wallet01 ~] $pg_rman validateINFO: validate: "2019-04-12 16:15:12" backup and archive log files by CRCINFO: backup "2019-04-12 16:15:12" is valid [postgres@wallet01 ~] $pg_rman show==== StartTime EndTime Mode Size TLI Status = 2019-04-12 16:15:12 2019-04-12 16:15:17 INCR 248MB 1 OK2019-04-12 16:02:15 2019-04-12 16:03:21 FULL 1572MB 1 OK [postgres@wallet01 ~] $pg_rman backup--backup-mode=archiveINFO: copying archived WAL filesINFO: backup completeINFO: Please execute 'pg_rman validate' to verify the files are correctly copied. [ Postgres@wallet01 ~] $pg_rman validateINFO: validate: "2019-04-12 16:30:04" archive log files by CRCINFO: backup "2019-04-12 16:30:04" is valid [postgres@wallet01 ~] $pg_rman show==== StartTime EndTime Mode Size TLI Status = 2019-04-12 16:30:04 2019-04-12 16:30:06 ARCH 33MB 1 OK2019-04-12 16:15:12 2019-04-12 16: 15:17 INCR 248MB 1 OK2019-04-12 16:02:15 2019-04-12 16:03:21 FULL 1572MB 1 OK [postgres@wallet01] $pg_ctl stop-m fastwaiting for server to shut down. Doneserver stopped [postgres@wallet01] $mv archive archive_ backup [Postgres @ wallet01 ~] $mkdir archive [postgres@wallet01 ~] $cd / var/lib/pgsql/9.6 [postgres@wallet01 9.6] $mv data data_ backup [Postgres @ wallet01 9.6] $mkdir data [postgres@wallet01 9.6] $chmod-R 0700 data [postgres@wallet01 ~] $pg_rman restore-hard-copyWARNING: pg_controldata file "/ var/lib/pgsql/9.6/data/global/pg_control "does not existINFO: the recovery target timeline ID is not givenINFO: use timeline ID of latest full backup as recovery target: 1INFO: calculating timeline branches to be used to recovery target pointINFO: searching latest full backup which can be used as restore start pointINFO: found the full backup can be used as base in recovery:" 2019-04-12 16:02:59 "INFO: copying online WAL files and server log filesINFO: clearing restore destinationINFO: validate:" 2019-04-12 16:02:59 "backup and archive log files by SIZEINFO: backup" 2019-04- 12 16:02:59 "is validINFO: restoring database files from the full mode backup" 2019-04-12 16:02:59 "INFO: searching incremental backup to be restoredINFO: validate:" 2019-04-12 16:15:12 "backup and archive log files by SIZEINFO: backup" 2019-04-12 16:15:12 "is validINFO: restoring database files from the incremental mode backup" 2019-04-12 16:15:12 "INFO: searching backup which contained archived WAL files to be restoredINFO: backup" 2019-04-12 16: 15:12 "is validINFO: restoring WAL files from backup" 2019-04-12 16:15:12 "INFO: validate:" 2019-04-12 16:30:04 "archive log files by SIZEINFO: backup" 2019-04-12 16:30:04 "is validINFO: restoring WAL files from backup" 2019-04-12 16:30:04 "INFO: restoring online WAL files and server log filesINFO: generating recovery.confINFO: restore completeHINT: Recovery will start automatically when the PostgreSQL server is started. [postgres@wallet01 ~] $pg_ctl Startserver starting [postgres@wallet01 ~] $pg_ctl statuspg_ctl: server is running (PID: 29889) / usr/pgsql-9.6/bin/postgres
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.