Written in front
Today, in the production environment running on Alibaba cloud ECS, all of a sudden, the access is abnormal and the interface reports errors. However, the company has no professional operation and maintenance personnel, so it can only solve the problem on its own.
On the surface, the database reports errors first ...
Posted on Mon, 10 Feb 2020 07:52:34 -0500 by Kitara
os: centos 7.4
Auto_explainlain is a feature added after postgresql 8.4 that provides a way to automatically record execution plans for slow statements without having to run EXPLAIN manually.
This is very important in the real world.
auto_explain is automatically installed using ma ...
Posted on Wed, 22 Jan 2020 11:16:53 -0500 by Alicia
The automated test framework process is roughly as follows:
The software used by the Teuthology test framework consists of the following components:
Jenkins Continuous Integration Tool
teuthology Ceph test suite
shaman queries provide chacra nodes for packages, scaling out and dispatching chacra no ...
Posted on Mon, 20 Jan 2020 23:02:24 -0500 by rickead2000
onlyoffice's official website https://www.onlyoffice.com/
Today's onlyoffice s are all built by docker, which is very simple. However, in order to have a deeper understanding and modify the website later, it is also a good choice to try to manua ...
Posted on Tue, 31 Dec 2019 14:37:32 -0500 by eddy556
PG 11 will be officially released soon. This section briefly introduces some new features of PG 11, including SQL statement enhancements.
1, SQL statement
Support the operation of multiple tables at the same time
testdb=# vacuum verbose t_hash1,t_hash2;
INFO: vacuuming "public.t_hash1_1"
INFO: "t_hash1_1": f ...
Posted on Sat, 28 Dec 2019 14:32:00 -0500 by er0x
os: ubunbu 16.04
Contents of / etc/repmgr.conf before operation
The contents of files on node1 node are similar to those on node2 node
$ cat /etc/repmgr.conf
conninfo='host=192.168.56.101 user=repmgr dbname=repmgr connect_time ...
Posted on Thu, 26 Dec 2019 10:45:21 -0500 by Pyro4816
os: ubunbu 16.04
Follow the previous blog to install 1 Primary + 1 Standby.
Edit / etc/sudoers
# vi /etc/sudoers
postgres ALL = NOPASSWD: /usr/bin/pg_ctlcluster
Both node1 and node2 need to be set
Important: Debian/Ubuntu users: ins ...
Posted on Thu, 26 Dec 2019 09:47:20 -0500 by jobs
os: ubuntu 16.04
192.168.56.101 node1 barman
192.168.56.102 node2 postgresql
barman is a postgresql open source backup software launched by 2nd quadrant, which is introduced on the official website.
barman suggests a dedicated server. Try not to deploy to postgresql server, but not to po ...
Posted on Thu, 19 Dec 2019 13:51:07 -0500 by Jackanape
The previous blog recorded the installation of PostgreSQL 9.5 in Linux CentOS 7( Linux CentOS 7 installation of PostgreSQL 9.5 ), this blog records that PostgreSQL 10 installs the plpgsql_check extension in the form of source code compilation.
Open web address: https://pgxn.org/dist/plpgsql_check , click the ...
Posted on Tue, 17 Dec 2019 17:59:31 -0500 by frontlines
How do I remove all tables in PostgreSQL from the command line?
I don't want to delete the database itself, just all the tables and all the data in them.
According to Pablo above, in terms of the case, remove from the specific pattern:
select 'drop table "' || tablename || '" cascade;'
from pg_tables where schemaname = ...
Posted on Mon, 16 Dec 2019 13:34:27 -0500 by rndilger