PostgreSQL view database, index, table, table space Size sample code _postgresql

First, Introduction PostgreSQL provides a number of system management functions to view tables, indexes, table spaces, and the size of the database, described in detail below. second, the Database object dimension function The name

PostgreSQL 9.6 Synchronous multi-replica and Remote_apply Transaction synchronization level field analysis

Background For financial-level scenarios, 2 replicas are usually not enough, and users may need multiple replicas. For example, a master 4 from, requires in addition to the master, also requires 2 synchronized copies, others can be asynchronous

OSS Loading data to PostgreSQL

Oss_fdw On the Ali cloud, supports loading data into PostgreSQL and PPAs by OSS_FDW parallel OSS_FDW parameters Like other FDW interfaces, OSS_FDW provides data encapsulation of OSS for external data sources, and users can use OSS_FDW to read

Change your site from MySQL to PostgreSQL

"Guide" This article is divided into two parts, the first part of my motives for this conversion, and step-by-step explanation of how the existing MySQL data into the postgres. The second part will explain how to adjust PHP to the new database

Centos 7.x configuration PostgreSQL self-booting

PostgreSQL starts with the systemThe document describe the Configure automatic start PostgreSQL when the system starts.The ways suitable for systemd on CentOS 7.0 or latest release.1. Create and configure Postgresql.service#

PostgreSQL Add UUID function

PostgreSQL has a built-in UUID type, but the default installation does not have a correlation function and needs to be generated manually.One, if it is a separate package installation method as shown belowPackage to my previous blog mentioned in the

PostgreSQL Installation and service management

Windows installation processDownload the binary installation package from here and follow the prompts step by step.Service ManagementThe name of the service can be used first to services.msc viewλ net start postgresql-x64-10postgresql-x64-10 -

PostgreSQL on azure.cn: Installation deployment

PostgreSQL is an object-relational database (database management system) based on the BSD license. Because of the flexibility of the license, anyone can use, modify, and distribute PostgreSQL for free for any purpose. Simply put, even if you take it

PostgreSQL copy prompt: Error:invalid byte sequence for encoding "UTF8": 0xb3

Three file formats are used for testing:ISO-8859NETPBM PBM ImageAsciiif[$ (File $filename |grep-c "ISO-8859")-GT 0]Then Echo "ISO-8859"Psql-C"copy $schemaname. $tbname from ' $dirname/$filename ' with (format ' csv ', delimiter ', Encoding ' iso-8859

4.2. PostgreSQL-Value expressions

4.2. Value expressionsValue expressions are used in a variety of syntax environments, such as in the target list of the SELECT command, as new column values in INSERT or UPDATE , or in search conditions for many commands. We sometimes call the

PowerDesigner Reverse Engineering PostgreSQL Database

1. Environment Preparation:A) Install PowerDesigner, take PowerDesigner15.1 as an exampleb) Install Java JDK, take jdk-7-windows-i586 as an examplec) Download the Postgressql JDBC driver jar package, taking Postgresql-8.1-415.jdbc2.jar as an

PostgreSQL User Guide

The CentOS series installation is divided into: Yum Installation SOURCE Installation One, yum installationFollow the official installation documentation. Install PostgreSQL official Yum repositoryYum Install

PostgreSQL off Auto-commit

1. Brief description we know that the Sqlplus inside Oracle executes DML statements; commit commits are required; if it is wrong, you can roll back the rollback; however, the default is auto-commit in PostgreSQL, and submit it immediately

PostgreSQL obtaining the Result Status

There is several ways to determine the effect of a command. The first method is for use the GETDiagnostics command, which has the form:GET [Current] diagnostics Variable {= |: =} Item [, ...];This command allows retrieval of system status indicators.

PostgreSQL stream replication (streaming replication)

Basic Environment Description:9.3 PostgreSQL version: 9.3. 6 Master: 192.168. 56.101 Standby: 192.168. 56.102Installation process slightly, based on pkg package1. Configure the Master side# psql-u pgsql-d postgres-c"CREATE USER Rep REPLICATION LOGIN

Postgresql:epoch the use of new era time

Epoch time is based on 1970-01-01 00:00:00 UTC as standard time and will target time with 1970-01-01 00:00:00The difference in time is calculated in seconds, in seconds, and can be negative values; Some applications store time in the Epoch time form

Load Balancing for PostgreSQL database servers

Operating System: Debian 3.0 r2 Kernel used: linux-2.4.23 The module used in the experiment: ipvsadm-1.21, PostgreSQL (detailed usage of ipvsadm command please refer to here) Function Description: This is a simple experiment on linuxvirtualserver.

Ing Data Types Between PostgreSQL and SQL Server

ArticleDirectory Preface Preface PostgreSQL 8.1 was launched. I plan to migrate some SQL server applications to PostgreSQL. The first thing I need to migrate is tables, therefore, we must first figure out the ing relationship between

Tutorial on installing and configuring PostgreSQL database instances in Debian

I used MySQL and wanted to try PostgreSQL. It is said that it is also very powerful. I searched the internet for related Chinese books. Unfortunately, there are far fewer books than MySQL, however, I found documents translated by volunteers on the

POSTGRESQL cannot create a database. The following error occurs: createdb: cocould not connect.

Run the following command to create a database named mydb The code is as follows:Copy code Createdb mydb The following error is returned: psql: FATAL: role "terry" does not exist. terry is the name of my machine and there is no role named terry

Total Pages: 77 1 .... 18 19 20 21 22 .... 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.