Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
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.
PostgreSQL StuffAs far as databases go, and as far as I'm concerned, **this** is the good stuff.
Posted 03-24-2011 at 09:48 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-29-2011 at 07:58 AM byrocket357
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>"...
Posted 03-04-2011 at 09:35 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-30-2011 at 03:19 PM byrocket357
I've altered the postgresql auto-configure script quite a bit since I last posted it. Here's the updated version:
# 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: email@example.com
# License: BSD
# This script
Posted 02-12-2010 at 11:01 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 02-12-2010 at 11:55 AM byrocket357
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.
Posted 02-10-2010 at 09:54 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-04-2011 at 09:42 AM byrocket357(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!).