ungleich redmine

07/09/2023

PB 08:11 AM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

@postgres@pg2:~$ repmgr standby switchover --siblings-follow
NOTICE: executing switchover on node "pg2" (ID: 2)
NOTICE: attempting to pause repmgrd on 3 nodes
NOTICE: local node "pg2" (ID: 2) will be promoted to primary; current prima... Philipp (double-p) Buehler

07/08/2023

PB 06:09 PM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

@postgres@pg1:~$ repmgr cluster show
ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string
----+------+---------+-----------+----------+----------+----------+----------+-----------------------... Philipp (double-p) Buehler

PB 10:12 AM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

sidenote: pgLoader does not support IPv6 in the connection strings (pgpass). so data has to be copied via scp/rsync/.. and then loaded locally (unix socket) Philipp (double-p) Buehler

PB 06:23 AM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

code/pres in ze works
https://github.com/double-p/pgSQLv6-testing
Philipp (double-p) Buehler

07/07/2023

PB 04:14 PM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

Nico Schottelius wrote in #note-3:
> [...]
i think apt upgrade killed these three
Warning: Permanently added '2a0a:e5c0:2:12:0:f0ff:fea9:c3e4' (ED25519) to the list of known hosts.
Warning: Permanently added '2a0a:e5c0:2:12:0:f0ff:... Philipp (double-p) Buehler

PB 03:05 PM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

Debian 11/bullenauge Philipp (double-p) Buehler

PB 02:55 PM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

need; 4 VMs. each:
1 vCPU, 4 GB RAM, 10 GB Disk. All v6-only in one prefix preferably? Philipp (double-p) Buehler

PB 02:54 PM hack4glarus-2023-summer Task #11846: PostgreSQL data/conns handling on IPv6-only

key for provisioning `ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAINfdGn4eneqqp0AOXZqkQJzeLLy//FiGqYmWimuqIH6h pbuehler@adm042.local` Philipp (double-p) Buehler

PB 03:37 AM hack4glarus-2023-summer Task #11846 (Closed): PostgreSQL data/conns handling on IPv6-only

Demonstrate a multi-node setup with
- Streaming replication
- WAL replication (repmgr + barman)
- remote backup (barman)
- VIP failover (keepalived || ip6.sh || v6-magic)
- PGpoolII
- pgbouncer
... and restore things (no v6 spec... Philipp (double-p) Buehler

12/06/2020

PB 01:54 PM hack4glarus-2020-winter Task #8675: Jitsi - enable vb for livestream/recording

nginx: Philipp (double-p) Buehler