MIGRATION METHOD BASED ON POSTGRESQL BLOCK STORAGE DEVICE

摘要

A migration method based on a PostgreSQL block storage device, using a PostgreSQL block storage device read-write module to perform read and write operations to PostgreSQL blocks, the PostgreSQL block storage device read-write module managing, by means of an idle PostgreSQL block table and a table of mapping relationship between the PostgreSQL blocks and data tables, the PostgreSQL blocks in the PostgreSQL block storage device, copying the idle PostgreSQL block table and the table of mapping relationships between the PostgreSQL blocks and the data tables from an original database to a new database, and migrating the PostgreSQL block storage device from the computer in which the original database is located to the computer in which the new database is located. Migrating database between different systems by means of the migration method based on the PostgreSQL block storage device is easy, without a high requirement for the professional knowledge to operators. The query speed and the read-write speed can be improved, the speeds being improved by 10%-20% under the same condition of backend storage.