Search: [postgresql]

Why does Neon use Paxos instead of Raft, and what's the difference? — Neon

high · availability · distributed · paxos · systems · postgresql · neon · consensus

August 16, 2022 at 3:06:28 PM GMT+2 · permalink

·

https://neon.tech/blog/paxos/

A practical way to upgrade Postgres major versions with near-zero downtime | Listen Notes

postgresql · upgrade · sysadmin · database · psql

August 16, 2022 at 12:31:24 PM GMT+2 · permalink

·

https://www.listennotes.com/blog/a-practical-way-to-upgrade-postgres-major-49/

GitHub - warp-tech/warpgate: Smart SSH and HTTPS bastion that works with any SSH client

warpgate · bastion · host · ssh · server · mysql · https · postgresql

July 6, 2022 at 5:56:23 PM GMT+2 * · permalink

·

https://github.com/warp-tech/warpgate

GitHub - datafold/data-diff: Efficiently diff rows across two different databases.

data-diff · diff · databases · sysadmin · programming · postgresql · mysql

June 23, 2022 at 2:21:41 PM GMT+2 * · permalink

·

https://github.com/datafold/data-diff

Changing Tires at 100mph: A Guide to Zero Downtime Migrations | Kiran Rao

postgresql · table · migration

June 13, 2022 at 3:55:05 PM GMT+2 · permalink

·

https://kiranrao.ca/2022/05/04/zero-downtime-migrations.html

Trusted Open Source PostgreSQL & Commercial Support for the Enterprise | Crunchy Data

postgres · crunchydata · postgresql · managed · solutions

May 24, 2022 at 3:56:38 PM GMT+2 · permalink

·

https://www.crunchydata.com/

GitHub - Qovery/Replibyte: Seed your development database with real data ⚡️

replibyte · postgresql · mysql · mongodb · fake · data

May 9, 2022 at 3:44:15 PM GMT+2 · permalink

·

https://github.com/Qovery/replibyte

Welcome to AIOPG — Welcome to AIOPG

asyncio · aiopg · postgresql · python

April 29, 2022 at 4:10:04 PM GMT+2 · permalink

·

https://aiopg.readthedocs.io/en/stable/

8 Fascinating Things You Probably Didn't Know PostgreSQL Can Do!

postgres · postgresql · features · cool

April 24, 2022 at 6:10:25 PM GMT+2 · permalink

·

https://www.enterprisedb.com/blog/8-cool-interesting-facts-things-postgresql-can-do

Payal Singh: Provisioning and Automating High Availability Postgres on AWS EC2 - PGCon 2017 - YouTube

postgresql · ansible · high · availability · aws · ec2

April 23, 2022 at 5:23:33 PM GMT+2 * · permalink

·

https://www.youtube.com/watch?v=KHPo9G6NCq4

PostgreSQL + ZFS Best Practices.key - scale15x-2017-postgresql_zfs_best_practices.pdf

zfs · postgresql · postgres · presentation

April 20, 2022 at 7:39:46 PM GMT+2 · permalink

·

https://people.freebsd.org/~seanc/postgresql/scale15x-2017-postgresql_zfs_best_practices.pdf

Our Experience with PostgreSQL on ZFS

postgresql · zfs

April 20, 2022 at 7:37:42 PM GMT+2 · permalink

·

https://lackofimagination.org/2022/04/our-experience-with-postgresql-on-zfs/

How we upgraded our 4 TB main application Postgres database

postgresql · upgrade · replication · warp · citus · retool

April 16, 2022 at 11:18:05 AM GMT+2 * · permalink

·

https://retool.com/blog/how-we-upgraded-postgresql-database/

High availability and disaster recovery (HA/DR) for Postgres databases : Postgres Professional

high · availability · disaster · recovery · postgresql · postgres

April 15, 2022 at 6:14:40 PM GMT+2 · permalink

·

https://postgrespro.com/blog/pgsql/5968057

Locks in PostgreSQL: 4. Locks in memory : Postgres Professional

postgres · postgresql · locks · memory

April 15, 2022 at 6:10:47 PM GMT+2 · permalink

·

https://postgrespro.com/blog/pgsql/5968022

Is my autovacuum configured properly? – select * from depesz;

postgresql · postgres · vacuum · configuration

March 29, 2022 at 3:31:28 PM GMT+2 · permalink

·

https://www.depesz.com/2022/03/13/is-my-autovacuum-configured-properly/

GitHub - sorintlab/stolon: PostgreSQL cloud native High Availability and more.

stolon · postgresql · cloud · native · high · availability

March 29, 2022 at 11:45:39 AM GMT+2 · permalink

·

https://github.com/sorintlab/stolon

Amazon Aurora: Design Considerations + On Avoiding Distributed Consensus for I/Os, Commits, and Membership Changes

amazon · aurora · database · mysql · postgresql · design · consensus

March 28, 2022 at 11:21:26 AM GMT+2 · permalink

·

http://muratbuffalo.blogspot.com/2022/03/amazon-aurora-design-considerations-and.html

Hooks: The secret feature powering the Postgres ecosystem

postgresql · postgres · hooks · supabase · timescaledb

March 25, 2022 at 8:13:47 PM GMT+1 · permalink

·

https://arctype.com/blog/postgresql-hooks/

GitHub - healthchecks/healthchecks: A cron monitoring tool written in Python & Django

cron · cronjob · monitor · monitoring · healthchecks · python · postgresql · mysql

March 17, 2022 at 3:38:54 PM GMT+1 · permalink

·

https://github.com/healthchecks/healthchecks