Researching something else about logical replication, I came across a commit message about row filtering on logical replication. From the date of the commit, I expect this will be included in PostgreSQL 15.
Adding a WHERE clause after the table name limits the rows that are included in the publication — you could publish employees in Vermont or only completed transactions.
I pulled some of the first batch of kombucha out to taste test this evening. I left 2 cups & split both that and the SCOBY between two half-gallon jars and now I’ve got a gallon of kombucha in progress.
One duck egg started pipping yesterday (really early!), but didn’t make it out of the egg. A second egg pipped this morning and we had a little duckling in the incubator by the afternoon.
Frequently, I’ll use password generator websites to create some pseudo-random string of characters for system accounts, database replication,etc. But sometimes the Internet isn’t readily available … and you can create a decent password right from the Linux command line using urandom.
If you want pretty much any “normal” character, use tr to pull out all of the other characters:
Or remove anything outside of upper case, lower case, and number characters using
Pass the output to head to grab however many characters you actually want. Voila — a quick password.
Quick SQL command to report the delta between the current and confirmed flushed LSN’s:
SELECT slot_name, confirmed_flush_lsn, pg_current_wal_lsn(), (pg_current_wal_lsn() - confirmed_flush_lsn) AS lsn_distance
ORDER BY slot_name;
Started with 19 chicken eggs in the incubator — two didn’t develop and were removed. Three eggs haven’t hatched (three of those have pipped, but haven’t really gotten anywhere since). One little guy is really weak and still in the incubator so the other little ones don’t sit and lay on him. That means we’ve got a thirteen little chickens in the brooder. And, early next week, the ducks should start hatching.
While using telnet to connect to a host:port is a quick way to verify connectivity … it only works for tcp ports. There’s no udp telnet. But there are a few ways to verify a port is open and available to you …
nmap with -sU will show the port as open or closed
nc will send a packet
Anya and I harvested a bunch of spruce tips today — we can make spruce tip syrup and spruce tip ice cream — and gathered a big handful of willow branches to make a root stimulating liquid (also, the kombucha is still doing well!)
We’ve got a bunch of new little ones hatching — Anya has four little ones in the brooder, and we have two more in the incubator.
I’m using IPv6 on a server — the server wasn’t using NetworkManagement, so I’ve configured it directly in the network script file.
After restarting the network (systemctl restart network), I was able to ping other IPv6 addressed equipment.