PostgreSQL Tutorial (vi): A detailed explanation of functions and operators (2) _postgresql

Vi. Pattern Matching: PostgreSQL provides three ways to implement pattern matching: SQL Like operator, more recent similar to operator, and posix-style regular expression.1. Like: Copy Code code as follows: string like pattern

Comparison between MySQL and PostgreSQL

Characteristics Mysql PostgreSQL Instance Start the instance by executing the MySQL command (MYSQLD). One instance can manage one or more databases. A single server can run multiple mysqld instances. An instance manager can

How PostgreSQL handles Dead connections (GO)

In database PostgreSQL, a client-to-server connection is actually a TCP socket connection, the TCP connection is a virtual connection, the other party exits abnormally (such as a power outage), and the other party continues to maintain the

Analysis of PostgreSQL database transaction and ROW lock features

In the field of open source database, PostgreSQL is well-deserved for its superior performance, function and good stability, especially for high concurrency support. and superior performance and stability, it is nothing but a good infrastructure,

Install Postgresql in Ubutnu 16.04 LTS

The PostgreSQL database is a high-performance, full-featured, open-source relational database that explains how to install PostgreSQL 10 under Ubuntu 16.04 LTS.Add a software sourcewget -q -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc |

PostgreSQL Database Operations

Create a databaseCREATEDATABASE name WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] [ LC_COLLATE [=] lc_collate ] [ LC_CTYPE [=] lc_ctype ]

PostgreSQL CPU Full (100%) performance analysis and optimization

PostgreSQL CPU Full (100%) performance analysis and optimizationTransferred from: https://help.aliyun.com/knowledge_detail/43562.htmlIn database operations, a DBA often encounters a more urgent problem, that is, the sudden CPU full (CPU utilization

Free to install PostgreSQL startup service and CREATE database

Installation Environment Windows7 64-bit systemFree Install version postgresql-10.3-1-windows-x64-binaries=======================================Decompression after unable to connect to the database, PGADMIN4 can not start, online to find a variety

POSTGRESQL-JDBC suspected BUG: The table name and column name of the partial interface parameter must all lowercase

After the project was ported from Oracle to PostgreSQL (version 9.4), the days went down again, tracked and positioned to determine that the call to the Pgdatabasemetadata.getprimarykeys () interface returned an empty set.It is well known that in

PostgreSQL installation and simple use

I. Introduction of PostgreSQL1. What is PostgreSQLThe PostgreSQL database is the most powerful open source database available, supporting rich data types such as JSON jsonb type, array type, and custom types. And it provides a rich interface that

Installation and configuration of the CentOS 6.3 under PostgreSQL

First, IntroductionPostgreSQL is a very complex object-relational database management system (ORDBMS), and is currently the most powerful, feature richest and most complex free software database system. Some features don't even have a commercial

PostgreSQL Archive Error

Running out of disk space in the Pg_xlog directory is a fairly common Postgres problem. This important directory holds the WAL (Write Ahead Log) files. (WAL files contain a record of all changes made to the Database-see the link for more details).

Windows installation PostgreSQL

Download binary package: https://www.enterprisedb.com/download-postgresql-binariesUnzip directly to C driveMicrosoft Windows [version 6.3.9600](c) Microsoft Corporation. All rights reserved.C:\USERS\XXXX>CD

PostgreSQL high availability, load balancing, replication and cluster scenario introduction

Catalogue [-] One, high availability, load balancing, replication of several scenarios comparison: Two, multi-node cluster scheme comparison 9.3 Official Document (Chinese):

Ubuntu installs PostgreSQL and PostGIS

1. Installing PostgreSQL$sudo Apt-cache Search PostgreSQL//Find the latest PostgreSQL package$sudo Gem apt-get Install PostgreSQL package name//select Package name for installationInstalling PostGIS$sudo Apt-cache Search PostGIS//Find the latest

Possible useful knowledge in PostgreSQL development

The time can be added and reduced directly in PostgreSQL: Query System Current Time: Select Now ();OrSelect Current_timestamp; SELECT now ():: Timestamp + ' 1 year '; --Current time plus 1 yearsSELECT now ():: Timestamp + ' 1 month '; --Current

Avoiding PostgreSQL Database corruption

tl;dr: Don ' t ever set Fsync=off, don ' t kill-9 The postmaster then deletepostmaster.pid, don ' t run PostgreSQL on network file systems.Reports of database corruption on the PostgreSQL mailing list is uncommon, but hardly rare. While a few data

PostgreSQL Replication's second chapter understands the transaction log of PostgreSQL (4)

2.4 Adjusting checkpoints and xlogSo far, this chapter has provided insight into how PostgreSQL writes data, in general, what Xlog is used for. Given this knowledge, we can now continue and learn what we can do to make our databases work more

PostgreSQL database cluster and PL/proxy configuration Installation Guide

  Author: icyriverSource: http://icyriver.net /? P = 176     PL/ProxyAndPostgreSQLThe structure relationship of the cluster can be clearly expressed. If you are not familiar with pL/proxy and PostgreSQL clusters, you can seeSkype plans for

Step-by-Step PostgreSQL: Implement PostgreSQL self-starting

In the case of manual installation (for the case where the source code is compiled for PG or the decompressed version is installed for PG), PG does not start automatically when it is started, and stops automatically when it is turned off, as a DBA,

Total Pages: 77 1 .... 12 13 14 15 16 .... 77 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.