Shulou(Shulou.com)05/31 Report--

This article mainly explains the "PostgreSQL need to pay attention to the problems", the content of the explanation is simple and clear, easy to learn and understand, the following please follow the editor's train of thought slowly in depth, together to study and learn "PostgreSQL what need to pay attention to" it!

1: open source product pg_rman

Features: support online backup and any point-in-time recovery function, that is, if the backup is done, it can be restored to any point of failure

Details:

Pg_rman-help

2: complete

To take an online backup, use the backup command:

$pg_rman backup--backup-mode=full-with-serverlog

3: check the backup status

To list all the backups taken so far, use the show command:

$pg_rman show

4: restore

To restore from a backup, use the restore command. Note that pg_rman itself generates the recovery.conf file required to perform PostgreSQL PITR.

$pg_ctl stop-m immediate$ pg_rman restore$ cat $PGDATA/recovery.conf# recovery.conf generated by pg_rman 1.3.7restore_command ='cp / home/postgres/arclog/%f% p'recovery_target_timeline = '1million $pg_ctl start

Re-emphasize backup validity check

It must be done on a regular basis, and there are often a lot of problems when they arise.

Thank you for your reading, the above is the content of "what are the problems that PostgreSQL needs to pay attention to". After the study of this article, I believe you have a deeper understanding of the problems that PostgreSQL needs to pay attention to, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.