[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
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
Posted by trrobnett on Mon, 06 Jan 2020 04:37:16 -0800
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
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
os: ubunbu 16.04
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 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
Note: this plug-in is only demonstrated in the test environment. If it is used in the production environment, please assess the risk yourself
Host 1: intranet: 18.104.22.168
System configuration list:
Posted by beermaker74 on Sun, 15 Dec 2019 12:44:00 -0800
"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
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, spatial heat map, administrative region, electronic fence
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.
1. Are ...
Posted by ZephyrWest on Thu, 21 Nov 2019 14:12:51 -0800