recentpopularlog in

tobym : postgresql   17

pq 1.5 : Python Package Index
A transactional queue system for PostgreSQL written in Python.
postgresql  python  queue  postgres 
september 2017 by tobym
pglogical | 2ndQuadrant
pglogical is the next generation replication system for PostgreSQL

pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.

- migrate and upgrade PostgreSQL with almost zero downtime
- accumulate changes from sharded database servers into a data warehouse
- scale out: copy all or a selection of database tables to other nodes in a cluster
- integrate: feed database changes in real-time to other systems
postgresql  database  replication 
april 2017 by tobym
Postgres-XL | 2ndQuadrant
Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5. It is different because it supports both Business Intelligence workloads and high-volume transactional write and read workloads all on the same platform. 

Postgres-XL is designed to be horizontally scalable and flexible enough to handle various workloads including:
- OLTP write-intensive workloads
- Business Intelligence requiring OLAP with MPP parallelism
- Operational data store
- Key-value store including JSON
- GIS Geospatial
- Mixed-workload environments
postgresql  distributed  database 
april 2017 by tobym
Postgres-BDR | 2ndQuadrant
Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status, developed by 2ndQuadrant and assisted by an active user community. BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2 to more than 48 nodes in a distributed database.
postgresql  distributed  database  ha 
april 2017 by tobym
joyent/manatee: Automated fault monitoring and leader-election system for strongly-consistent, highly-available writes to PostgreSQL (Joyent SDC, Manta).
Automated fault monitoring and leader-election system for strongly-consistent, highly-available writes to PostgreSQL (Joyent SDC, Manta).
postgresql  backup  cluster  replication 
february 2017 by tobym
Barman - Backup and Recovery Manager for PostgreSQL | 2ndQuadrant
Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organization to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.

Designed for disaster recovery, not high availability (for that, see repmgr)
postgresql  backup  devops  ops 
february 2017 by tobym
repmgr | 2ndQuadrant
repmgr is the most popular tool for PostgreSQL failover, introduced by 2ndQuadrant in 2010.  

repmgr helps DBAs and System Administrators manage a cluster of PostgreSQL databases. By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing databases with high availability and scalability requirements.

repmgr simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster by:

Monitoring the replication process
Allowing DBAs to issue high availability operations such as switch-overs and fail-overs.
postgresql  backup  replication 
february 2017 by tobym
Pacemaker is an Open Source, High Availability resource manager suitable for both small and large clusters.
postgresql  ha  cluster  failover 
october 2012 by tobym
Home · t-matsuo/resource-agents Wiki
support for postgres streaming replication
postgresql  streaming 
october 2012 by tobym

Copy this bookmark:

to read