PostgreSQL

Let me start with a bit of chatter. I've been working happily with MySQL, a time-tested old friend. But since the understanding of a little PostgreSQL, it is fascinated by its rich functional characteristics. For example, field types natively

The steps to create a table partition are as follows: 1. Create the Main tableCREATE TABLE users (UID int not null primary key, name varchar (20)); 2. Create the partition table (you must inherit the main table above) CREATE TABLE users_0 (check (

XML Content Generation sectionSQL data to generate XML functions.1. Xmlcomment: Generate annotation functions. Xmlcomment (text)Cases:SELECT xmlcomment (' hello ');Xmlcomment--------------2. xmlconcat:xml Connection function Xmlconcat (XML [,

--Get the database software versionSelect version ();--Get Database startup timeSelect Pg_postmaster_start_time ();--Get configuration file last load timeSelect Pg_conf_load_time ();--Get the current database time zoneShow TimeZone;--Get all the

1. When you start recovery, determine the time line that you restored to Recoverytargettli1) Archive recovery point is larger than the time line recorded in Checkpoint, then select Archive recovery point as target timeline2) Otherwise, the time line

PostgreSQL partition table, the operability is quite convenient.However, you can only decide whether to partition the table at creation time, and decide on the partition criteria field, after the normal table is created, you cannot modify the

PostgreSQL manages database access through roles, and we can treat a role as a database user or a group of database users. Roles can have database objects, such as tables, indexes, or permissions on those objects to other roles to control which

Since it was installed in the United States of PostgreSQL, resulting in the return to Shanghai after use, found that the time data display is incorrect.To acomplish the timezone change in Postgres 9.6 you must:(1) View current timezone:Show TimeZone;

This paper mainly describes several main processes of PG, and the core architecture of PG. Process and architecture See:As can be seen from the architecture diagram above, PG uses the classic C/s architecture, the process architecture. There are a

Operating system: centos6.9_x64Installing the DatabaseUse the following command:Yum Install postgresql-server-ySet boot up:Chkconfig PostgreSQL onStart the database:Service PostgreSQL StartAfter installation, a database named Postgres and a database

The standby node was automatically promoted to a writable node when the file specified by the Trigger_file parameter was found to exist before the Pgpoll was studied. You do not need to perform pg_ctl promote manually, but this time is generally

Yum-y install gcc make readline zlib readline-devel zlib-develTAR-JXVF postgresql-9.5.2.tar.bz2CD postgresql-9.5.2Groupadd PostgresUseradd-g Postgres Postgresecho "dbking588" | passwd--stdin Postgres./configure--prefix=/opt/pg952Gmake WorldGmake

1. Useful LinksPostgreSQL Common small functionssome string manipulation functions of the PostgreSQL databasefunction called in PostgreSQL functionPostgreSQL Learning Manual (Functions and Operators )A simple way to get started with PostgreSQL

1 build Large tables.2 Creating partition Inheritance   3 define rule or trigger? 1 Building Large TablesCREATE table student  (student_id bigserial, name varchar (+),  score smallint) 2 create partition Inheritance

Recently, due to performance issues, we have changed tables with large data volumes to partition tables ). This process is also very difficult in PostgreSQL. Refer to my other article.Article. It was a good thing to benefit the country and the

From: http://blog.csdn.net/lengzijian/article/details/8252270   I don't want to explain the installation and use of pgfincore too much. I just want to record my usage experience. If you want to read more, please refer to the following content:

ToHttp://wwwmaster.postgresql.org/download/mirrors-ftp? File?binary=2fv8.1.4%2fwin32%2f%sql-8.1.4-1.zipSelect a country with fast download speeds to download the PostgreSQL database To Http://jdbc.postgresql.org/download.html download JDBC

PostgreSQL creates a table using a data dictionary without the need to create a table Today, I have a simple understanding of postgresql's data dictionary. The postgre table structure and other information are stored in the data dictionary, can we

Root Account Logon: suRoot Delete: rpm-Qa | grep PostgreSQL | xargs rpm-e -- nodeps Query: rpm-Qa | grep PostgreSQL Windows Client: pgadmin III or phpPgAdmin Http://www.postgresql.org/download/ # Useradd postgre (automatically create a postgre

In the previous article, I talked about the xlog header. Today I will explain the record part in detail. I hope these two articles will help the xlog Study of postgresql: From: http://blog.csdn.net/lengzijian/article/details/7840332 First, let's