Ian Barwick's Avatar

Ian Barwick

@ianbarwick

Biped, oxygen breather. Lives on seventh largest island in the world. Owner of two now largely useless snow shovels.

63
Followers
76
Following
53
Posts
05.01.2024
Joined
Posts Following

Latest posts by Ian Barwick @ianbarwick

Wonder if PostgreSQL will run on this?

24.02.2026 06:43 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

It is undeniably tall.

09.02.2026 13:31 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

BSR-Außenstelle in Prag?

10.12.2025 08:58 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Early three-monitor desktop setup, with 6 bit EBCDIC toggle switch input.

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

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

07.12.2025 11:32 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Video thumbnail

Prague by night.

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

07.12.2025 08:37 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

Europe here I come...

06.12.2025 02:51 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

26.11.2025 14:03 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
A listing of directories in the "postgres" user's directory, some dating back a decade or so.

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...

26.11.2025 13:56 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 1

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

27.09.2025 02:41 πŸ‘ 1 πŸ” 1 πŸ’¬ 1 πŸ“Œ 0

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

16.07.2025 13:56 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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".

16.07.2025 11:44 πŸ‘ 2 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0

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

16.07.2025 11:44 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

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

20.06.2025 01:53 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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.

20.06.2025 01:52 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

20.06.2025 01:50 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

(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).

19.06.2025 14:31 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

19.06.2025 13:55 πŸ‘ 7 πŸ” 3 πŸ’¬ 3 πŸ“Œ 0

Similarly, FTP rsync access is also no longer available.

29.05.2025 12:19 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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.

29.05.2025 09:18 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 1
Preview
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...

06.05.2025 00:03 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Post image

"Eisenbahn-Romantik".

12.04.2025 07:44 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

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...

04.04.2025 08:00 πŸ‘ 1 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0
Preview
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/...

30.03.2025 02:57 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
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...

24.03.2025 13:24 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Preview
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...

10.03.2025 13:24 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

So that's how wireless LAN packets are delivered.

10.03.2025 13:49 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

"We deleted the WAL."

28.02.2025 01:19 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

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

25.02.2025 05:21 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

18.02.2025 07:58 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Social Media Channels - PostgreSQL Europe

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

18.02.2025 02:03 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0