PostgreSQL

PostgreSQL allows remote access to configuration modificationsPostgreSQL 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.postgresql.confSet the

PG System Query Script--query user process and text select A.pid as Id, a.usename as user, a.client_addr as Host, a.client_port as Port, datname as DB, Qu Ery as Command, a.state as Idle, L.mode as state, Query_start as time, case when C.relname was

PSYCOPG is a PostgreSQL database interface for the Python language . Its main advantage is full support for Python DB API 2.0, as well as secure multithreaded support. It is suitable for multi-threaded database applications that create, destroy

--Query blocked SQL (deadlock, no SQL executed through) SELECT * from Pg_stat_activity AA, (select A.locktype,a.database,a.pid,a.mode,a.relation,  B.relname from Pg_locks a joins Pg_class B on A.relation=b.oid where upper (b.relname) = '

Register Start Pg_install.bat:echo offset pgsql_dir=%~dp0if not "%pgsql_home%" = "" "(If not"%pgsql_home% "= ="%pgsql_dir% "(Echo pgsql_home=%p Gsql_home%! = pgsql_dir=%pgsql_dir% goto pg_ends)) Else (set pgsql_home=%pgsql_dir% echo Pgsql_home must

http://www.postgresql.org/about/news/1557/December 18, 2014, the PostgreSQL Global Development group released Postgresql9.4,postgresql is the world's leading open source database. For different types of database users, this version adds many new

First update the Source:sudo apt-get updateIf you do not know the name of PostgreSQL specific package, you can use the statement to find:Apt-cache Search ^postgresqlUsing the search above, you can find the currently installable version of PostgreSQL

PostgreSQL built-in UUID type, performance is good, but PostgreSQL by default does not install UUID related operation function, need to manually import. Import UUID-related functions. psql-d dbname-u dbuser-f

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

[Email protected] tmp]# VI 2.sh#!/bin/bashbackup= "/home/bak"#RSYCN = "/usr/bin/rsync"#OPTIONS = "-rlhpogdts--delete"Date= ' Date +%y%m%d 'Log_file= "/var/log/backup/backupdb_$date.log"Server= "192.168.2.31"#1. PostgreSQLpg_dump=

4.2 Configuring cascading replicationAs you've seen in this chapter, it's really easy to set up stream replication. Just set up a few parameters, make a basic backup, and enjoy your replication settings.In many cases, this situation is a little bit

PostgreSQL two types of transaction isolation levels:Read Committed: The default isolation level in PostgreSQL. When a transaction runs at this isolation level, a select query can see only the data that was committed before the query was started and

Q:I have been trying to make we database clients pro-active about not filling up the partition on which the database they a Re using resides.As all of our clients is on the same host as the database manager, it should is easy enough for user-created

The "Timeline" (Timeline) is a very distinctive concept for PG, which appears in the documentation of backup recovery. But the detailed explanations for this concept are very few and not very well understood, so let's take a closer look at

1. TriggerRecord a log when an update is in actionDROP FUNCTION IFEXIST log_test (); CREATE OR REPLACE FUNCTIONLog_test ()RETURNS Trigger as $$ DECLARE BEGINRAISE NOTICE'TRIGGER LOG TEST'; RETURN NULL; END; $$ LANGUAGE Plpgsql; CREATE

EnvironmentPsql (9.3.6) Enter "Help" for information. root=# \d change_me table "Public.change_me" field | Type | Modifier words-----------+-----------------------+--------Too_short | Character varying (50) | root=# alter TABLE Change_me alter

First, the environmentubuntu14.04postgresql-9.4.3Second, installation1. Dependent Package Installationsudo Install libperl-dev python-dev libreadline-gplv2-dev Zlib1g-dev2. Download PostgreSQL, compile and installWGer https://ftp.postgresql.org/pub/

Mode 1 Common Insertion methodTimestamp currentTime= new Timestamp(System.currentTimeMillis()); String sql = "INSERT INTO message(date_create) VALUES (" + "‘" + currentTime + "‘" + ");";Mode 2 using PlaceholdersTimestamp currentTime= new

Preface:There are two ways to upgrade PostgreSQL by using Pg_dumpall Backup and importing to a new version.The other is that this article uses the Pg_upgrade method upgrade to copy the old database files from the file level to the new

COPY at PostgreSQL Exchange data between a table and a standard file system file. COPYTO Copy all the contents of a table to a file, and COPYFROM copy data from a file into a table (append the data to the existing content in the tables).