postgreSQL备份从数据形态上分为逻辑备份和物理备份。 PostgreSQL 9的流复制是基于WAL日志的物理复制,其原理是主库不间断地发送WAL日志流到备库,备库接收主库发送的WAL日志流后回放WAL; PostgreSQL10版本中增加了一个新特性,即逻辑复制(Logical Replication)。逻辑复制是基于逻辑解析(Logical Decoding),其核心原理是主库...
PostgreSQL Purview Quantum Quota Recoveryservicesdatareplication Redis Resource Graph Resource Health Resources Schema Registry Scvmm Search Security Security DevOps Security Insights Self Help Service Bus Service Fabric Service Map Service Networking SignalR Sphere Springappdiscovery SQL SQL Virtual Machine Stor...
AWS : MySQL Replication : Master-slave AWS : MySQL backup & restore AWS RDS : Cross-Region Read Replicas for MySQL and Snapshots for PostgreSQL AWS : Restoring Postgres on EC2 instance from S3 backup AWS : Q & A AWS : Security AWS : Security groups vs. network ACLs AWS : Sc...
pg_ctl - initialize, start, stop, or control a PostgreSQL server SYNOPSIS pg_ctl init[db] [-D datadir] [-s] [-o initdb-options] pg_ctl start [-D datadir] [-l filename] [-W] [-t seconds] [-s] [-o options] [-p path] [-c] pg_ctl stop [-D datadir] [-m s[mart]...
postgreSQL备份从数据形态上分为逻辑备份和物理备份。 PostgreSQL 9的流复制是基于WAL日志的物理复制,其原理是主库不间断地发送WAL日志流到备库,备库接收主库发送的WAL日志流后回放WAL; PostgreSQL10版本中增加了一个新特性,即逻辑复制(Logical Replication)。逻辑复制是基于逻辑解析(Logical Decoding),其核心原理是主...