Install PostgreSQL on Linux

To tell the truth, my LAMP site, in fact, can not forget this elephant. MySQL is a brisk dolphin, but lacks many of the characteristics of modern relational databases, such as referential integrity, views, triggers, and so on. So if you need to

A little trick to improve PostgreSQL performance _ database Other

In a (bad) PostgreSQL query, just a little to change (any (array[...)) to any (VALUES (...)) will be able to reduce the query time from 20s to 0.2s. From the simplest learning to use EXPLAIN analyze, to learn to use the Postgres community a lot of

Instagram five tips for improving PostgreSQL performance _ database Other

With the growing scale of Instagram, Postgres continues to act as a solid foundation for Instagram and stores most of its user data. Less than a year ago, we said on our blog that Instagram "stores a lot of data", adding 90 more data per second, and

PostgreSQL Database installation Configuration instance in Debian _postgresql

Accustomed to MySQL, want to try to use the next PostgreSQL, it is said that this thing is also very strong, I searched the Internet related Chinese books, but the related books are far less than MySQL, but I found in the official translation by the

Use Python to import an MDB database file into the PostgreSQL database sample _python

The MDB format file can export each of the tables contained in the Mdbtools tool to a CSV format file. Because of the PostgreSQL of the Access database and the format of the database, use Python's file processing to modify the resulting CSV file to

Confluence 6 PostgreSQL creating databases and database users

Once you have successfully installed the PostgreSQL database: Create a database user, for example confluenceuser . Your new user must be able to create database objects (Create DB objects) and must have permission to log on ( can login)

PostgreSQL Master-Slave configuration

First, IntroductionPostgreSQL introduces a master-slave stream replication mechanism after 9.0, so-called stream replication is the synchronization of the corresponding data from the server through the TCP stream from the primary server. This will

Setting up client connections PostgreSQL does not require a password

In normal work, sometimes need remote connection PostgreSQL database to do some maintenance, such as remote backup, etc. if the backup script is written in the remote machine, the backup will pop up the password input prompt, then the script can not

PostgreSQL-based API Design

PostgreSQL-based API Design本文档设计思想主要是用于简化API一些重复验证工作,同时固定API入口, 在入口中做请求分发, 以便在入口做一些统计工作以及请求次数限制.-- functionapi_interface(in jsonb, out jsonb); --入口函数(存储过程)api_interface_error(code); -- 统一错误处理函数api_interface_lines(user_id, params, team_id);

"PostgreSQL-9.6.3" Use the Pg_settings table to see the parameters ' effective conditions

The configuration parameters for the PostgreSQL database are in the postgresql.conf file, which is the database's data directory ($PGDATA). Some of these parameters are directly modified to take effect, some need to restart the database to take

PostgreSQL Stress test Tool usage and parameter interpretation

Pgbench is a database stress test tool that comes with PostgreSQL, supports the Tpc-b test model, or customizes the test model. Custom test models support meta-commands, invoke shell scripts, set random numbers, variables, and so on. 3 asynchronous

Ubuntu 14.04 Install PostgreSQL latest version

Official website: https://www.postgresql.org/download/linux/ubuntu/--------------------------------------------------------------------------------------------------------------- -----Another article, which is about the

PostgreSQL stream replication +pgpool for high availability

Pgpool Overview The Pgpool-ii is a middleware located between the PostgreSQL server and the PostgreSQL database client, which provides the following features: Connection pooling, replication, load balancing, limiting over-limit connections,

How to debug PostgreSQL function with PGADMINIII

How to debug Plpgsql with PGADMINIII[[email protected] soft_bak]# git clone git://git.postgresql.org/git/pldebugger.gitInitialized Empty Git repository in/opt/soft_bak/pldebugger/.git/Remote:counting objects:445, done.Remote:compressing objects:100%

postgresql-Installation 9.2

First, the environmentVM Virtual MachinesName="Ubuntu"VERSION="12.04.4 LTS, precise pangolin" Second, the process1. Install make and do not load now.Install Make Make--3.81 2006 for for I686-pc-linux-gnu2. Get the source codeBut now there is

The first chapter of PostgreSQL Replication Understanding Replication Concepts (3)

1.3 Using sharding and data distributionIn this section you will learn about basic extensibility techniques, such as database sharding. Sharding is widely used in high-end systems and provides a simple and reliable way to scale out. In recent years,

Metastore docking PostgreSQL for Spark SQL

This tutorial records the Spark 1.3.1 version of Thriftserver Metastore docking PostgreSQLPostgreSQL compilation, reference: Http://www.cnblogs.com/chenfool/p/4530925.htmlOne-start PostgreSQL service1 First, you need to load PostgreSQL lib into the

Postgresql+slony-i installation Configuration Master-Slave

Postgresql+slony-i installation Configuration Master-SlaveSlon Software:slony1-1.2.6http://slony.info/downloads/1.2/source/PostgreSQLhttp://www.postgresql.org/download/http://www.postgresql.org/ftp/source/v8.1.23/First, PostgreSQL installationMethod

Postgresql+slony-i installation Configuration Master-Slave

Slon Software:slony1-1.2.6http://slony.info/downloads/1.2/source/PostgreSQLhttp://www.postgresql.org/download/http://www.postgresql.org/ftp/source/v8.1.23/First, PostgreSQL installationMethod 1.rpm Package Installation Postfresql:Required

Install PostgreSQL under Linux and configure remote graphics desktop Connection

Recently there have been projects that have been used in PostgreSQL and have not been contacted before, so there are some problems with the installation and are now recorded.1. Download postgresql9.4, I use the version is downloaded from the

Total Pages: 77 1 .... 13 14 15 16 17 .... 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.