Very intimate wheel FreeSql

Since the development of FreeSql project on November 28, 2018, the version has been released to v0.3.12. Version rule: number of years month day version number of the day. At present, it mainly includes the maintenance and development of FreeSql and FreeSql.Repository. This article introduces some intimate functions. Error: the incoming reques ...

Posted on Mon, 18 Nov 2019 04:54:46 -0500 by songwind

Getting started with PostgreSQL - installation and basic use (Ubuntu 16)

Getting started with PostgreSQL - installation and basic use (Ubuntu) PostgreSQL is a free object relational database server (ORDBMS), known as "the most advanced open source relational database in the world". PostgreSQL is an object relational database based on Postgres version 4.2 developed by the computer department of the Univers ...

Posted on Thu, 14 Nov 2019 23:13:34 -0500 by bad_goose

PostgreSQL master-slave switch test

Explain An exception occurs in PostgreSQL (hot standby) such as the main database. How to activate the standby database to replace the master database. There are two ways The backup database has a configuration item trigger file in the recovery.conf file. It is the trigger file to activate sta ...

Posted on Thu, 31 Oct 2019 10:04:51 -0400 by thepriest

Postgresql & Pgpool scenario problems and Solutions

Original address: https://www.tony-yin.site/201... This paper summarizes some common problems and solutions of postgresql and pgpool. Environmental Science PostgreSQL is the data back-end, and pgpool is the middleware of PostgreSQL. It provides services to clients through vip, and uses its own failover mechanism to ensure database HA. Nodes: ...

Posted on Tue, 29 Oct 2019 07:16:22 -0400 by LD Ablo

PostgreSQL of Prometheus remote data storage scheme

Today, I saw the remote data storage scheme of prometheus based on postgresql shared by de Ge, so I had the experiment of this paper. Generally, prometheus has several options for external storage, such as influxdb, m3db, es, postgresql. Generally, m3db is better used in the cloud native environment. Here we demonstrate the remote storage sc ...

Posted on Mon, 28 Oct 2019 14:48:20 -0400 by PHP Novice

PostgreSQL 12 stream replication environment construction

1. Profile merging There was an error setting up the stream replication environment using PostgreSQL 12. To view the Release information: https://www.postgresql.org/docs/12/release-12.html You can find the following information: Move recovery.conf settings into postgresql.conf (Masao Fujii, Simon Riggs, Abhijit Menon-Sen, Sergei Kornilov) reco ...

Posted on Mon, 28 Oct 2019 10:31:22 -0400 by nyfael

PostgreSql source code installation

I. source code installation 1. Redhat7 modify the host name:   [root@localhost ~]# hostnamectl set-hostname ygg Inspection:   [root@localhost ~]# hostnamectl    Static hostname: ygg          Icon name: computer-vm            Chassis: vm         Machine ID: 19e8c6b6164b453b8816e1a002badeec            Boot ID: b9793f1a2e8c4dbcbf99f9f011563fe6   ...

Posted on Sun, 27 Oct 2019 00:14:22 -0400 by velanzia

Pgpool-II + PostgreSQL one main source and two standby source compiling environment

Host IP Virtual IP server1 192.168.222.141 192.168.222.200 server2 192.168.222.142 server3 192.168.222.143 Item Value Detail PostgreSQL version 10.10 Installation path /opt/PG-10.10 port 5432 $PGDATA /opt/PG-10.10/data Archive mode on /opt/PG-10.10/archivedir Boot from boot Disable Pgpool-II Version 4.0 ...

Posted on Thu, 17 Oct 2019 12:23:45 -0400 by tetecko81sk

gitlab resets the password of root

gitlab administrator account can create accounts for ordinary users, assign permissions, have all project and group permissions, ordinary users after the completion of the new, need administrators to assign appropriate permissions, in order to use normally. If the password of the administrator's account is forgotten, it can generally be retrie ...

Posted on Thu, 10 Oct 2019 06:18:09 -0400 by McJepp

Construction of docker container - sonarqube

1. Setting up sonar server 1. Use the postgresql database Build postgresql docker run -d -p 5432:5432 --name postgresql -e POSTGRES_USER=sonar -e POSTGRES_PASSWORD=sonar postgres Reconstruct the sonar image. Download Chinese Package Dockerfile is as follows (other plug-ins can also be added): FROM ...

Posted on Tue, 08 Oct 2019 21:45:38 -0400 by someone2088