postgresql replication

the forwarding function on a custom function. This requires a large number of business logic to be put on the PostgreSQL server side to complete, reducing the flexibility of the application. It also poses a challenge for possible future database migrations.Reference:Http://www.postgresql.org/docs/9.3/static/different-replication-solutions.htmlHttp://www.postgresql.org/docs/9.3/static/hot-standby.htmlHttp:/

Hot_standby is that archive does not need to know the currently running transaction. This information is critical in the case of convective replication. [Restart can be done by directly using pg_ctl–d/data_directory–m fast restart or through a standard init script.] ] The easiest way to check our archive work is to create some useless data in the database. The following code snippet shows a way to easily produce 1 million rows of data: test=# CREATE

directory of With-pgconfigdir parameters;In addition Slony-i a set of Perl script tools, named Altperl scripts, can simplify the configuration of Slony-i, the default compilation will not take the script, need to compile, with--with perltools to compile;After compiling the kick, the Slony-i installation is completed, and the general Slony-i is installed in the directory where the PostgreSQL database resides.Which PostgresWhich SlonWhich SlonikThe ins

the master if there are incorrect data replication 2.4boot the main library to view the configuration results Postgres=#select * from Pg_stat_replication;-[RECORD1]----+------------------------------PID|1793Usesysid|24576Usename|replica Application_name|Walreceiver client_addr|192.168.1.203Client_hostname|Client_port|32250Backend_start| .- the- on A: at:16.924496+ ,Backend_xmin|1676 State|Streaming Sent_location|0/60003E0write_location|0/60003E0flu

Label:Primary database: 172.16.254.21 port: 5432From database: 172.16.254.22 port: 5432 Step 1: Master-Slave installation SlonApt-get Install Slon-binStep 2: Configure permissions for the master-slave database to create the language.Vi/etc/postgresql/8.3/node/pg_hba.conf in the primary databaseAdd a record host all REPL 172.16.254.22/32 MD5 Perform the following operations on the master and slave databases:Shell>psqlnode= #create role repl password '

| sync_priority | sync_state -----+----------+---------+------------------+-------------+ -----------------+-------------+---------------+--------------+-------+---------------+----------------+----------------+--------- --------+---------------+------------ (0 rows) postgres=# CREATE TABLE Test6 (ID bigint); Master cannot be updated, it waits until one node in Synchronous_standby_names connects to the master node, but can be canceled by CTRL + C, which commits locally ^ccancel Request sent wa

default maximum number of connections for PG is MAX_CONNECTION=100, which is suspected to be an error in the number of database connections. The fact is that the old database max_connection=200, and does not use the default 100. Workaround: Modify the default maximum number of connections in the configuration file (postgresql.conf) max_connection=200, and restart the database. Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Label: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, and parallel queries. Document here. Four types of modes O means "available" and X means "not available(

Streaming replication Slots is a pending feature in PostgreSQL 9.4, as part of the logical changeset extraction feature.What is they for, what does need to know, what changes?What is replication slots?Streaming replication slots is a new facility introduced in PostgreSQL 9.4

6.3 Checking the operating system processOnce we have checked the archive and our system view, we are ready to check the system process. Checking the system process may look a bit rough, but it proves to be very effective.On master, we can simply check a process called Wal_sender. On slave we want to check for a process called wal_receiver.Let's first examine what we should see on master:9314?? Ss 0:00.00 Postgres:wal Sender ProcessHS:: 1 (61498) idleOn Linux we can see that the process not only

1. Installing the Postgres database on the standby server does not require initialization.installation process See: http://www.cnblogs.com/ilifeilong/p/6979288.html2. Create a replication user with replication permissions on the primary serverPostgres=CREATEwithREPLICATION'repl' LOGIN;3. Allow replication users to connect remotely to the primary servergrep " ^hos

Label:6.4 Processing Monitoring ToolsThere are also several monitoring tools to make your daily life easier. One of the most popular monitoring tools is Nagios. It is widely used and also supports a variety of software components. To use Nagios to monitor your PostgreSQL cluster, you need to install a plugin that runs replication-related tests. This plugin for PostgreSQ