Insert data of SQL bit by bit series

[SQL from bit by bit Analysis series articles] is a bit by bit summary in actual development, from the simplest SQL query to comprehensive analysis query When analyzing SQL, related operations in mybatis and Hibernate will also be analyzedClick to view details This section describes inserting data in ...

Posted by Paul1893 on Sat, 22 Feb 2020 09:04:51 -0800

Modifying the PostgreSQL field length results in a cached plan must not change result type error

problem There is business feedback that Java applications keep reporting the following errors after modifying the length of a table field, but the fewer errors that follow, the fewer errors that will not occur in 15 minutes. ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: cached plan must not change result type R ...

Posted by trrobnett on Mon, 06 Jan 2020 04:37:16 -0800

Installing 32-bit PostgreSQL 8 on 64 bit CentOS 7

Recently, Alibaba cloud urged a friend to deal with the system vulnerability quickly, and shut down the machine if he didn't deal with it again. This friend deployed 32-bit PostgreSQL 8.1 on a CentOS 6 host in Alibaba cloud. He wants to use this. Think about it, or install PostgreSQL 8.1 on CentOS 7. The former is a 64 bit operating system, an ...

Posted by Majes on Mon, 30 Dec 2019 18:50:21 -0800

EMQ X plug-in persistence series PostgreSQL data persistence

This chapter uses the actual example in CentOS 7.2 to show how to store relevant information through PostgreSQL. As an important member of the open-source relational database, PostgreSQL boasts that it is the most advanced open-source database in the world. Compared with other open-source relational databases such as MySQL, PostgreSQL is a comm ...

Posted by del753 on Thu, 26 Dec 2019 22:58:37 -0800

Three uses of postgresql highly available repmgr: 1 Primary + 1 Standby installation

os: ubunbu 16.04 postgresql: 9.6.8 repmgr: 4.1.1 192.168.56.101 node1 192.168.56.102 node2 Install postgresql 9.6 software Both node1 and node2 need to use apt install to install postgresql9.6.8. The last bit represents the patch number # apt install postgresql-plpython-9.6 postgresql-plperl-9.6 postgresql-pltcl-9.6 postgresql ...

Posted by kaedus on Thu, 26 Dec 2019 06:57:43 -0800

PG fdw connection establishment and closure

PG starts psql locally, accesses external tables, and exits The connection between PG and remotePG is broken as the client psql exits.   PG starts multiple psqls locally, and each psql accesses the external table once View remotePG process postgres@ubuntu:~$ ps -ef|grep post root 134 89 0 09:36 pts/0 00:00 ...

Posted by jollyjumper on Sun, 22 Dec 2019 07:41:52 -0800

Installation and use of greenplus plug-in tablefunc (row column conversion)

Note: this plug-in is only demonstrated in the test environment. If it is used in the production environment, please assess the risk yourself Environment list: Host 1: intranet: 125.10.1.166 System configuration list: IP HOSTNAME CPU MEM DISK RELEASE 1 ...

Posted by beermaker74 on Sun, 15 Dec 2019 12:44:00 -0800

Today, let's talk about how to build a watch efficiently

"High efficiency" means the speed of table building is fast? no, it's 9012 years. What do you want? Efficient table creation refers to how to quickly query this table. Under the same resource conditions, the query performance is better than that of ordinary tables!When we build a table, we usually attach attributes to the table, such ...

Posted by birdie on Fri, 13 Dec 2019 00:37:57 -0800

Use guide for Foreign Data Wrappers of PostgreSQL

The function of PostgreSQL's fdw implementation is the cross database operation between each PostgreSQL database and the remote database. The function is the same as oracle's dblink. The environment in this article is shown below: 1.1. Target installation software package [root@hdp06 ~]# yum -y install postgresql10-contrib.x86_64 1.2 creating ...

Posted by introvert on Sat, 07 Dec 2019 14:14:23 -0800

PostgreSQL spatial aggregation performance - administrative area, electronic fence spatial aggregation - time, space thermal map

Label PostgreSQL, spatial aggregation, spatial heat map, administrative region, electronic fence background For a certain time interval (or other conditions), how many objects (space point information) appear in some fences and administrative areas (polygon information), and render these polygons by color depth. for example Example 1. Are ...

Posted by ZephyrWest on Thu, 21 Nov 2019 14:12:51 -0800