PostgresSQL-based database automatic installation and deployment method

An automated installation and database technology, applied in the field of software infrastructure, can solve the problems of complex firmware database installation and increased firmware database installation workload, and achieve the effects of improving installation and deployment efficiency, reducing installation and deployment time, and alleviating demand pressure.

Pending Publication Date: 2021-04-30
TIANJIN NAVIGATION INSTR RES INST
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But it is more complicated for the firmware database installation of the equipment software
The increase in the number of equipment will also greatly increase the workload of firmware database installation, and database installation requires software personnel familiar with database operations, which brings pressure on the demand for software technicians

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • PostgresSQL-based database automatic installation and deployment method
  • PostgresSQL-based database automatic installation and deployment method
  • PostgresSQL-based database automatic installation and deployment method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0039] A method for automatically installing and deploying a database based on PostgresSQL, comprising the following steps:

[0040] Step 1. Disk partition management. Disk partition management is used to detect the mounting and partitioning of the drive letter where the database pre-installation disk is located. First, determine the pre-installation disk drive letter based on user input, and determine whether the pre-installation disk drive letter is within the system recognition range. If it is within the system recognition range, check the mounting status. Otherwise, the Shell script returns 1, indicating that the drive is not legal because of the input. Execution fails because of the character, check the mount status in the database pre-installation disk, if there is a mount point, uninstall it; then check the partition status of the database pre-install...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a PostgresSQL (Structured Query Language)-based database automatic installation and deployment method, which is technically characterized by comprising the following steps of: carrying out partition management on a disk through a Shell script, and the partition management comprises disk partition; formatting the disk; mounting the disk; managing a database directory based on PostgresSQL; initializing and starting the database; and deploying a database. Therefore, the full-life-cycle automatic installation and deployment of the disk are realized. According to the method, the automation requirement of firmware database installation can be met. Meanwhile, due to the fact that implementation does not depend on software personnel, the requirement pressure of software technicians is relieved, the labor cost is saved, the conventional database installation and deployment time is shortened, and the database installation and deployment efficiency is greatly improved; The method is of great significance to batch production of equipment of the same type.

Description

technical field [0001] The invention belongs to the field of basic software technology, in particular to a method for automatically installing and deploying a database based on PostgresSQL. Background technique [0002] Database technology is a core technology of information system. By studying the basic theory and implementation methods of database structure, storage, design, management and application, and using these theories to realize the processing, analysis and understanding of data in the database. Database technology is an important part of modern information science and technology, and the core of computer data processing and information management systems. Database technology studies and solves the problem of effectively organizing and storing a large amount of data in the process of computer information processing, reduces data storage redundancy, realizes data sharing, ensures data security, and efficiently retrieves and processes data in the database system. T...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & AuthorityApplications(China)
IPC IPC(8): G06F8/61G06F9/4401G06F16/21
CPCG06F8/61G06F9/4411G06F16/211
Inventor张敏李永波刘双妹孙文本乔岩
OwnerTIANJIN NAVIGATION INSTR RES INST