postgresql logical replication

Tags: PostgreSQL dual machine Hot spare stream replication 9.3.9System Environment: centos6.5Database version: postgres9.3.9Virtual Machine 2 units:master:10.0.2.160slave:10.0.2.69Data storage location:/usr/local/pgsql/data/ Installing the Pgsql Database安装过程可参考我上一篇博客：http://blog.51cto.com/13632960/2117902 两台机器都需要安装完成，我在做热备的时候，Master数据库开启，Slave关闭。 Create a Stream

Tags: PostgreSQL database backup CentOSToday, Pg_basebackup is used to build a master and Standby flow replication environment, the operation process is simple, can be operated online, quite convenient. Environment are CentOS6.6 + postgresql9.4, I use the installed library to do the test, the port is inconsistent, does not affect the environment to build, but pay attention to some related configuration: Mas

Running Environment: Primary: 192.168.111.150Standby: 192.168.111.15119425111.152os: CentOS5.8PostgreSQL: 9.1.2 or later. Streaming Replication is supported. PostgreSQL cache details Compiling PostgreSQL on Windows Configuration and installation of LAPP (Linux + Apache + PostgreSQL + PHP) Environment in Ubuntu Install

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

basically use any shell script to archive transaction logs. Here are some ideas: • Use some simple replication to transfer data to an NFS share • Run rsync to move files • Use custom scripts to validate the Xlog file and move it to an FTP server • Copy XLOG files to tape The choice of possible management Xlog is limited by imagination. Restore_command accurately corresponds to Archive_command. Its role is to get the data from the archive and provide

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:/

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

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

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.

Requirements for the character set (collation) on the destination database when implementing the logical replication software1. When the destination database is an Oracle database, it is important to ensure that the character set of the destination Oracle database is consistent with the character set of the source Oracle database.2. When the destination database is a MSSQLSERVER database, it is important to

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

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(

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