POSTGRESQL: get member roles and permissions
briefly PostgreSQL provides a highly complex and powerful security permission system. It allows you to define users (= roles), groups, and so on. However, without a graphical user interface, it is often difficult to know which role to assign. The following blog post explains how to do this. LeUTF-8...
Posted by Steven_belfast on Mon, 27 Sep 2021 07:17:02 +0530
Share this article to learn about the instant recovery of PG PITR
Author: Yanbo Qingyun technology database R & D EngineerAt present, he is engaged in the development of PostgreSQL products and is keen on the study and research of PostgreSQL databaseIn the database system, data is the basis of everything, and the security of data is the top priority. However,UTF-8...
Posted by TecTao on Fri, 05 Nov 2021 11:26:59 +0530
datax detailed introduction and use
1, dataX overview 1.1 DataX DataX is an offline data synchronization tool / platform widely used in Alibaba group, including MySQL, SQL Server, Oracle PostgreSQL , HDFS, Hive, HBase, OTS, ODPS and other heterogeneous data sources. 1.2 Features DataX itself acts as data synchronization frame , UTF-8...
Posted by m4x3vo on Thu, 10 Mar 2022 17:49:13 +0530
Huashan sword of three database sequence s
sequence usage 4 AUTO INCREMENT You still need to create a sequence manually through DEFAULT. Is there a simpler usage? Of course, it is through AUTO INCREMENT, automatically create sequence, and automatically call in DEFAULT! Oracle Similarly, Oracle also 12c began to support AUTO INCREMENT. TUTF-8...
Posted by nootropil on Fri, 11 Mar 2022 04:34:52 +0530
Problems encountered in starting Postgresql under WSL Ubuntu
1. WSL related version information Wsl2 installed under Win10, Ubuntu 20.04.03 LTS, PostgreSQL version: 14.2. C:\Users\becker>wsl -l -v NAME STATE VERSION * Ubuntu-20.04 Running 2 C:\Users\becker>bash Welcome to Ubuntu 20.04.3 LTS (GNU/Linux 5.10.60.1-microsoft-standard-WSL2 x86_64) * DocumentaUTF-8...
Posted by angryjohnny on Sun, 13 Mar 2022 00:22:59 +0530
GreenPlum enterprise application practice Chapter 4 detailed explanation of data dictionary
4.1 oid everywhere The oid is incremental. Each table space, table, index, data file name, function, constraint, etc. corresponds to an oid with unique identification. Global increment. select attrelid::regclass,attname from pg_attribute a, pg_class b where a.attrelid = b.oid and b.relnamespaceUTF-8...
Posted by Arenium on Mon, 14 Mar 2022 04:34:46 +0530
Qt database application 15 - General Database Synchronization
1, Foreword The main function of database synchronization is to synchronize the local database records to the remote database. There are no restrictions on database types. For example, the local database is sqlite database, the remote database can be mysql database, the local database can be myUTF-8...
Posted by smithmr8 on Mon, 14 Mar 2022 04:57:07 +0530
Database specification
0. Pre description The database of the fee control system will be deployed in different environments. To adapt: mysql,oracle,postgresql,Damon database. Therefore, when we do database design, we must consider the situation of various databases and try to use them as much as possible sql StandardUTF-8...
Posted by pk-uk on Mon, 14 Mar 2022 10:20:54 +0530
Use of sqlite database
Use of sqlite database Enter database sqlite3 module_build_service.db Query all tables sqlite> .table To create a database file: >SQLite3 d:\test.db enter #It generates a test DB is on disk d. In this way, SQLite3 also hangs this test db Watch structure >.schema Table name Look at the database UTF-8...
Posted by CoffeeOD on Wed, 16 Mar 2022 13:17:24 +0530
[KingbaseES] R6 warranty rectification and review method (cluster)
What is equal guarantee evaluation` The full name is the evaluation of information security level protection. It is a qualified evaluation organization certified by the Ministry of public security. It is an activity to detect and evaluate the security level protection status of information sysUTF-8...
Posted by mervyndk on Sun, 20 Mar 2022 00:57:34 +0530