Previous article has shared the building springmvc:http://www.cnblogs.com/liqiu/p/4252788.htmlThis article to link database PostgreSQL1. Add several dependencies in Pom.xml Dependency> groupId>Org.postgresqlgroupId>
High availability, Load balancing, and Replication Feature Matrix
Feature
Shared Disk Failover
File System Replication
hot/warm Standby Using PITR
trigger-based Master-standby Replication
statement-based
Installation:Yum install Postgresql-serverservice PostgreSQL initdbchkconfig PostgreSQL onPostgreSQL by default, remote Access does not succeed, and if you need to allow remote access, you need to modify two configuration files, as described below:#
1. Use PgbouncerCan take advantage of Pgbouncer'sserver_idle_timeout参数Server_idle_timeout:if inch Time -Remove the previous comment to limit the automatic disconnection of the idle state beyond 60s. Of course, the connection mode set here is the
1. PostgreSQL 9.1 and below:SELECT pg_terminate_backend (pg_stat_activity.procpid) from pg_stat_activity WHERE = ' target_db ' and <> pg_backend_pid ();PostgreSQL 9.2 and above:SELECT pg_terminate_backend (pg_stat_activity.pid) from
KaLi Connecting the PostgreSQL databaseTo see if PostgreSQL is up and not started, start with the service PostgreSQL Start command. After starting to see if the boot was successful, the port is 5432:650) this.width=650; "src="
: Http://www.enterprisedb.com/products-services-training/pgdownload Select the appropriate version (QQ1033163112 download encounters a problem q me)The basic is the next step you can use to remember the password when you set the passwordConsole runs
the implementation of a read-only table in PostgreSQL can be divided into two parts: the existing tables in the database before the command operation, and the newly created tables of the database after the command operation. In this article, we will
1, ExplainExplain select * FROM TableName;2. Explain output JOSN formatExplain (format JSON) SELECT * FROM TableName;In addition to the JSON format, XML, text, Yaml, and more are supported3. Explain analyze view actual start-up timeExplain analyze
A password file contains the five fields we need to connect, so we can use file permissions to make the password more secure.Host:port:dbname:user:passwordsuch as Myhost:5432:postgres:sriggs:moresecureThe password file is set using an environment
Today, install the PostgreSQL database under centos6.5, and now tidy up your own procedures.I. Installation of postgresql9.4 under Centos6.51.1. Display all the relevant PostgreSQL installation packagesYum List postgres*1.2. Install the databaseYum
This article is reproduced from http://blog.chinaunix.net/uid-22920230-id-3493064.htmlCreate a databaseCREATE DATABASE Test with OWNER = postgres ENCODING = ' UTF8 ';Enter the console method to execute the command under the installation purpose bin
Practical environmentDatabase: PostgreSQL 9.4; operating system: Windows To create a database that contains an array typeNote that when setting the default value (you can of course not specify a default value), declare the type of the array,
Nulls First/last Function IntroductionThe Nulls first/last feature is primarily used in order by sort clauses, affecting the position of null values in the sort results. In simple terms, Nulls first means that the null value is always sorted before
For PostgreSQL, the Super User Postgres, which is created by default when the database is installed, is similar to the root user on Linux and has新建数据库用户:CREATE USER新建数据库:CREATE DATABASE删除数据库:DROP DATABASE删除用户:DROP USER撤销权限:REVOKE赋权:GRANTAnd so on
1. Create a database:1) Login Bin directory, createdb.exe-u Postgres-e mydb;-U indicates the login user name of this operation, if not write will take Windows login account, such as Administrator, will prompt no creation permission;2. Log in to the
----------------------------------------------installation-----------------------------------------------------The installation section mainly refer to this article:Http://www.cnblogs.com/shanyou/archive/2012/08/25/2656783.html1. Visit
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