Menampilkan postingan dari Desember, 2020

clean up swap centos in single command row

run this magic command swapoff -a; sudo swapon -a Be careful doing this, as you may make your system unstable, especially if its already low on RAM.

Hot to drop replication slots PostgreSQL

1. login to database postgresql command line 2. check replication_slot name using this command      SELECT * from pg_replication_slots; 3. drop replication slot using this command       SELECT pg_drop_replication_slot('replication_slot_name ')…

Create replication slots

/equnix/apps/pgsql-9.6/bin/pg_recvlogical -U user -d zabbix4 -p port --slot name_replicationslot --create-slot -P wal2json -h 127.0.0.1

Muat postingan lainnya
Tak ada hasil yang ditemukan