ungleich redmine

07/09/2023

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)
NOT... Philipp (double-p) Buehler

07/08/2023

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 | ... Philipp (double-p) Buehler

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/.... Philipp (double-p) Buehler

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

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 '2a... Philipp (double-p) Buehler

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

Debian 11/bullenauge Philipp (double-p) Buehler

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

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

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

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 (b... Philipp (double-p) Buehler