Function Introduction
POSTGRES-XC/XL/X2 is an open source project. It provides a multiple-master synchronous, transparent, PostgreSQL cluster solution. Unlike other cluster tools, it has a strong scalability when writing data, and introduces the
first, the use of Pg_dump:Import and export of databases is one of the most commonly used features, each of which provides tools for this, such as Oracle's Exp/imp,informix Dbexp/dbimp,mysql mysqldump, and PostgreSQL provides a corresponding tool
Postgresql automatic backup generates one file every day and compresses it automatically: 1. write a shell script and save it as/home/db/dump. shpg_dumpdb | gzip & gt;/home/db/db((date?policy=m=d=.backup.gz $ (date + % Y % m % d) can be set by
0. Remove unnecessary tables and stored procedures from the 200 server Setup database
DROP TABLE "Sensorpressure";DROP FUNCTION hex_to_int (text);DROP FUNCTION "Pressuredatatosensorpressure" ();
1. Back up 200 of the SETUPD database,:p g_dump-d-H
Tag: User CTI SSI create cancels VAR use SSE byteTransferred from: https://www.cnblogs.com/chjbbs/p/6480687.htmlUsage:Pg_dump [OPTION] ... [DBNAME] The database name is last, not specified by default is the database specified by the system variable
Recently the company requested to back up the database, so we looked up the comparative information. Don't say much nonsense, into the subject.Objective: To regularly back up the Postgres database under Ubuntu, and to pack and upload to the
Backup and restore are most important when you are transporting a database. Today, we tested backup and restore using Pg_dumpall.
Backup Restore method: Pg_dump and Pg_restore, first carefully explain these two commands
Back up the database,
Usage:Pg_dump [OPTION] ... [DBNAME] DatabaseLast name, do not specify the default is the database specified by the system variable pgdatabase.General Options: (generic option)-F,--file=filename output file or directory nameFile name saved after
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
Seven, Pg_dump:
Pg_dump is a tool for backing up the PostgreSQL database. It can even make a full, consistent backup when the database is being used concurrently, without blocking access to the database by other users. The dump format generated by
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.