Postgres data backup restore command

Backup data   Archiving of output directory format Backup in this way can avoid the restriction of the operating system to the size of a single file. pg_dump.exe -U postgres -F d -f E:\mydbbak mydb  After the backup is completed, a backup folder will be generated.   tarFormat archiving (no parallel recovery is supported when recovering with pg_resotre) pg_dump.exe -U postgres -F t mydb > mydb.tar   Generate SQL script pg_dump.exe -U postgres -F p mydb > mydb.sql   Generate custom format archive pg_dump.exe -U postgres -F c mydb > mydb.bin     Apart from S...

(3/7) method parameters for improper usage of enumeration (two)

▄︻┻┳═One Agenda: ▄︻┻┳═1. (1/7) [code tidiness] do you really use enumerations? No! ▄︻┻┳═The method parameters of the (2/7) enumeration error usage ▄︻┻┳═One (3/7) enumeration error method parameter (two) ▄︻┻┳═Method (4/7) enumerated error usage method return value ▄︻┻┳═One (5/7) enumerate the wrong usage of the method inside the body. ▄︻┻┳═The branch judgment of the wrong usage of (6/7) enumeration ▄︻┻┳═(7/7) enumerate the definition of data type by enumeration.     Continue to talk about the use of enumeration....

Global setting

The beginning of the text Software name: =a=,.Zip=a=. Version No.: =b=3.2.5=b= Download address: =x=http://note.youdao.com/noteshare? Id=82d75df16129eff0ac6e867974ed3bb3=z= Notice: =gg==================================== notice = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 3.2.5Version download address: https://pan.baidu.com/s/1UxnE-Ukj59F69IvP1-EbSQ Added the activities of the Seventh Festival. Please log in to QQ ...

[Noip2011] sightseeing bus

Title Description A charming little townYYY City, ownednnn A beautiful scenic spot. There are more and more tourists coming here.YY YThe city has arranged a sightseeing bus specially to provide more convenient transportation services for tourists. Sightseeing buses in the first place00 0Minutes appear111The number of attractions will then go in sequence.2,3,4,…,n 2,3 ,4 ,…,n2,3,4,…,n Sights. From the firstii iThe number of attractions opens to the first place.i+1 i+1i+1 Scenic spot No.Di D_i Di​Minute. At any time, the bus can only go forward or wait at the scenic spot. Joint ownershi...

3.3 global installation

$ npm install Package name -g At this point, the package will be installed on the global level, which is what I said in the morning. C:’\USER\ROAMING’\NPM Some cli (command line programs), engineered things. npm install gulp -g,It will not appear in our project folder, but in the NPM folder. 3.4 Taobao image In order to facilitate Chinese programmers against the government’s GFW, the Great Wall, selective shielding, at this time invented Taobao mirror, keep and stroll Synchronization with the official website. Taobao invented cnpm for the convenience of Chinese programmers...

Java virtual machine learning (5): memory optimization

JVMTuning is mainly aimed at tuning memory management, including controlling the size of each generation, GC policy. Because the GC starts garbage collection when hanging application threads, seriously affecting performance, the purpose of tuning is to minimize the GC caused by the application thread pause time, reduce the number of Full GC. Generation size tuning Key parameters: – Xms, Xmx, – Xmn, – XX: Survivor Ratio, – XX: MaxTenuring Threshold, – XX: PermSize, – XX: MaxPermSize -Xms、 -Xmx Usually set to the same value, avoiding constantly expandin...

Mysql_ reset password

# Modification of coding “`pythonshow variables like ‘%char%’; #View the current encoding 1.Open configuration file: vim /etc/mysql/my.cnf 2.After [client] and [mysqld], add: [client] default-character-set=utf8 [mysqld] character-set-server=utf8 3.Restart mysql: service mysql restart“`       # mysqlreset password “`python#1.Open configuration file: sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf 2. Add in the [mysqld] segment: skip-grant-tables #Skip permission to start MySQL 3.Restart MySQL service mysql restart 4.Log in with root, without pa...

Redis five big data structures commonly used commands

linux Download the redis database. apt install redis If the right is not enough, the right is directly raised. sudo apt install redis-server   linuxEnable and stop service service redis startservice redis stopservice redis restart xshellEnter Linux cd .. # Return to root directory ls # see file cd etc/   Well, it’s time to get to the point. First, record.Connect, exit, switch databaseA command Connect:redis:redis-cli Sign out:exit Switch database:select n The database has no name, 16 by default, identified by 0-15, and the connection redis selects the first database by de...