GitLab backup and recovery

Because the company changed the server service provider and the server was migrated to another service provider, today we will simulate the operation of online migration of gitlab git-A IP:192.168.82.184 git-B IP:192.168.82.184 If the version number is the same, the backup migration will fail   Step 1.gitlab backup gita-A #c ...

Posted by vichiq on Tue, 31 Mar 2020 10:54:28 -0700

Some small operations of gitlab

1, Install gitlab Reference blog Gitlab installation and application of continuous integration Install gitlab, and perform the basic operation of the third and remote library 2, Mail verification registration Email reminders can be used to register users and need to be verified by email. They will also be reminded when gitlab uploads code or d ...

Posted by Megalink on Thu, 19 Mar 2020 10:53:41 -0700

Default values in dogma

How to set the default value in doctrine2? #1 building <?php /** * @Entity */ class myEntity { /** * @var string * * @ORM\Column(name="myColumn", type="integer", options={"default" : 0}) */ private $myColumn; ... } Note that this uses SQL DEFAULT, which is not supported for some fields, such as BLOB ...

Posted by rami103 on Tue, 17 Mar 2020 07:45:49 -0700

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