install pg dump

One, database upgrade 9.4 to 9.51.pg_dump Import and export (used when data volume is small)Postgres User Login$ pg_dumpall > Db_export.out$ env|grep LANGLang=en_us. UTF-8If the database character set is en_US. UTF-8, the system character set is

When writing programs, especially embedded programs, we usually need to analyze the program's performance so that the program can run faster and better to achieve real-time. If the program is large, it will be difficult to analyze it. If there is a

PostgreSQL physical file ing We know that in PG, each relation, that is, the table, has several fork mappings. "MAIN" fork is used to store the data in the master table, "FSM" fork is used to manage the free space, and "visibility" fork is used to

Ceph environment setup (2)1. There are three layout hosts: node1, node2, and node3. Each host has three osdks, as shown in figure. osd1, and 8 are SSD disks, 4 is the SATA disk. Each of the three hosts has a Monitor and an MDS. We use osd1, 3, and 4

Introduction to C development tools in Linux-general Linux technology-Linux programming and kernel information. The following is a detailed description. The Linux release contains many software development tools. many of them are used for C and C ++

The Linux release contains many software development tools. many of them are used for C and C ++ application development. this article describes the tools that can be used for C application development and debugging in Linux. the purpose of this

After being acquired by sun and oracle, Mysql has not been acquired by the oracle giant. On the contrary, it has been developing very fast in recent years. everyone knows that oracle is not doing well with mysql, the open-source market will be

The PHP version of Mamp is compiled without the--enable-debug option, so I'm going to recompile php myself so that I can use GDB to view the core dump file when I do my php extension research. First use the PHP version in Mamp to view Phpinfo ()Got

Sometimes, we pay special attention to program performance, especially the underlying software, such as drivers and OS. In order to better optimize the program performance, we must find the performance bottleneck. "Good steel is used on the blade"

Mysql在被sun，继而被oracle收购之后，并没有被oracle这个巨人雪藏，反而近几年的发展速度极为之快，谁都知道，你oracle做不好mysql，开源的市场就会被别人取代，pg，MariaDB，percona