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
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
(1) User PracticalityProgram:
Createdb creates a new PostgreSQL database (same as SQL statement: Create Database)
Createuser creates a new PostgreSQL user (same as SQL statement: create user)
Dropdb deletes a database
Dropuser: delete a user
The database used recently for work has been PostgreSQL, an open source database, and any individual can use the database for commercial purposes. In the use of PostgreSQL, let me the most obvious feeling is that the database is really good,
PostgreSQL-related software, libraries, tools, and resource collections.Backup
WAL-E-Simple continuous archiving for Postgres to S3, Azure, or Swift by Heroku
Barman-backup and Recovery Manager for Postgres by 2ndQuadrant
Gui
If you do not start the Postgres process after you upgrade the database, and check the log to find similar information like the following: Fatal:database files are incompatible with server Detail:the Data directory is initialized by PostgreSQL
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
Common postgresql commands (1) User utility: createdb creates a new PostgreSQL database (same as the SQL statement: CREATEDATABASE) createuser creates a new PostgreSQL user (same as the SQL statement: same as CREATEUSER) dropdb delete database
Transferred from: http://blog.csdn.net/qpengyanting123/article/details/7497556(1) User utility program:Createdb Create a new PostgreSQL database (and the SQL statement: Create DATABASE is the same)CreateUser Create a new PostgreSQL user (and SQL
?? ? ? ? ? ? ? ?Reference: http://book.51cto.com/art/201201/313175.htmSystem ArchitecturePostgreSQL database consists of the connection management system (System Controller), the compiled execution system, the storage management system, the
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.