Record a production accident -- disk full

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. Troubleshooting On the surface, the database reports errors first ...

Posted on Mon, 10 Feb 2020 07:52:34 -0500 by Kitara

Posgresql uses auto_explain lain for targeted optimization

os: centos 7.4 postgresql: 10.4 auto_explain: 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. install auto_explain is automatically installed using ma ...

Posted on Wed, 22 Jan 2020 11:16:53 -0500 by Alicia

Teuthology Platform Deployment Manual

Teuthology architecture The automated test framework process is roughly as follows: Software Composition 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

Non docker deployment of onlyoffice in ubuntu system

onlyoffice's official website https://www.onlyoffice.com/ https://helpcenter.onlyoffice.com/server/linux/document/linux-installation.aspx 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

PostgreSQL DBA(5) - PG 11 New Features#2

PG 11 will be officially released soon. This section briefly introduces some new features of PG 11, including SQL statement enhancements. 1, SQL statement VACUUM/ANALYZE Support the operation of multiple tables at the same time VACUUM 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

Five uses of postgresql highly available repmgr: manual failover,node rejoin of 1 Primary + 1 Standby

os: ubunbu 16.04 postgresql: 9.6.8 repmgr: 4.1.1 192.168.56.101 node1 192.168.56.102 node2 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 node_id=1 node_name=node1 conninfo='host=192.168.56.101 user=repmgr dbname=repmgr connect_time ...

Posted on Thu, 26 Dec 2019 10:45:21 -0500 by Pyro4816

Four uses of postgresql highly available repmgr 1 Primary + 1 Standby switchover

os: ubunbu 16.04 postgresql: 9.6.8 repmgr: 4.1.1 192.168.56.101 node1 192.168.56.102 node2 Follow the previous blog to install 1 Primary + 1 Standby. Edit / etc/sudoers # vi /etc/sudoers postgres ALL = NOPASSWD: /usr/bin/pg_ctlcluster service_*_command 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

Installation of postmesql physical backup barman

os: ubuntu 16.04 postgresql: 9.6.8 barman: 2.5 ip planning 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

Linux CentOS 7 PostgreSQL 10 installation plpgsql_check extension (source compilation)

Preface 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. download Open web address: https://pgxn.org/dist/plpgsql_check , click the ...

Posted on Tue, 17 Dec 2019 17:59:31 -0500 by frontlines

How to delete all tables in PostgreSQL database?

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. #1 building 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