LinuxQuestions.org - Musings on technology, philosophy, and life in the corporate world

Hi. I'm jon.404, a Unix/Linux/Database/Openstack/Kubernetes Administrator, AWS/GCP/Azure Engineer, mathematics enthusiast, and amateur philosopher. This is where I rant about that which upsets me, laugh about that which amuses me, and jabber about that which holds my interest most: *nix.

This database has been brought to you by the number -17

Posted 02-12-2010 at 11:01 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 02-12-2010 at 11:55 AM by rocket357

In this blogpost, I shared two scripts: one was to dynamically configure PostgreSQL to the specs of the machine it's running on (based on three different "usage patterns": web-based backend, online transaction processing, and data warehousing/business intelligence), and the other script was a very basic startup/init script for PostgreSQL. In the init script I put a few new lines (new to me, at least), so I figured I'd explain those.

First off, the lines in question:...

rocket357

Member

Posted in PostgreSQL Stuff

Views 3062 Comments 5 rocket357 is offline

PostgreSQL reconfigure script

Posted 02-10-2010 at 09:54 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-04-2011 at 09:42 AM by rocket357 (Added Version changelog to script)

UPDATE: Script has been revised and is available here

The following script is something I've written up to ease my duties as the PostgreSQL DBA for a large hosting company. It configures PostgreSQL according to whack-a-mole, and it auto-detects various resources such as system RAM, shared memory settings, etc...

The script currently supports Linux and OpenBSD (FreeBSD coming soon!).

Code:

#!/bin/sh

# configPG.sh:
#
# This script

...

rocket357

Member

Posted in PostgreSQL Stuff

Views 3348 Comments 2 rocket357 is offline

Logical Fallacy in "The Insecurity of OpenBSD"

Posted 01-22-2010 at 11:45 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 01-22-2010 at 01:05 PM by rocket357

First off, the blogpost:

http://allthatiswrong.wordpress.com/2010/01/20/the-insecurity-of-openbsd/

The argument here is NOT whether or not OpenBSD is secure, it's whether or not OpenBSD should implement ACL's. Granted, I'd like to see some more advanced capabilities here, too, but tossing the baby out with the bathwater seems quite silly. A new framework or mindset is needed to understand the problem.

The difference in approaches is simple. Let's say...

rocket357

Member

Posted in OpenBSD

Views 3423 Comments 3 rocket357 is offline

If Intel designed human beings...

Posted 01-01-2010 at 08:55 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 01-02-2010 at 09:55 PM by rocket357

The title is a quote from "Structured Computer Organization, Fifth Edition" by Andrew S. Tanenbaum. The full quote:

"If Intel designed human beings, it would have put in a bit that made them revert back to chimpanzee mode (most of the brain disabled, no speech, sleeps in trees, eats mostly bananas, etc.)."

I'm quite often seen around the internet using a "monkey with glasses" avatar (See it on my LQ profile), and on many occasions people...

rocket357

Member

Posted in Uncategorized

Views 1919 Comments 0 rocket357 is offline

RAID recommendations: my 2 cents

Posted 12-31-2009 at 10:26 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 12-31-2009 at 10:49 PM by rocket357

I recently read a heated debate on the age-old argument: should I use RAID 5 or RAID 10 for my database? I noted a particularly relevant treatment of the topic (read it here), and figured like any good DBA I'd chime in with my thoughts.

The basic premise for the argument (which was, oddly, from a business guru...NOT a tech geek) was that given a required performance level and budget, what setup would provide better data safety?

"Any DBA would ask you to give them...

rocket357

Member

Posted in Uncategorized

Views 1875 Comments 0 rocket357 is offline

Page 33 of 38

« First

Last »