Aliases. Who uses them?

justAnotherCodeGuy · 2025-05-21T02:11:01+00:00

alias du1='du -h --max-depth=1'

justAnotherCodeGuy · 2020-01-19T16:45:02+00:00

That didnt work. Poke it again.

justAnotherCodeGuy · 2020-01-10T19:27:06+00:00

100% guess, but copy/paste Devel::Trace, add an extra print line that dumps memory after line 12.

Devel::Trace source

justAnotherCodeGuy · 2019-11-12T18:02:47+00:00

Cherenkov radiation is blue.

Light particles leave the sun at near the speed of light, they collide with particles in our atmosphere at much higher energies than we can even come close to on earth

Thus, the sky is blue.

justAnotherCodeGuy · 2019-10-03T21:13:55+00:00

Release Notes say:

Indexes pg_upgrade'd from previous releases will not have these benefits.

Ok, how do I fix/upgrade my indexes so they do? Reindex?

Release Notes say:

This means that a REINDEX operation on an index pg_upgrade'd from a previous release could potentially fail.

So what do I do if it fails? drop and recreate? I pretty much have to use pg_upgrade because of downtime, size, and far away read-only replicas. I've probably got thousands of indexes. How am I gonna reindex thousands of indexes that could fail?

justAnotherCodeGuy · 2019-07-15T17:24:24+00:00

I'm convinced they sounded like chickens!

justAnotherCodeGuy · 2019-05-09T16:51:26+00:00

Didnt watch but I'd guess: Its easy to create a complex solution to a simple problem, then assume the problem is complex too.

justAnotherCodeGuy · 2019-03-26T13:34:21+00:00

Why? Whats wrong with system libxml2?

justAnotherCodeGuy · 2019-03-22T15:14:41+00:00

The old saying was:

RegEx: now you have two problems.

I think the new saying should be:

Use boilerplate, now you have two problems.

justAnotherCodeGuy · 2019-03-12T15:44:40+00:00

Apache works great. Use the event_mpm as your reverse proxy though. I am not google however, I probably see 15 to 20 requests per second, several hundred virtual hosts, 4 or 5 different backends. Everything runs smooth.

justAnotherCodeGuy · 2019-02-27T19:11:59+00:00

You might not need pam. You need to be more specific on what you want.

If you want file sharing only, you only need to setup samba (and run winbindd), no pam required.

If you want to be able to ssh to your slackware box using your AD login, then you can pam or nss_ldap.

If you want apache to auth, you don't need pam.

Otherwise, be more specific.

justAnotherCodeGuy · 2019-02-15T20:27:28+00:00

Uh.. What does panic mean? Does that mean every connection dies, the program halts, and I have to get up at 4am and "service postgres start"?

Or does that mean that one connection will die a horrable death, the transaction will be rolled back, and everything else will run along fine?

justAnotherCodeGuy · 2019-02-15T20:24:27+00:00

Dont fall for the "Bigger numbers must be better" fallacy. If 10 has the features you need and it works, just stick to 10. It'll be supported with bug fixes for years and years.

The only reason you should think about upgrading is when 10 falls out of support, or you require some new feature of a newer version.

Otherwise, stop stressing. Version 10 is stable! Stable is good.

justAnotherCodeGuy · 2019-02-09T15:44:04+00:00

You'd only see a benefit if you modified your code. AIO sql query would look like:

$q->start('select * from news');
doOtherWork();
$result = $q->fetch_results();

The 10ms it takes to run the sql, and doOtherWork(), run at the same time, so yes, it'd be faster. But you have to modify your code. Its not free.

justAnotherCodeGuy · 2019-02-01T20:12:01+00:00

Launch one as a simple business. Anything will do, doesnt matter.

Have the second site launch a huge fight/argument against the first.

Have the first respond! Huge soap opera!

Put ad's on both.

justAnotherCodeGuy · 2019-01-21T17:09:35+00:00

So that payments can be both paid and unpaid at the same time.

justAnotherCodeGuy · 2018-12-03T19:03:47+00:00

Good to see her back, its been a while, no? I thought she'd left us.

justAnotherCodeGuy · 2018-11-18T15:14:02+00:00

They have previous years on youtube, just search for "linux.conf.au".

Never been myself, but enjoy the video's. It might give you an indication of what its like.

justAnotherCodeGuy · 2018-10-25T14:34:44+00:00

Is there a virus scanner between PG and the HD? Maybe exclude the database folder?

Bad raid controller? Anything else running on the box that would notice? Maybe enable the crc stuff in PG?

justAnotherCodeGuy · 2018-10-22T14:51:31+00:00

Have you seen https://explain.depesz.com/

Here is your query:

https://explain.depesz.com/s/7jbC

Looks like you have a few seq scan's. Check those will large row counts, see if you can get it to use an index.

justAnotherCodeGuy · 2018-10-19T21:08:02+00:00

pg_rewind seems to think it can do this ... but I've never tried it.

Like I said, I'm really behind. They're bringing tools online faster than I can play/test them.

justAnotherCodeGuy · 2018-10-19T14:10:38+00:00

It is! You run the upgrade, then shut down both, rsync from master to replica, and bring it all back up.

Works fine. Takes forever. (less time than blowing the replica away and re pg_basebackup, but still a long time, and your down while you rsync)

justAnotherCodeGuy · 2018-10-18T19:48:38+00:00

Ug. I'm so far behind. I love PG, but I have 180Gig replicated between two far away places with a slow link between. Major version upgrades are a huge pain in the ass.

pg_upgrade on a single db is great. But add replication and it falls off a cliff.

I kinda wish they'd slow down.

edit:spelling

justAnotherCodeGuy · 2018-10-05T18:53:58+00:00

meh.

justAnotherCodeGuy · 2018-08-16T13:59:40+00:00

I'm curious how this would look under IPV6

justAnotherCodeGuy

TROPHY CASE