Alibabacloud.com offers a wide variety of articles about postgresql backup command, easily find your postgresql backup command information here online.
PostgreSQL Advantage2016-10-20 21:36 686 People read comments (0) favorite reports Classification:MySQL Database (5)PostgreSQL is a free object-relational database server (database management system), which is very powerful. Includes support for
Have you ever accidentally deleted a database table or damaged the disk where the database is stored? If you encounter this situation, I believe you will feel very frustrated, because the results of your hard work for a few weeks may be overwhelmed.
Comparison of PostgreSQL database backup and recovery technologies
There are three completely different methods to back up PostgreSQL data:
SQL dump
File System-level backup
Online backup
I. SQL dump
The pg_dump application tool is used to
PostgreSQL is a very complex object-relational database management system (ORDBMS), and is currently the most powerful, feature richest and most complex free software database system.os:centos6.5 x64ip:192.168.85.130Hostname:vm2.lansgg.comPG Version:
Comparison between PostgreSQL and MySQL
Features
MySQL
PostgreSQL
Instance
Run the MySQL Command (mysqld) to start the instance. One instance can manage one or more databases. One server can run multiple mysqld instances.
BackgroundPostgreSQL logical backup, refers to online backup database data, DDL output as SQL statements, data can be in the form of SQL statements or fixed separators (row format) output.
The backup does not affect the DML operation of the Backup
For PostgreSQL database backup, one of the methods described in the official manual is ldquo and SQLDumprdquo. (another method is to directly back up the files in the file system.
For PostgreSQL database backup, one of the methods described in the
3.4 Replay Transaction logOnce we have created an initial base backup of our own, we can collect the Xlog created by the database. When the time comes, we can use all these xlog files and perform the recovery process we expect. This works as
From: http://bbs.chinaunix.net/thread-1688208-1-1.html
Features
MySQL
PostgreSQL
Instance
Run the MySQL Command (mysqld) to start the instance. One instance can manage one or more databases. One server can run
I. SQL commandII. PostgreSQL client Application
Clusterdb --Cluster a PostgreSQL database
createdb --Create a new PostgreSQL database
Createlang --Installing a PostgreSQL process language
CreateUser --Define a new PostgreSQL user account
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.