Ian Barwick

It is undeniably tall.

BSR-Außenstelle in Prag?

Early three-monitor desktop setup, with 6 bit EBCDIC toggle switch input.

Early three-monitor desktop setup, with 6 bit EBCDIC toggle switch input.

Prague by night.

(Excuse the fingers, it was 7am in the morning body time after 15 hours of flights.)

Europe here I come...

Maybe I should keep some of the log files for old times' sake

A listing of directories in the "postgres" user's directory, some dating back a decade or so.

I think I could probably get rid of some of these directories...

"Challenge accepted".
www.linkedin.com/help/linkedi...

Funnily enough earlier today I wrote "pg_dump ... -v" in a ticket, then went back and revised it to "pg_dump ... --verbose" for clarity.

Let's hope they allow abbreviations to speed things up, so rather than say:

"make directory foo and copy file.jpg to foo and convert file.jpg to file.png".

lazy people could type:

"mkdir foo && cp file.jpg foo/ && convert file.jpg file.png".

Hmm, this "typing out file management tasks" thing sounds like a nifty new innovation. Surprised it's never been tried before.

There was actually a CTE involved, as well as a lateral join.

Had to cheat a little and add a column and a trigger to keep it updated to keep the query practical, as the data structure wasn't quite suited for extracting what I wanted, but it saves updating the application and it's my own personal playground.

Quite, it was the visualizing of how the data would need to be queried which is the interesting part. Syntax is just typing.

(I mean this in a serious way, as most of my working days seem to be taken up with scripting DDL in the hope of triggering obscure corner-case bugs).

Damn, I had almost forgotten how much fun it is writing actual SQL queries...

Similarly, FTP rsync access is also no longer available.

In case anyone's wondering what's up with the PostgreSQL Git repository and "fatal: Could not read from remote repository" messages in the past couple of days, apparently the git:// protocol support has been deactivated (and might be withdrawn entirely), so you'll likely need to switch to https.

PgPedia Week, 2025-05-04 PostgreSQL happenings for the week 2025-04-28 ~ 2025-05-04

PgPedia Week, 2025-05-04:
pgpedia.info/blog/pgpedia...

"Eisenbahn-Romantik".

LinkedIn users not keen on it harvesting their data and content for the hallucination machine might want to disable the below setting...
www.linkedin.com/mypreference...

Samsung’s latest stick vac can alert you to calls and text messages Can I call you back after the rinse cycle?

This sucks.
www.theverge.com/news/639078/...

PgPedia Week, 2025-03-23 PostgreSQL happenings for the week 2025-03-17 ~ 2025-03-23

PgPedia Week, 2025-03-25:
pgpedia.info/blog/pgpedia...

PgPedia Week, 2025-03-09 PostgreSQL happenings for the week 2025-03-03 ~ 2025-03-09

PgPedia Week, 2025-03-09
pgpedia.info/blog/pgpedia...

So that's how wireless LAN packets are delivered.

"We deleted the WAL."

Never even occurred to me to check if "which" takes any options.

I think I had that one, or one very like it.

Good to see more PostgreSQL channels moving away from the social media site formerly known as Twitter.
www.postgresql.eu/news/social-...

PgPedia Week, 2025-02-02 PostgreSQL happenings for the week 2025-01-27 ~ 2025-02-02

PgPedia Week, 2025-02-02:
pgpedia.info/blog/pgpedia...