postgresql multi master

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:

Postgres Primary and Standby switchingThe Master is looking forMethodPs-ef | grep wal (Main library sender)Postgres 27873 27864 0 May 06? 00:00:10 Postgres:wal Sender Process Postgres 10.2.0.13 (47582) streaming 0/906ff78Postgres 27874 27864 0 May 06? 00:00:11 Postgres:wal Sender Process Postgres 10.2.0.15 (51872) streaming 0/906ff78Ps-ef | grep wal (Standby receiver)Postgres 25875 25828 0 May 06? 00:05:28 Postgres:wal receiver Process streaming 0/906

| Postgres | UTF8 | en_US. UTF-8 | en_US. UTF-8 | =c/postgres +| | | | | Postgres=ctc/postgresTest | Postgres | UTF8 | en_US. UTF-8 | en_US. UTF-8 |(4 rows)9. Create a database, access users, and empower the databasePrimary serverpostgres=# Create user Pgone with password ' password321 ';CREATE ROLEpostgres=# CREATE DATABASE pgdata owner Pgone;CREATE DATABASEpostgres=# Grant all privileges on the database pgdata to Pgone;GRANTReference:Https://www.cnblogs.com/sunshine-long/p/90596

Install Mysql multi-instance in Linux as the data backup server to implement multi-master to one backup bitsCN. com1 from multiple instances. download the MYSQL source code version from the MYSQL official website [must be the source code version] 2. press the following code to type the LINUX command line [Note] adding mysql groups and users # Groupadd mysql # U

Label:1. Size difference Executing on the main library Select application_name, pg_size_pretty (Pg_xlog_location_diff (Pg_current_xlog_location (), replay_l ocation) as diff from pg_stat_replication; Or: Select Application_name, client_addr, cur_xlog| | '/' | | cur_offsetascur_xlog, sent_xlog| | '/' | | sent_offsetassent_xlog, Replay_ xlog| | '/' | | replay_offsetasreplay_xlog, Pg_size_pretty ( ((cur_xlog*255*16 ^6) +cur_offset) - ((sent_xlog*255*16^6) +sent_offset) ):: Numeric) asmaster_la

activate the same state as the Sing Woo Master, and a remote_apply level of replication is required. The above is PostgreSQL 9.6 enhancements in streaming replication. Synchronous multi-Copy configuration method The parameters are configured as follows Synchronous_standby_names (String) Support two ways of writing Num_sync (Standby_name [, ...]) Standby_n

It took three days for me to get started with LINUX for the first time. I hope it will bring convenience to everyone. It took three days for me to get started with LINUX for the first time. I hope it will bring convenience to everyone. 1. Download the MYSQL source code version from the MYSQL official website [must be the source code version] 2. Press the following code to type the LINUX Command Line The Code is as follows: [Note] adding mysql groups and users # Groupadd mysql # Useradd-g mysql

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 Packages:postgresql92-9.2.10-1pgdg.rhel5.i386.rpmpostgresql92-server-9.2.10-1pgdg.rhel5.i386.rpmpostgresql92-contrib-9.2.10-1pgdg.rhel5.i386.rpmpostgresql92-devel-9.2.10-1pgdg.rhel5.i386.rpmpostgresql92-libs-9.2.10-1