LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Blogs
User Name
Password

Notices

Hi. I'm a Unix Administrator, 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: Unix.
Old

PostgreSQL 8.x backup caveat

Posted 03-24-2011 at 09:48 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-29-2011 at 07:58 AM by rocket357

During the deployment of our latest software revision (a major version bump that migrated all of our databases from MSSQL to Linux/PostgreSQL and migrated all of our web servers from Apache/PHP to Tomcat/GWT), we started hitting snags in IT operations immediately with database backups. When this major version revision came out, it allowed customers to store documents, photos, etc...directly in the database (something MSSQL 2005 isn't capable of). Doing a simple "pg_dump <opts> <dbname>"...
Member
Views 632 Comments 0 rocket357 is offline
Old

Updated PostgreSQL auto-configure script

Posted 03-04-2011 at 09:35 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-30-2011 at 03:19 PM by rocket357

I've altered the postgresql auto-configure script quite a bit since I last posted it. Here's the updated version:

Code:
#!/bin/sh

# configPG.sh:
#
# This script automatically detects system RAM and other resources
# and modifies $PG_DATA_DIR/postgresql.conf to configure the server
# for one of three uses:  web, oltp, or data warehousing.
# 
# Author: rocket357@users.sourceforge.net
# License: BSD
#
# This script
...
Member
Views 1689 Comments 0 rocket357 is offline
Old

Accidentally essential?

Posted 03-03-2011 at 10:45 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-03-2011 at 10:58 AM by rocket357

"Following Aristotle, I divide them into essence, the difficulties inherent in the nature of software, and accidents, those difficulties that today attend its production but are not inherent." -- Fred Brooks, "No Silver Bullet"

This is the second time I've referred to this particular paper on this blog. I've read it numerous times, and even though it was written in 1986, the facts set forth by Brooks still hold true today.

So there are two types...
Member
Posted in Uncategorized
Views 477 Comments 0 rocket357 is offline
Old

Fun with Win7 "security"

Posted 02-28-2011 at 02:30 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-30-2011 at 03:23 PM by rocket357

The other morning my neighbor stopped by and asked me if I could help him. "Sure thing.", I say. He explains that his mother's computer got a virus on it, and he's tried numerous times to fix it, but to no avail. Everytime he reboots the machine, the virus is back.

Now, I usually politely redirect requests like that to one of my many Windows-fluent friends...but my neighbor and his wife have been very good friends to us, so I want to help him out personally. I mean,...
Member
Posted in Microsoft Rants
Views 6442 Comments 2 rocket357 is offline
Old

To upgrade or not to upgrade...that is the question.

Posted 02-04-2011 at 12:17 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 02-04-2011 at 06:51 PM by rocket357 (typo)

I've refused to upgrade my workstation at work for years for fear I'd end up with a system that doesn't run OpenBSD very well. We recently had a departure and new hire, but the timeframe between one and the other was a few weeks. In the interim, I decided to test OpenBSD on the departure's brand new machine (it wasn't exactly a "departure", but we'll leave it at that). I now know the answer to the upgrade question...

The old machine was a P4 D with 2 GB RAM and a 250 GB...
Member
Posted in Uncategorized
Views 628 Comments 3 rocket357 is offline

  



All times are GMT -5. The time now is 06:24 PM.

Main Menu
Advertisement

My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration