Programming VIP

WeChat official account: operation and development story, author: Jiang Zong Hello, I'm Xiao Jiang. A low-level operation and maintenance engineer. The previous article talked about the source code deployment of PostgreSQl 12. Here we talk about the master-slave stream replication and archiving configuration of PostgreSQl 12. Two forms of ...

catalogue 0 psql introduction 2.3 console commands 2.5 database import and export 2.6 problem solving 3.API usage 3.0 libpqxx compilation 3.2 connection examples 3.3 creating an example 3.4 added examples 3.5 selection examples 3.6 modification example 3.7 delete example 5. Reference: 0 psql introduction In d ...

Today, I saw someone on the Internet asking me to delete PG by mistake_ filenode. How to restore or rebuild a map? Let's learn about PG before solving this problem_ filenode. Map file. For each table in PostgreSQL, there are files related to it on disk, and the name of these files is relfilenode. We can use pg_class to query the relfilenode fi ...

1, JSON and JSONB Compared with other relational databases, Postgresql has a great advantage in that it has built-in many special data types, such as inet and MAC. The json and json types introduced in this paper are also two unique data types of Postgresql. In fact, their essence is to store data in jon format, However, the difference is that ...

1. Concept combing 1.1 PostgreSQL database file composition: Physical file It consists of a series of physical files located on the operating system, which are usually called databases. Logical file During the operation of the database, these physical files are managed through a complete set of efficient and rigorous ...

PostgreSQL uses message based protocols to communicate between the front end and the back end (client and server). T port number 5432 is registered with IANA as the preferred TCP port number of servers supporting this protocol, but actually any non privileged port number can be used. What is PostgreSQL? PostgreSQL, also known as Postgres, is ...

When we want to operate on the client side of PostgreSQL, we need to access the database from the remote end. At this time, PostgreSQL artifact PostgREST can be launched. PostgREST is a server that can help us generate a series of restful APIs for operating PostgreSQL databases. I also tried to use NGX in Nginx directly before_ The Postgres mod ...

For image download, domain name resolution and time synchronization, please click Alibaba cloud open source mirror This section describes the basic operations of using a database. This section enables you to create a database, create a table, insert data into the table, and query the data in the table. 2.1 preconditions ● openGauss operates ...

1, BRIN index principle In this article, we will continue to learn another characteristic index in Postgresql - BRIN index. BRIN index is the abbreviation of Block Range Index. It groups the blocks of data on the disk according to a certain number, which can be determined by the parameter pages when creating BRIN_ per_ Range. The default value ...

I Introduction to internal rate of return (IRR) The Internal Rate of Return (IRR) is when NPV (net present value) is equal to zero Discount rate . To calculate the internal rate of return, several discount rates are used for trial calculation until the discount rate with net present value equal to or close to zero is found. Internal rate of r ...